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
Materialized View Vs Table functions Oracle 9i By: sundaravel_n on Thu, 29 January 2009	2	2747	Thu, 29 January 2009 05:48 By: JRowbottom
working with tkprof utility oracle 10g By: rajasekhar857 on Thu, 29 January 2009	5	3804	Thu, 29 January 2009 05:08 By: Michel Cadot
Hash cluster with small (tiny) rows ? 11g By: chris3110 on Mon, 26 January 2009	5	4108	Wed, 28 January 2009 20:43 By: rleishman
performance hurt after dropping the parititons oracle 10.2.0.3 and solaris 10 By: skumar.dba on Thu, 22 January 2009	4	3089	Tue, 27 January 2009 11:05 By: sonumalhi
Stale Stats for Partitoined table By: sonumalhi on Mon, 26 January 2009	2	3942	Tue, 27 January 2009 10:40 By: sonumalhi
Multiple schemas against single schema - ERP Oracle 10g By: rushimails on Sat, 24 January 2009	5	4652	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	1954	Tue, 27 January 2009 04:08 By: flyboy
Going for full table scan Oracle 10G /Linux By: dhanamukesh on Fri, 23 January 2009	3	2121	Mon, 26 January 2009 23:52 By: dhanamukesh
How to tune By: jolly_makkar on Sun, 25 January 2009	10	5152	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	2816	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	5836	Sun, 25 January 2009 19:42 By: rleishman
high water mark (merged) By: varunvir on Fri, 23 January 2009	4	3671	Fri, 23 January 2009 19:58 By: varunvir
HOW to tune this query By: chaituu on Wed, 21 January 2009	5	3066	Fri, 23 January 2009 06:55 By: chaituu
Io cost too high Oracle 10G/Linux By: dhanamukesh on Tue, 20 January 2009	4	2866	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	4577	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	4057	Mon, 19 January 2009 02:43 By: Michel Cadot
Who is faster Cursor or Recored By: eng.oracle on Sat, 17 January 2009	7	3049	Sun, 18 January 2009 01:57 By: Michel Cadot
Performance Issue with FORALL BULK COLLECT By: srihari1974 on Sat, 17 January 2009	2	2227	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	2012	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	3103	Sat, 17 January 2009 01:13 By: eng.oracle
Slowness of sql query (merged) By: kesavansundaram on Fri, 16 January 2009	2	2378	Fri, 16 January 2009 02:45 By: Michel Cadot
query taking lot of time oracle 10g By: pointers on Thu, 15 January 2009	4	2477	Fri, 16 January 2009 02:35 By: rleishman
Qurey taking much cost 10GR2 By: sanjayocp on Thu, 15 January 2009	2	2666	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	2415	Thu, 15 January 2009 05:57 By: rakeshgj_36
Performance issues 10gR2 By: nani_ar on Sun, 04 January 2009	9	6021	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	2064	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	2729	Tue, 13 January 2009 10:23 By: varunvir
Speed of query 10g By: maheshmhs on Tue, 30 December 2008	3	2602	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	3175	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	2487	Sun, 11 January 2009 08:05 By: michael_bialik
Purge recyclebin By: varunvir on Thu, 08 January 2009	3	5023	Sun, 11 January 2009 01:09 By: Michel Cadot
Oracle 9i SQL not using MV. By: chintu00 on Wed, 24 December 2008	21	7290	Fri, 09 January 2009 11:54 By: chintu00
tuning sql query 10.2.0.2 By: varunvir on Tue, 06 January 2009	8	4992	Fri, 09 January 2009 03:20 By: cookiemonster
Select statement is causing performance issue By: ind9 on Thu, 08 January 2009	16	4692	Fri, 09 January 2009 03:10 By: cookiemonster
cpu usage during backup 10.2.0.2 By: varunvir on Thu, 08 January 2009	6	3620	Thu, 08 January 2009 21:24 By: varunvir
Optimized Query with LIKE Operator (merged) By: shankhan on Wed, 07 January 2009	8	6117	Thu, 08 January 2009 09:54 By: shankhan
Pga hit ratio Oracle 10g R2,Linux AS4 By: rsreddy28 on Wed, 07 January 2009	1	4503	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	4870	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	3553	Tue, 06 January 2009 02:02 By: michael_bialik
Performance problem (Merged) By: mamalik on Mon, 05 January 2009	9	3101	Mon, 05 January 2009 06:00 By: rleishman