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	2033	Tue, 27 January 2009 11:05 By: sonumalhi
Stale Stats for Partitoined table By: sonumalhi on Mon, 26 January 2009	2	3334	Tue, 27 January 2009 10:40 By: sonumalhi
Multiple schemas against single schema - ERP Oracle 10g By: rushimails on Sat, 24 January 2009	5	3693	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	1546	Tue, 27 January 2009 04:08 By: flyboy
Going for full table scan Oracle 10G /Linux By: dhanamukesh on Fri, 23 January 2009	3	1821	Mon, 26 January 2009 23:52 By: dhanamukesh
How to tune By: jolly_makkar on Sun, 25 January 2009	10	3422	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	2303	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	5286	Sun, 25 January 2009 19:42 By: rleishman
high water mark (merged) By: varunvir on Fri, 23 January 2009	4	2683	Fri, 23 January 2009 19:58 By: varunvir
HOW to tune this query By: chaituu on Wed, 21 January 2009	5	2548	Fri, 23 January 2009 06:55 By: chaituu
Io cost too high Oracle 10G/Linux By: dhanamukesh on Tue, 20 January 2009	4	1646	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	3990	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	3310	Mon, 19 January 2009 02:43 By: Michel Cadot
Who is faster Cursor or Recored By: eng.oracle on Sat, 17 January 2009	7	2494	Sun, 18 January 2009 01:57 By: Michel Cadot
Performance Issue with FORALL BULK COLLECT By: srihari1974 on Sat, 17 January 2009	2	1595	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	1560	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	2603	Sat, 17 January 2009 01:13 By: eng.oracle
Slowness of sql query (merged) By: kesavansundaram on Fri, 16 January 2009	2	1591	Fri, 16 January 2009 02:45 By: Michel Cadot
query taking lot of time oracle 10g By: pointers on Thu, 15 January 2009	4	2010	Fri, 16 January 2009 02:35 By: rleishman
Qurey taking much cost 10GR2 By: sanjayocp on Thu, 15 January 2009	2	1692	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	1798	Thu, 15 January 2009 05:57 By: rakeshgj_36
Performance issues 10gR2 By: nani_ar on Sun, 04 January 2009	9	4586	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	1571	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	2293	Tue, 13 January 2009 10:23 By: varunvir
Speed of query 10g By: maheshmhs on Tue, 30 December 2008	3	2250	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	2736	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	2043	Sun, 11 January 2009 08:05 By: michael_bialik
Purge recyclebin By: varunvir on Thu, 08 January 2009	3	4518	Sun, 11 January 2009 01:09 By: Michel Cadot
Oracle 9i SQL not using MV. By: chintu00 on Wed, 24 December 2008	21	5962	Fri, 09 January 2009 11:54 By: chintu00
tuning sql query 10.2.0.2 By: varunvir on Tue, 06 January 2009	8	4437	Fri, 09 January 2009 03:20 By: cookiemonster
Select statement is causing performance issue By: ind9 on Thu, 08 January 2009	16	3646	Fri, 09 January 2009 03:10 By: cookiemonster
cpu usage during backup 10.2.0.2 By: varunvir on Thu, 08 January 2009	6	2244	Thu, 08 January 2009 21:24 By: varunvir
Optimized Query with LIKE Operator (merged) By: shankhan on Wed, 07 January 2009	8	5622	Thu, 08 January 2009 09:54 By: shankhan
Pga hit ratio Oracle 10g R2,Linux AS4 By: rsreddy28 on Wed, 07 January 2009	1	4000	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	4141	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	2628	Tue, 06 January 2009 02:02 By: michael_bialik
Performance problem (Merged) By: mamalik on Mon, 05 January 2009	9	2438	Mon, 05 January 2009 06:00 By: rleishman
Db writer Process By: dbcop on Fri, 02 January 2009	6	6505	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	2393	Fri, 02 January 2009 19:25 By: rleishman
sql tuning oracle 10g By: radhika_naidu on Fri, 02 January 2009	10	4034	Fri, 02 January 2009 08:26 By: S.Rajaram