|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Pls help in reducing the buffer gets for the query below |
7 |
8047 |
Wed, 15 November 2006 10:11 By: skn ![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) |
|
I need a listing of Oracle indexes and how often they are used, how? By: aidi-h on Fri, 10 November 2006 |
7 |
2670 |
Wed, 15 November 2006 07:52 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) |
|
Analyze tables |
7 |
6720 |
Tue, 14 November 2006 22:52 By: seema.taunk ![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 Autotrace execution Plan |
3 |
2549 |
Tue, 14 November 2006 00:49 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) |
|
Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_COUNT |
3 |
6431 |
Mon, 13 November 2006 22:40 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) |
|
Query Optimization problem... |
2 |
3862 |
Mon, 13 November 2006 19: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) |
![icon14.gif](/forum/images/message_icons/icon14.gif) |
Analyze SYS_IL0000 LOB Indexes |
1 |
6754 |
Mon, 13 November 2006 12:18 By: Mahesh Rajendran ![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 not used in outer join query |
10 |
19368 |
Fri, 10 November 2006 18:51 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) |
|
Parrallel Query Problem By: rkl1 on Fri, 10 November 2006 |
0 |
3888 |
Fri, 10 November 2006 15:10 By: rkl1 ![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) |
|
PB statistic CBO By: Haler on Fri, 10 November 2006 |
4 |
2130 |
Fri, 10 November 2006 12:54 By: Haler ![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) |
|
Perfomace issues on complex query By: jaydba on Wed, 01 November 2006 |
9 |
2480 |
Thu, 09 November 2006 11:06 By: jaydba ![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) |
|
Creating PK in Each table |
7 |
2550 |
Thu, 09 November 2006 02:38 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) |
|
help need in optimizing a query.... |
0 |
4255 |
Tue, 07 November 2006 05:10 By: chandanbhamra ![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 thumb-rules By: panda on Wed, 01 November 2006 |
5 |
4730 |
Tue, 07 November 2006 02:44 By: kimant ![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) |
|
Library Cache OVERHEAD |
0 |
3889 |
Mon, 06 November 2006 12:53 By: orafaqdba ![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 statement runs very slow By: beastjj on Mon, 06 November 2006 |
1 |
2286 |
Mon, 06 November 2006 02:28 By: beastjj ![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) |
|
v$librarycache |
3 |
1775 |
Sun, 05 November 2006 13:35 By: kimant ![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) |
|
Tuning SQL statement in PL/SQL By: Akshar on Mon, 30 October 2006 |
12 |
3009 |
Sat, 04 November 2006 15:20 By: Akshar ![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) |
|
Will Deleting rows from Table improve Performance? By: kumarsz on Sat, 04 November 2006 |
2 |
2088 |
Sat, 04 November 2006 14:12 By: kimant ![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 statement runs slow By: Akshar on Fri, 27 October 2006 |
7 |
9283 |
Sat, 04 November 2006 03:23 By: Admin@Lightsql.Com ![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) |
|
Inserts, update are taking long to execute. How to tune it? By: jiltin on Wed, 27 September 2006 |
3 |
2288 |
Sat, 04 November 2006 03:08 By: jiltin ![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 change this query, runs forever |
1 |
2075 |
Fri, 03 November 2006 00: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) |
|
Partition Criteria |
2 |
1968 |
Thu, 02 November 2006 08:24 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) |
|
Tuning the query - Outer join |
4 |
2329 |
Thu, 02 November 2006 02:12 By: S.Rajaram ![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 tuning a table By: ezhilv on Mon, 30 October 2006 |
3 |
1931 |
Wed, 01 November 2006 07:00 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) |
|
Advice on Hints |
7 |
3883 |
Mon, 30 October 2006 16:57 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) |
|
STATS and Last Analyzed Column |
0 |
9212 |
Mon, 30 October 2006 11:01 By: faiz_hyd ![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) |
|
datafile random read average time |
2 |
7176 |
Mon, 30 October 2006 03:53 By: seema.taunk ![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) |
|
Copying statistics of one table to another |
2 |
3239 |
Mon, 30 October 2006 03:16 By: a_developer ![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 Explain Plan from Trace File By: bellpk on Tue, 24 October 2006 |
2 |
4003 |
Sun, 29 October 2006 23:27 By: bellpk ![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) |
|
move all objects from tbs to new tbs /rebuild all indexes to new tbs |
1 |
2096 |
Sat, 28 October 2006 00: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) |
|
problem when dropping table By: aline on Mon, 23 October 2006 |
6 |
4045 |
Fri, 27 October 2006 19:02 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) |
|
Reorganization of data/ Eliminate database fragmentation (export, drop and re-import tables) |
10 |
8404 |
Fri, 27 October 2006 09:54 By: caraless ![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) |
|
Check v$sqlarea for shared cursors |
5 |
1950 |
Fri, 27 October 2006 00:58 By: reena_ch30 ![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) |
|
setting trace file name created using sql trace |
2 |
1799 |
Fri, 27 October 2006 00:33 By: reena_ch30 ![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) |
|
Update vs CTAS |
2 |
2114 |
Thu, 26 October 2006 10:02 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) |
|
Regarding v$librarycache |
5 |
2131 |
Thu, 26 October 2006 05:34 By: reena_ch30 ![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 Deciding on Local or Global Index |
1 |
2419 |
Wed, 25 October 2006 21: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) |
|
Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME By: beastjj on Wed, 25 October 2006 |
0 |
11933 |
Wed, 25 October 2006 02:41 By: beastjj ![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) |
|
Search option |
3 |
2006 |
Wed, 25 October 2006 00:29 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |