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
Interpret STATSPack Report By: faiz_hyd on Wed, 15 November 2006	0	4939	Wed, 15 November 2006 14:38 By: faiz_hyd
Pls help in reducing the buffer gets for the query below By: aarti.mishra on Fri, 08 September 2006	7	8117	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	2735	Wed, 15 November 2006 07:52 By: JRowbottom
Analyze tables By: seema.taunk on Mon, 13 November 2006	7	6782	Tue, 14 November 2006 22:52 By: seema.taunk
Regarding Autotrace execution Plan By: reena_ch30 on Mon, 13 November 2006	3	2597	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	6492	Mon, 13 November 2006 22:40 By: Mohammad Taj
Query Optimization problem... By: deepayan on Tue, 07 November 2006	2	3901	Mon, 13 November 2006 19:50 By: rleishman
Analyze SYS_IL0000 LOB Indexes By: venkatp6 on Mon, 13 November 2006	1	6788	Mon, 13 November 2006 12:18 By: Mahesh Rajendran
Index not used in outer join query By: lars3006 on Wed, 08 November 2006	10	19459	Fri, 10 November 2006 18:51 By: rleishman
Parrallel Query Problem By: rkl1 on Fri, 10 November 2006	0	3924	Fri, 10 November 2006 15:10 By: rkl1
PB statistic CBO By: Haler on Fri, 10 November 2006	4	2184	Fri, 10 November 2006 12:54 By: Haler
Perfomace issues on complex query By: jaydba on Wed, 01 November 2006	9	2569	Thu, 09 November 2006 11:06 By: jaydba
Creating PK in Each table By: selvakumar_82 on Mon, 06 November 2006	7	2622	Thu, 09 November 2006 02:38 By: JRowbottom
help need in optimizing a query.... By: chandanbhamra on Tue, 07 November 2006	0	4287	Tue, 07 November 2006 05:10 By: chandanbhamra
Performance thumb-rules By: panda on Wed, 01 November 2006	5	4790	Tue, 07 November 2006 02:44 By: kimant
Library Cache OVERHEAD By: orafaqdba on Mon, 06 November 2006	0	3932	Mon, 06 November 2006 12:53 By: orafaqdba
insert statement runs very slow By: beastjj on Mon, 06 November 2006	1	2326	Mon, 06 November 2006 02:28 By: beastjj
v$librarycache By: Anand Ramaswamy on Fri, 03 November 2006	3	1839	Sun, 05 November 2006 13:35 By: kimant
Tuning SQL statement in PL/SQL By: Akshar on Mon, 30 October 2006	12	3131	Sat, 04 November 2006 15:20 By: Akshar
Will Deleting rows from Table improve Performance? By: kumarsz on Sat, 04 November 2006	2	2139	Sat, 04 November 2006 14:12 By: kimant
insert statement runs slow By: Akshar on Fri, 27 October 2006	7	9332	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	2342	Sat, 04 November 2006 03:08 By: jiltin
how to change this query, runs forever By: leahchow on Thu, 02 November 2006	1	2107	Fri, 03 November 2006 00:25 By: rleishman
Partition Criteria By: piyushbhatt on Thu, 19 October 2006	2	1996	Thu, 02 November 2006 08:24 By: michael_bialik
Tuning the query - Outer join By: bagulia_pilla on Tue, 31 October 2006	4	2371	Thu, 02 November 2006 02:12 By: S.Rajaram
Performance tuning a table By: ezhilv on Mon, 30 October 2006	3	1972	Wed, 01 November 2006 07:00 By: michael_bialik
Advice on Hints By: ravgopal on Thu, 26 October 2006	7	3926	Mon, 30 October 2006 16:57 By: rleishman
STATS and Last Analyzed Column By: faiz_hyd on Mon, 30 October 2006	0	9237	Mon, 30 October 2006 11:01 By: faiz_hyd
datafile random read average time By: seema.taunk on Fri, 27 October 2006	2	7215	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	3263	Mon, 30 October 2006 03:16 By: a_developer
Find the Explain Plan from Trace File By: bellpk on Tue, 24 October 2006	2	4036	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	2131	Sat, 28 October 2006 00:05 By: Mohammad Taj
problem when dropping table By: aline on Mon, 23 October 2006	6	4091	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	8450	Fri, 27 October 2006 09:54 By: caraless
Check v$sqlarea for shared cursors By: reena_ch30 on Thu, 26 October 2006	5	1984	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	1828	Fri, 27 October 2006 00:33 By: reena_ch30
Update vs CTAS By: a_developer on Thu, 26 October 2006	2	2164	Thu, 26 October 2006 10:02 By: Kevin Meade
Regarding v$librarycache By: reena_ch30 on Thu, 19 October 2006	5	2183	Thu, 26 October 2006 05:34 By: reena_ch30
Help Deciding on Local or Global Index By: mdoakes42 on Wed, 25 October 2006	1	2453	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	11977	Wed, 25 October 2006 02:41 By: beastjj