|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
IN Sub-query select performing poorly Oracle DB 10.2.0.2 RHEL4 |
6 |
1957 |
Tue, 06 November 2007 13:33 By: TLegend33 ![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 Bottleneck!!! Oracle 10.2.0.1.0, HP-UX v1 |
1 |
1315 |
Tue, 06 November 2007 07:13 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) |
|
sql slow |
5 |
1733 |
Tue, 06 November 2007 04:07 By: mwansalovewell ![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) |
|
Help Please |
5 |
1942 |
Mon, 05 November 2007 15:46 By: BlackSwan ![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) |
|
Help needed in querying View |
2 |
1832 |
Sun, 04 November 2007 16:33 By: BlackSwan ![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) |
|
Different Query Plan and execution time of same Query ORACLE 10g |
2 |
2532 |
Fri, 02 November 2007 06:46 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) |
|
Anti-Join (HASH_AJ) with multiple columns in the "NOT IN" clause By: hellcat on Wed, 31 October 2007 |
4 |
7410 |
Thu, 01 November 2007 21:58 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) |
|
reading AWR report oracle 10g windown 2003 server |
0 |
10120 |
Thu, 01 November 2007 12:25 By: skumar.dba ![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 out query is taking full table scan or index scan |
2 |
1998 |
Thu, 01 November 2007 09:05 By: Mohammad Taj ![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 problem By: Nokia on Wed, 24 October 2007 |
13 |
4298 |
Wed, 31 October 2007 17:23 By: Nokia ![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) |
|
Parallel Query yields High Consistent Gets vs Serial Oracle RDBMS 9.2.7 |
1 |
1564 |
Tue, 30 October 2007 17:48 By: BlackSwan ![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) |
|
statspack report oracle 10g windows 2003 server |
1 |
1296 |
Tue, 30 October 2007 15:16 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) |
|
export statistics form production to test database oracle 10g, solaris 9 , redhat linux AS4 |
11 |
5174 |
Tue, 30 October 2007 00: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) |
|
Fragmented Tables |
2 |
2870 |
Mon, 29 October 2007 20:50 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) |
|
difference between locking and disabling statistics oracle10g |
1 |
1311 |
Mon, 29 October 2007 14:47 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) |
|
How to place many datafile on large tablespace? 9.2i, OS AIX |
3 |
1379 |
Mon, 29 October 2007 03: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) |
|
hint: first_rows |
13 |
4083 |
Sun, 28 October 2007 23:01 By: tanmoy1048 ![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) |
|
Speed Diffrence |
4 |
1823 |
Sat, 27 October 2007 12:29 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) |
|
want to reduce the COST Oracle 11i , DB - 9.2.0 |
7 |
1997 |
Sat, 27 October 2007 05:07 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) |
|
find the query/plsql block which is causing performance hurt oracle 10.2.0.2 solaris 10 |
1 |
1339 |
Thu, 25 October 2007 11:48 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) |
|
Slow SQL with dedicated server? By: hristo on Thu, 25 October 2007 |
4 |
1528 |
Thu, 25 October 2007 04:52 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) |
|
materialized view |
1 |
1322 |
Thu, 25 October 2007 02:03 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) |
|
How to creating index? for best performance How to creating index? for best performance |
2 |
1406 |
Thu, 25 October 2007 01:22 By: send.shakthi ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Join query gettin poor performance |
2 |
1842 |
Wed, 24 October 2007 00: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) |
|
Cached Cursor |
2 |
3852 |
Tue, 23 October 2007 11:13 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) |
|
Performance impact on Oracle websphere application, oracle 9 database |
3 |
1814 |
Tue, 23 October 2007 09:12 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) |
|
why ESTD_PHYSICAL_READS and ESTD_PHYSICAL_READ_TIME are not change in proportional in v$db_cache_a By: wqhhust on Sun, 21 October 2007 |
1 |
3370 |
Sun, 21 October 2007 10:09 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) |
|
Optimizing specific client query Optimizing specific client query By: mleduc on Thu, 18 October 2007 |
1 |
1597 |
Thu, 18 October 2007 10:16 By: BlackSwan ![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) |
|
collect Plan By: Majaa on Thu, 18 October 2007 |
1 |
1599 |
Thu, 18 October 2007 08:16 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) |
|
DB Block Buffer value By: Creems on Thu, 18 October 2007 |
2 |
3644 |
Thu, 18 October 2007 02:59 By: Creems ![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) |
|
Processes and Sessions By: dirish on Fri, 27 July 2007 |
25 |
4821 |
Thu, 18 October 2007 02: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) |
|
Interpretation of Alert Log Errors By: Creems on Thu, 18 October 2007 |
1 |
1612 |
Thu, 18 October 2007 02:37 By: Mohammad Taj ![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) |
|
EXPLAIN PLAN CHANGE After migration plan getting changed. |
21 |
3675 |
Wed, 17 October 2007 16:47 By: flyboy ![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) |
|
Stats Gathering on Whole Schema |
4 |
2778 |
Wed, 17 October 2007 12:31 By: BlackSwan ![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) |
|
Running queries parallely By: vkrmhj on Wed, 17 October 2007 |
1 |
1670 |
Wed, 17 October 2007 07:04 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) |
|
autotrace autotrace on |
6 |
1843 |
Wed, 17 October 2007 05:10 By: rikfair ![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) |
|
Regarding sort optimsation (merged) |
8 |
2426 |
Tue, 16 October 2007 09:20 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) |
|
sql performance issue. |
4 |
2384 |
Tue, 16 October 2007 08:41 By: arunprasad_bh ![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) |
|
Reading DBMS_XPLAN output By: emreb on Tue, 16 October 2007 |
5 |
4175 |
Tue, 16 October 2007 05:22 By: emreb ![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) |
|
parallel query By: vkrmhj on Tue, 16 October 2007 |
4 |
1823 |
Tue, 16 October 2007 03:15 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |