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
Using a stats table instead of regular stats to get a plan 9i By: Kevin Meade on Thu, 27 January 2011	2	2542	Fri, 28 January 2011 02:48 By: Kevin Meade
Long Running Query Oracle 9,Unix By: gurukrishnan on Fri, 28 January 2011	1	1845	Fri, 28 January 2011 00:36 By: BlackSwan
Create Index vs Rebuild Index Oracle 9iR2 on RHEL By: OraKaran on Thu, 27 January 2011	2	2997	Thu, 27 January 2011 07:52 By: OraKaran
Optimizer question/ Date handling Oracle 9.2.0.8.0 By: Roachcoach on Mon, 17 January 2011	9	3947	Wed, 26 January 2011 02:57 By: Roachcoach
Locker and waiter problem oraccle 10g RAC environment By: swadeshi on Tue, 25 January 2011	1	1888	Tue, 25 January 2011 07:39 By: Michel Cadot
db sequential read (merged) oracle 10g R2 By: sahadba on Tue, 25 January 2011	1	4622	Tue, 25 January 2011 05:11 By: Michel Cadot
Query regarding tkprof output and cardinality in it Oracle 10g R2 on REHL By: OraKaran on Mon, 24 January 2011	4	4835	Mon, 24 January 2011 08:07 By: OraKaran
Database Links Oracle, 10g, Windows Server 2003 By: faizul on Thu, 20 January 2011	12	9834	Thu, 20 January 2011 14:48 By: John Watson
AWR report in 11g standard not supported? 11.2.0.1 By: sean1970 on Sat, 15 January 2011	6	4520	Wed, 19 January 2011 00:31 By: sean1970
Avoid chain rows oracle, 9.2.0.4.0, SunSolaris By: sathik on Mon, 17 January 2011	5	2788	Mon, 17 January 2011 10:40 By: Michel Cadot
MEMORY_TARGET and MEMORY_MAX_TARGET 11.2.0.1 By: sean1970 on Sat, 15 January 2011	3	4181	Sat, 15 January 2011 11:15 By: sean1970
Confusion over Keep Cache (2 Merged) Oracle 11g, HP-UX B11.23 By: indrajit2002 on Sat, 15 January 2011	2	2053	Sat, 15 January 2011 10:56 By: Michel Cadot
Retreiving from the Data is slow Oracle 11g, Linux By: tariqdba on Wed, 12 January 2011	6	2325	Sat, 15 January 2011 03:13 By: tariqdba
Query Perfomance Oracle 10g, Windows XP By: a_oracle on Wed, 12 January 2011	18	9383	Fri, 14 January 2011 07:33 By: cookiemonster
AWR report Oracle 10.2.0.3 + 2 node RAC + HP-UX Itanium 11.31 By: seema.taunk on Mon, 10 January 2011	3	3269	Fri, 14 January 2011 06:29 By: seema.taunk
Elapsed time not accounted in tkprof file Oracle 9.2 on HP-UX By: OraKaran on Thu, 13 January 2011	11	3540	Thu, 13 January 2011 11:17 By: cookiemonster
How to partition tables and indexes in this scenario? Oracle 11g R2 By: steffi on Wed, 12 January 2011	3	2540	Thu, 13 January 2011 08:16 By: steffi
Performance problem, Many "ora_p" processes (merged) or By: sahadba on Thu, 13 January 2011	2	14735	Thu, 13 January 2011 07:48 By: sahadba
SGA 11g Linux By: gkrishn on Sat, 08 January 2011	12	5147	Thu, 13 January 2011 04:33 By: gkrishn
Initialization parameters value Oracle 10g, 10.2.0.4.0, Solaris 10 By: reym21 on Wed, 12 January 2011	8	3628	Thu, 13 January 2011 01:33 By: John Watson
Session tracing for shared servers By: sekar52 on Wed, 12 January 2011	1	1798	Wed, 12 January 2011 00:59 By: Michel Cadot
Query Taking too much time Oracle 9.2 on HP-UX By: OraKaran on Tue, 11 January 2011	4	2486	Tue, 11 January 2011 09:41 By: cookiemonster
Index rebuild online By: varunvir on Mon, 10 January 2011	3	3412	Mon, 10 January 2011 15:53 By: varunvir
Query taking time Oracle 11g HP-UX B11.23 By: indrajit2002 on Mon, 10 January 2011	7	4071	Mon, 10 January 2011 09:48 By: BlackSwan
performance issue Oracle 10.2.0.4 windows 64 bit By: dba_7722 on Sun, 09 January 2011	1	2882	Sun, 09 January 2011 06:38 By: Mahesh Rajendran
Help with problem query Oracle 9.2.0.8 (HP-UX B11.23) By: indrajit2002 on Wed, 05 January 2011	7	2980	Sat, 08 January 2011 10:01 By: indrajit2002
Disk Performance Issues By: unex on Fri, 07 January 2011	3	1928	Fri, 07 January 2011 08:15 By: Michel Cadot
ADDM Retention Oracle 10g By: vnkumaresh on Thu, 06 January 2011	2	9851	Thu, 06 January 2011 06:28 By: vnkumaresh
Procedure runs long time (merged) Oracle Enterprise Edition 10.2.0.4, Solaris 10 By: jesuisantony on Wed, 05 January 2011	4	3094	Wed, 05 January 2011 11:47 By: cookiemonster
Procedure taking tomuch time in execution Oracle 10g By: arpitpasari on Sun, 02 January 2011	9	3105	Tue, 04 January 2011 04:25 By: michael_bialik
Oracle Coalesce vs Index Rebuild 10g(10.2.0.4) By: paradoxkhan on Thu, 30 December 2010	10	10910	Mon, 03 January 2011 23:37 By: ramoradba
Parse once - Execute many Oracle 9,10, cross platform By: trantuananh24hg on Sun, 26 December 2010	4	3875	Mon, 03 January 2011 22:04 By: trantuananh24hg
Less Cost,Cardinality,Bytes Query is taking More time to execute By: gururajster on Mon, 03 January 2011	1	3543	Mon, 03 January 2011 08:20 By: Mahesh Rajendran
ADDM report 10g Linux By: gkrishn on Wed, 22 December 2010	4	5252	Tue, 28 December 2010 07:27 By: mani.aggarwal
How to overcome rownum clause from select Oracle 11g ,windows 2003 By: pradies on Mon, 27 December 2010	3	3203	Mon, 27 December 2010 01:33 By: Michel Cadot
Clustering Factor in Index Oracle 11g By: vnkumaresh on Wed, 15 December 2010	3	6370	Sat, 25 December 2010 01:15 By: Michel Cadot
stored outline 9.2.0.1 By: oragaurav on Thu, 23 December 2010	6	2439	Fri, 24 December 2010 02:04 By: John Watson
Optimizing select from view By: Dimidrol on Thu, 23 December 2010	7	2919	Thu, 23 December 2010 11:28 By: cookiemonster
Performance hit of the application after moving the DB server oracle 9i, 10g, forms 10g/9i, AS9i By: rajesh4851 on Thu, 23 December 2010	1	1576	Thu, 23 December 2010 03:47 By: Michel Cadot
archive log oracle 10g By: prashant_ora on Sun, 19 December 2010	8	5270	Wed, 22 December 2010 10:47 By: Roachcoach