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
performance hurt after dropping the parititons oracle 10.2.0.3 and solaris 10 By: skumar.dba on Thu, 22 January 2009	4	2021	Tue, 27 January 2009 11:05 By: sonumalhi
Stale Stats for Partitoined table By: sonumalhi on Mon, 26 January 2009	2	3329	Tue, 27 January 2009 10:40 By: sonumalhi
Multiple schemas against single schema - ERP Oracle 10g By: rushimails on Sat, 24 January 2009	5	3682	Tue, 27 January 2009 04:53 By: Alessandro Rossi
Not able to reduce the optimizer cost after creating index By: dhanamukesh on Tue, 27 January 2009	2	1542	Tue, 27 January 2009 04:08 By: flyboy
Going for full table scan Oracle 10G /Linux By: dhanamukesh on Fri, 23 January 2009	3	1816	Mon, 26 January 2009 23:52 By: dhanamukesh
How to tune By: jolly_makkar on Sun, 25 January 2009	10	3416	Mon, 26 January 2009 03:33 By: Michel Cadot
Not sure what is causing the slow performance 10.2.0.1, Windows 2003 By: sant_new on Thu, 22 January 2009	4	2282	Sun, 25 January 2009 19:46 By: rleishman
How to interpret the tkprof output Oracle 9.2.0.8.0 - 64bit on HP-UX B.11.11 U By: madugular on Fri, 23 January 2009	5	5266	Sun, 25 January 2009 19:42 By: rleishman
high water mark (merged) By: varunvir on Fri, 23 January 2009	4	2670	Fri, 23 January 2009 19:58 By: varunvir
HOW to tune this query By: chaituu on Wed, 21 January 2009	5	2534	Fri, 23 January 2009 06:55 By: chaituu
Io cost too high Oracle 10G/Linux By: dhanamukesh on Tue, 20 January 2009	4	1635	Wed, 21 January 2009 10:25 By: JRowbottom
Concurrency and row cache lock problem in oracle10.2 oracle10.2 ,suse linux By: kordestaniamir on Wed, 21 January 2009	1	3980	Wed, 21 January 2009 06:53 By: Michel Cadot
converting Normal Table to Partitioned Table Oracle 10.2.0.4, SUSE linux 64 bit By: abs_amit on Mon, 19 January 2009	3	3296	Mon, 19 January 2009 02:43 By: Michel Cadot
Who is faster Cursor or Recored By: eng.oracle on Sat, 17 January 2009	7	2480	Sun, 18 January 2009 01:57 By: Michel Cadot
Performance Issue with FORALL BULK COLLECT By: srihari1974 on Sat, 17 January 2009	2	1588	Sat, 17 January 2009 13:00 By: Michel Cadot
Working slowley after 6 to 7hrs oracle 10g XP By: ragasudhai on Sat, 17 January 2009	2	1554	Sat, 17 January 2009 02:10 By: dhanuka.rajesh
How i can increase the performance of my query By: eng.oracle on Mon, 12 January 2009	10	2584	Sat, 17 January 2009 01:13 By: eng.oracle
Slowness of sql query (merged) By: kesavansundaram on Fri, 16 January 2009	2	1585	Fri, 16 January 2009 02:45 By: Michel Cadot
query taking lot of time oracle 10g By: pointers on Thu, 15 January 2009	4	2006	Fri, 16 January 2009 02:35 By: rleishman
Qurey taking much cost 10GR2 By: sanjayocp on Thu, 15 January 2009	2	1686	Fri, 16 January 2009 02:29 By: rleishman
Database slow after attaching new storage 9.2.0.6.0 on Solaris By: ajaysharma2907 on Tue, 13 January 2009	2	1789	Thu, 15 January 2009 05:57 By: rakeshgj_36
Performance issues 10gR2 By: nani_ar on Sun, 04 January 2009	9	4551	Thu, 15 January 2009 05:50 By: rakeshgj_36
Tempfile readtime and Writetime DB version 9.2.0.7 AIX By: dbcop on Tue, 13 January 2009	1	1560	Tue, 13 January 2009 10:45 By: Mahesh Rajendran
query taking lot of time 10.2.0.2 By: varunvir on Mon, 12 January 2009	6	2280	Tue, 13 January 2009 10:23 By: varunvir
Speed of query 10g By: maheshmhs on Tue, 30 December 2008	3	2240	Sun, 11 January 2009 18:07 By: Kevin Meade
Performance Prob with Group and Orader by clause Oracle DB version 9.2.0.7 on AIX By: dbcop on Thu, 08 January 2009	2	2727	Sun, 11 January 2009 18:04 By: Kevin Meade
Need help in Optimizing this query oracle 8i By: RiverX on Thu, 08 January 2009	5	2029	Sun, 11 January 2009 08:05 By: michael_bialik
Purge recyclebin By: varunvir on Thu, 08 January 2009	3	4483	Sun, 11 January 2009 01:09 By: Michel Cadot
Oracle 9i SQL not using MV. By: chintu00 on Wed, 24 December 2008	21	5911	Fri, 09 January 2009 11:54 By: chintu00
tuning sql query 10.2.0.2 By: varunvir on Tue, 06 January 2009	8	4419	Fri, 09 January 2009 03:20 By: cookiemonster
Select statement is causing performance issue By: ind9 on Thu, 08 January 2009	16	3640	Fri, 09 January 2009 03:10 By: cookiemonster
cpu usage during backup 10.2.0.2 By: varunvir on Thu, 08 January 2009	6	2239	Thu, 08 January 2009 21:24 By: varunvir
Optimized Query with LIKE Operator (merged) By: shankhan on Wed, 07 January 2009	8	5603	Thu, 08 January 2009 09:54 By: shankhan
Pga hit ratio Oracle 10g R2,Linux AS4 By: rsreddy28 on Wed, 07 January 2009	1	3987	Thu, 08 January 2009 00:47 By: Michel Cadot
PGA MEMORY LEAK Oracle Database 11g, 11.1.0.6, RHEL x86_64 By: andydba on Mon, 05 January 2009	1	4122	Tue, 06 January 2009 02:26 By: Frank Naude
Primary key index not working proper after import oracle 8.1.7.0.0 By: ajaysharma2907 on Mon, 05 January 2009	4	2601	Tue, 06 January 2009 02:02 By: michael_bialik
Performance problem (Merged) By: mamalik on Mon, 05 January 2009	9	2408	Mon, 05 January 2009 06:00 By: rleishman
Db writer Process By: dbcop on Fri, 02 January 2009	6	6464	Sat, 03 January 2009 10:16 By: BlackSwan
Performance issue in procedure due to cursors Oracle 9i By: vps_25 on Fri, 02 January 2009	2	2375	Fri, 02 January 2009 19:25 By: rleishman
sql tuning oracle 10g By: radhika_naidu on Fri, 02 January 2009	10	4011	Fri, 02 January 2009 08:26 By: S.Rajaram