OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Pls help in reducing the buffer gets for the query below By: aarti.mishra on Fri, 08 September 2006	7	7896	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	2508	Wed, 15 November 2006 07:52 By: JRowbottom
Analyze tables By: seema.taunk on Mon, 13 November 2006	7	6550	Tue, 14 November 2006 22:52 By: seema.taunk
Regarding Autotrace execution Plan By: reena_ch30 on Mon, 13 November 2006	3	2404	Tue, 14 November 2006 00:49 By: Mohammad Taj
Difference between SORT_MULTIBLOCK_READ_COUNT and DB_MULTIBLOCK_READ_COUNT By: reena_ch30 on Sun, 12 November 2006	3	6268	Mon, 13 November 2006 22:40 By: Mohammad Taj
Query Optimization problem... By: deepayan on Tue, 07 November 2006	2	3707	Mon, 13 November 2006 19:50 By: rleishman
Analyze SYS_IL0000 LOB Indexes By: venkatp6 on Mon, 13 November 2006	1	6590	Mon, 13 November 2006 12:18 By: Mahesh Rajendran
Index not used in outer join query By: lars3006 on Wed, 08 November 2006	10	19131	Fri, 10 November 2006 18:51 By: rleishman
Parrallel Query Problem By: rkl1 on Fri, 10 November 2006	0	3734	Fri, 10 November 2006 15:10 By: rkl1
PB statistic CBO By: Haler on Fri, 10 November 2006	4	1979	Fri, 10 November 2006 12:54 By: Haler
Perfomace issues on complex query By: jaydba on Wed, 01 November 2006	9	2319	Thu, 09 November 2006 11:06 By: jaydba
Creating PK in Each table By: selvakumar_82 on Mon, 06 November 2006	7	2397	Thu, 09 November 2006 02:38 By: JRowbottom
help need in optimizing a query.... By: chandanbhamra on Tue, 07 November 2006	0	4110	Tue, 07 November 2006 05:10 By: chandanbhamra
Performance thumb-rules By: panda on Wed, 01 November 2006	5	4574	Tue, 07 November 2006 02:44 By: kimant
Library Cache OVERHEAD By: orafaqdba on Mon, 06 November 2006	0	3738	Mon, 06 November 2006 12:53 By: orafaqdba
insert statement runs very slow By: beastjj on Mon, 06 November 2006	1	2146	Mon, 06 November 2006 02:28 By: beastjj
v$librarycache By: Anand Ramaswamy on Fri, 03 November 2006	3	1628	Sun, 05 November 2006 13:35 By: kimant
Tuning SQL statement in PL/SQL By: Akshar on Mon, 30 October 2006	12	2838	Sat, 04 November 2006 15:20 By: Akshar
Will Deleting rows from Table improve Performance? By: kumarsz on Sat, 04 November 2006	2	1947	Sat, 04 November 2006 14:12 By: kimant
insert statement runs slow By: Akshar on Fri, 27 October 2006	7	9122	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	2105	Sat, 04 November 2006 03:08 By: jiltin
how to change this query, runs forever By: leahchow on Thu, 02 November 2006	1	1928	Fri, 03 November 2006 00:25 By: rleishman
Partition Criteria By: piyushbhatt on Thu, 19 October 2006	2	1829	Thu, 02 November 2006 08:24 By: michael_bialik
Tuning the query - Outer join By: bagulia_pilla on Tue, 31 October 2006	4	2183	Thu, 02 November 2006 02:12 By: S.Rajaram
Performance tuning a table By: ezhilv on Mon, 30 October 2006	3	1789	Wed, 01 November 2006 07:00 By: michael_bialik
Advice on Hints By: ravgopal on Thu, 26 October 2006	7	3743	Mon, 30 October 2006 16:57 By: rleishman
STATS and Last Analyzed Column By: faiz_hyd on Mon, 30 October 2006	0	9054	Mon, 30 October 2006 11:01 By: faiz_hyd
datafile random read average time By: seema.taunk on Fri, 27 October 2006	2	6962	Mon, 30 October 2006 03:53 By: seema.taunk
Copying statistics of one table to another By: a_developer on Mon, 30 October 2006	2	3100	Mon, 30 October 2006 03:16 By: a_developer
Find the Explain Plan from Trace File By: bellpk on Tue, 24 October 2006	2	3858	Sun, 29 October 2006 23:27 By: bellpk
move all objects from tbs to new tbs /rebuild all indexes to new tbs By: caraless on Fri, 27 October 2006	1	1945	Sat, 28 October 2006 00:05 By: Mohammad Taj
problem when dropping table By: aline on Mon, 23 October 2006	6	3895	Fri, 27 October 2006 19:02 By: rleishman
Reorganization of data/ Eliminate database fragmentation (export, drop and re-import tables) By: caraless on Thu, 26 October 2006	10	8254	Fri, 27 October 2006 09:54 By: caraless
Check v$sqlarea for shared cursors By: reena_ch30 on Thu, 26 October 2006	5	1805	Fri, 27 October 2006 00:58 By: reena_ch30
setting trace file name created using sql trace By: reena_ch30 on Thu, 26 October 2006	2	1656	Fri, 27 October 2006 00:33 By: reena_ch30
Update vs CTAS By: a_developer on Thu, 26 October 2006	2	1950	Thu, 26 October 2006 10:02 By: Kevin Meade
Regarding v$librarycache By: reena_ch30 on Thu, 19 October 2006	5	2003	Thu, 26 October 2006 05:34 By: reena_ch30
Help Deciding on Local or Global Index By: mdoakes42 on Wed, 25 October 2006	1	2281	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	11743	Wed, 25 October 2006 02:41 By: beastjj
Search option By: selvakumar_82 on Fri, 20 October 2006	3	1846	Wed, 25 October 2006 00:29 By: rleishman