|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon12.gif](/forum/images/message_icons/icon12.gif) |
Performance tuning for a simple table with 2million records Oracle 10g, windows server series |
2 |
1807 |
Mon, 17 November 2008 21:51 By: Oyunbold ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query optimization By: prem18 on Mon, 17 November 2008 |
2 |
2110 |
Mon, 17 November 2008 19:44 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Wait events 10g,linux |
1 |
1454 |
Mon, 17 November 2008 04:51 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Error in Materialized view refresh Oracle Database |
3 |
2825 |
Sat, 15 November 2008 14:04 By: Littlefoot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
package performance oracle10.2.0.3 |
3 |
1882 |
Fri, 14 November 2008 23:10 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Interpreting "Row Source Operation" Output of TKPROF Oracle 9iR2 |
6 |
4422 |
Thu, 13 November 2008 19:24 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
High Logical Reads 10g R2, 10.2.0.2, win 2003 stnd sp2 |
2 |
1794 |
Wed, 12 November 2008 22:58 By: kummi_gh ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Find speed oracle 10 g |
6 |
2200 |
Wed, 12 November 2008 10:55 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query taking very long time Oracle 10g By: virmahi on Fri, 07 November 2008 |
4 |
2856 |
Tue, 11 November 2008 20:44 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Dunsel Joins 9i, 10g, 11g |
4 |
3964 |
Tue, 11 November 2008 20:39 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Wait events 9i (9.2.0.1) Windows 2003 |
1 |
1554 |
Tue, 11 November 2008 12:32 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
gets,pins and reloads in v$library Cache |
2 |
1522 |
Tue, 11 November 2008 02:07 By: Littlefoot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SESSION CPU AIX 10G |
5 |
1601 |
Mon, 10 November 2008 11:27 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Tuning O9i By: manoj12 on Mon, 10 November 2008 |
1 |
2117 |
Mon, 10 November 2008 01:36 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance Issue: Steps that need to take care of Oracle9i By: Olivia on Wed, 05 November 2008 |
2 |
1575 |
Fri, 07 November 2008 01:06 By: virmahi ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance: partition/index not used Oracle 10.2G By: wakula on Wed, 05 November 2008 |
1 |
1602 |
Thu, 06 November 2008 01:28 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index a system view 10g on IBM AIX By: serkzc on Wed, 05 November 2008 |
1 |
1734 |
Wed, 05 November 2008 23:29 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Dirty database_Performance issues |
2 |
1901 |
Tue, 04 November 2008 19:36 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Purgeing data 9i and 10g |
4 |
1848 |
Tue, 04 November 2008 19:35 By: Kevin Meade ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Tuning Oracle 10g By: rsoma on Fri, 31 October 2008 |
3 |
1860 |
Tue, 04 November 2008 13:52 By: coleing ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Gather statistics for scale up / down decision process |
3 |
2016 |
Tue, 04 November 2008 08:41 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
gather stats how? |
13 |
4969 |
Tue, 04 November 2008 07:04 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
select does a full table scan. 130.000.000 rows Oracle 9 By: mclu on Fri, 31 October 2008 |
5 |
3615 |
Tue, 04 November 2008 05:34 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Whether Statistics upto date or not oracle 9i By: Olivia on Tue, 04 November 2008 |
2 |
1643 |
Tue, 04 November 2008 04:58 By: Olivia ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Packaged procedure tuning Oracle,10g,Windows XP |
1 |
1462 |
Sun, 02 November 2008 22:25 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
alter system set events oracle10g |
3 |
8413 |
Sun, 02 November 2008 10:15 By: sasnrock ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Insert Oddly Alters Explain Plan Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: annagel on Tue, 28 October 2008 |
4 |
3127 |
Thu, 30 October 2008 09:43 By: annagel ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance issues between Databases Oracle 10.2.0 |
12 |
4661 |
Thu, 30 October 2008 08:06 By: Kevin Meade ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Thread 1 cannot allocate new log, sequence 8823--Checkpoint not complete Oracle 10.2, Win 2003 |
6 |
13651 |
Wed, 29 October 2008 20:56 By: ebrian ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Do you know how to find out the underlying tables for a dynamic view? Oracle 11g, 11.1.0, Windows 2K3 By: efachim on Fri, 24 October 2008 |
2 |
1564 |
Fri, 24 October 2008 16:50 By: efachim ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
High CPU Utilizaion 10.2.0.2 |
4 |
5327 |
Thu, 23 October 2008 23:21 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
oracle volume Oracle 10g |
1 |
1438 |
Thu, 23 October 2008 05:35 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
What is the significance of this data dictionary column? Oracle 11g, 11.1.0, Linux By: efachim on Wed, 22 October 2008 |
3 |
1974 |
Wed, 22 October 2008 23:08 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Looking for a better access method Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: annagel on Tue, 21 October 2008 |
7 |
4161 |
Wed, 22 October 2008 19:39 By: annagel ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Bitmap conversion |
0 |
6631 |
Wed, 22 October 2008 14:06 By: ArvindBhope ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
response time |
3 |
1475 |
Wed, 22 October 2008 07:58 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need help in tuning this query |
5 |
2219 |
Wed, 22 October 2008 03:20 By: Alessandro Rossi ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Rewrite in Materialised Views (merged) |
3 |
1622 |
Wed, 22 October 2008 03:00 By: hexmanju ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance Query Tuning help By: rsoma on Fri, 17 October 2008 |
6 |
2419 |
Tue, 21 October 2008 22:27 By: rsoma ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Please help me Tune this query By: rak007 on Thu, 16 October 2008 |
4 |
4023 |
Tue, 21 October 2008 16:36 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |