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
Stale Stats for Partitoined table By: sonumalhi on Mon, 26 January 2009	2	3142	Tue, 27 January 2009 10:40 By: sonumalhi
Multiple schemas against single schema - ERP Oracle 10g By: rushimails on Sat, 24 January 2009	5	3516	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	1364	Tue, 27 January 2009 04:08 By: flyboy
Going for full table scan Oracle 10G /Linux By: dhanamukesh on Fri, 23 January 2009	3	1644	Mon, 26 January 2009 23:52 By: dhanamukesh
How to tune By: jolly_makkar on Sun, 25 January 2009	10	3192	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	2089	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	5040	Sun, 25 January 2009 19:42 By: rleishman
high water mark (merged) By: varunvir on Fri, 23 January 2009	4	2476	Fri, 23 January 2009 19:58 By: varunvir
HOW to tune this query By: chaituu on Wed, 21 January 2009	5	2317	Fri, 23 January 2009 06:55 By: chaituu
Io cost too high Oracle 10G/Linux By: dhanamukesh on Tue, 20 January 2009	4	1440	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	3813	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	3117	Mon, 19 January 2009 02:43 By: Michel Cadot
Who is faster Cursor or Recored By: eng.oracle on Sat, 17 January 2009	7	2235	Sun, 18 January 2009 01:57 By: Michel Cadot
Performance Issue with FORALL BULK COLLECT By: srihari1974 on Sat, 17 January 2009	2	1397	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	1346	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	2303	Sat, 17 January 2009 01:13 By: eng.oracle
Slowness of sql query (merged) By: kesavansundaram on Fri, 16 January 2009	2	1392	Fri, 16 January 2009 02:45 By: Michel Cadot
query taking lot of time oracle 10g By: pointers on Thu, 15 January 2009	4	1800	Fri, 16 January 2009 02:35 By: rleishman
Qurey taking much cost 10GR2 By: sanjayocp on Thu, 15 January 2009	2	1503	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	1600	Thu, 15 January 2009 05:57 By: rakeshgj_36
Performance issues 10gR2 By: nani_ar on Sun, 04 January 2009	9	4285	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	1380	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	2068	Tue, 13 January 2009 10:23 By: varunvir
Speed of query 10g By: maheshmhs on Tue, 30 December 2008	3	2057	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	2554	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	1842	Sun, 11 January 2009 08:05 By: michael_bialik
Purge recyclebin By: varunvir on Thu, 08 January 2009	3	4287	Sun, 11 January 2009 01:09 By: Michel Cadot
Oracle 9i SQL not using MV. By: chintu00 on Wed, 24 December 2008	21	5610	Fri, 09 January 2009 11:54 By: chintu00
tuning sql query 10.2.0.2 By: varunvir on Tue, 06 January 2009	8	4197	Fri, 09 January 2009 03:20 By: cookiemonster
Select statement is causing performance issue By: ind9 on Thu, 08 January 2009	16	3410	Fri, 09 January 2009 03:10 By: cookiemonster
cpu usage during backup 10.2.0.2 By: varunvir on Thu, 08 January 2009	6	2043	Thu, 08 January 2009 21:24 By: varunvir
Optimized Query with LIKE Operator (merged) By: shankhan on Wed, 07 January 2009	8	5399	Thu, 08 January 2009 09:54 By: shankhan
Pga hit ratio Oracle 10g R2,Linux AS4 By: rsreddy28 on Wed, 07 January 2009	1	3827	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	3953	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	2433	Tue, 06 January 2009 02:02 By: michael_bialik
Performance problem (Merged) By: mamalik on Mon, 05 January 2009	9	2224	Mon, 05 January 2009 06:00 By: rleishman
Db writer Process By: dbcop on Fri, 02 January 2009	6	6279	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	2205	Fri, 02 January 2009 19:25 By: rleishman
sql tuning oracle 10g By: radhika_naidu on Fri, 02 January 2009	10	3804	Fri, 02 January 2009 08:26 By: S.Rajaram
SQL/PL/SQL Tunning Hints Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 By: sonalir on Fri, 02 January 2009	1	4184	Fri, 02 January 2009 04:01 By: Michel Cadot