|
|
Topic |
Replies |
Views |
Last message |
|
|
Pls help in reducing the buffer gets for the query below |
7 |
7945 |
Wed, 15 November 2006 10:11 By: skn |
|
|
I need a listing of Oracle indexes and how often they are used, how? By: aidi-h on Fri, 10 November 2006 |
7 |
2554 |
Wed, 15 November 2006 07:52 By: JRowbottom |
|
|
Analyze tables |
7 |
6595 |
Tue, 14 November 2006 22:52 By: seema.taunk |
|
|
Regarding Autotrace execution Plan |
3 |
2449 |
Tue, 14 November 2006 00:49 By: Mohammad Taj |
|
|
Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_COUNT |
3 |
6334 |
Mon, 13 November 2006 22:40 By: Mohammad Taj |
|
|
Query Optimization problem... |
2 |
3758 |
Mon, 13 November 2006 19:50 By: rleishman |
|
|
Analyze SYS_IL0000 LOB Indexes |
1 |
6649 |
Mon, 13 November 2006 12:18 By: Mahesh Rajendran |
|
|
Index not used in outer join query |
10 |
19208 |
Fri, 10 November 2006 18:51 By: rleishman |
|
|
Parrallel Query Problem By: rkl1 on Fri, 10 November 2006 |
0 |
3783 |
Fri, 10 November 2006 15:10 By: rkl1 |
|
|
PB statistic CBO By: Haler on Fri, 10 November 2006 |
4 |
2024 |
Fri, 10 November 2006 12:54 By: Haler |
|
|
Perfomace issues on complex query By: jaydba on Wed, 01 November 2006 |
9 |
2370 |
Thu, 09 November 2006 11:06 By: jaydba |
|
|
Creating PK in Each table |
7 |
2437 |
Thu, 09 November 2006 02:38 By: JRowbottom |
|
|
help need in optimizing a query.... |
0 |
4158 |
Tue, 07 November 2006 05:10 By: chandanbhamra |
|
|
Performance thumb-rules By: panda on Wed, 01 November 2006 |
5 |
4631 |
Tue, 07 November 2006 02:44 By: kimant |
|
|
Library Cache OVERHEAD |
0 |
3782 |
Mon, 06 November 2006 12:53 By: orafaqdba |
|
|
insert statement runs very slow By: beastjj on Mon, 06 November 2006 |
1 |
2187 |
Mon, 06 November 2006 02:28 By: beastjj |
|
|
v$librarycache |
3 |
1671 |
Sun, 05 November 2006 13:35 By: kimant |
|
|
Tuning SQL statement in PL/SQL By: Akshar on Mon, 30 October 2006 |
12 |
2893 |
Sat, 04 November 2006 15:20 By: Akshar |
|
|
Will Deleting rows from Table improve Performance? By: kumarsz on Sat, 04 November 2006 |
2 |
1992 |
Sat, 04 November 2006 14:12 By: kimant |
|
|
insert statement runs slow By: Akshar on Fri, 27 October 2006 |
7 |
9164 |
Sat, 04 November 2006 03:23 By: Admin@Lightsql.Com |
|
|
Inserts, update are taking long to execute. How to tune it? By: jiltin on Wed, 27 September 2006 |
3 |
2156 |
Sat, 04 November 2006 03:08 By: jiltin |
|
|
how to change this query, runs forever |
1 |
1970 |
Fri, 03 November 2006 00:25 By: rleishman |
|
|
Partition Criteria |
2 |
1880 |
Thu, 02 November 2006 08:24 By: michael_bialik |
|
|
Tuning the query - Outer join |
4 |
2231 |
Thu, 02 November 2006 02:12 By: S.Rajaram |
|
|
Performance tuning a table By: ezhilv on Mon, 30 October 2006 |
3 |
1830 |
Wed, 01 November 2006 07:00 By: michael_bialik |
|
|
Advice on Hints |
7 |
3793 |
Mon, 30 October 2006 16:57 By: rleishman |
|
|
STATS and Last Analyzed Column |
0 |
9100 |
Mon, 30 October 2006 11:01 By: faiz_hyd |
|
|
datafile random read average time |
2 |
7040 |
Mon, 30 October 2006 03:53 By: seema.taunk |
|
|
Copying statistics of one table to another |
2 |
3144 |
Mon, 30 October 2006 03:16 By: a_developer |
|
|
Find the Explain Plan from Trace File By: bellpk on Tue, 24 October 2006 |
2 |
3900 |
Sun, 29 October 2006 23:27 By: bellpk |
|
|
move all objects from tbs to new tbs /rebuild all indexes to new tbs |
1 |
1988 |
Sat, 28 October 2006 00:05 By: Mohammad Taj |
|
|
problem when dropping table By: aline on Mon, 23 October 2006 |
6 |
3945 |
Fri, 27 October 2006 19:02 By: rleishman |
|
|
Reorganization of data/ Eliminate database fragmentation (export, drop and re-import tables) |
10 |
8309 |
Fri, 27 October 2006 09:54 By: caraless |
|
|
Check v$sqlarea for shared cursors |
5 |
1851 |
Fri, 27 October 2006 00:58 By: reena_ch30 |
|
|
setting trace file name created using sql trace |
2 |
1705 |
Fri, 27 October 2006 00:33 By: reena_ch30 |
|
|
Update vs CTAS |
2 |
2002 |
Thu, 26 October 2006 10:02 By: Kevin Meade |
|
|
Regarding v$librarycache |
5 |
2043 |
Thu, 26 October 2006 05:34 By: reena_ch30 |
|
|
Help Deciding on Local or Global Index |
1 |
2332 |
Wed, 25 October 2006 21:36 By: rleishman |
|
|
Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME By: beastjj on Wed, 25 October 2006 |
0 |
11827 |
Wed, 25 October 2006 02:41 By: beastjj |
|
|
Search option |
3 |
1897 |
Wed, 25 October 2006 00:29 By: rleishman |