|
|
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 |
8088 |
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 |
2705 |
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 |
6753 |
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 |
2578 |
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 |
6469 |
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 |
3883 |
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 |
6776 |
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 |
19426 |
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 |
3909 |
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 |
2164 |
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 |
2536 |
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 |
2590 |
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 |
4269 |
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 |
4759 |
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 |
3919 |
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 |
2310 |
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 |
1806 |
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 |
3072 |
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 |
2117 |
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 |
9311 |
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 |
2324 |
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 |
2099 |
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 |
1986 |
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 |
2365 |
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 |
1960 |
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 |
3918 |
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 |
9228 |
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 |
7204 |
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 |
3259 |
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 |
4025 |
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 |
2110 |
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 |
4066 |
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 |
8419 |
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 |
1969 |
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 |
1818 |
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 |
2144 |
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 |
2165 |
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 |
2436 |
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 |
11961 |
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 |
2038 |
Wed, 25 October 2006 00:29 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |