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
db sequential read (merged) oracle 10g R2 By: sahadba on Tue, 25 January 2011	1	4053	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	4238	Mon, 24 January 2011 08:07 By: OraKaran
Database Links Oracle, 10g, Windows Server 2003 By: faizul on Thu, 20 January 2011	12	8980	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	3813	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	2147	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	3665	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	1518	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	1690	Sat, 15 January 2011 03:13 By: tariqdba
Query Perfomance Oracle 10g, Windows XP By: a_oracle on Wed, 12 January 2011	18	8514	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	2679	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	2898	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	1993	Thu, 13 January 2011 08:16 By: steffi
Performance problem, Many "ora_p" processes (merged) or By: sahadba on Thu, 13 January 2011	2	13680	Thu, 13 January 2011 07:48 By: sahadba
SGA 11g Linux By: gkrishn on Sat, 08 January 2011	12	4436	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	2926	Thu, 13 January 2011 01:33 By: John Watson
Session tracing for shared servers By: sekar52 on Wed, 12 January 2011	1	1280	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	1932	Tue, 11 January 2011 09:41 By: cookiemonster
Index rebuild online By: varunvir on Mon, 10 January 2011	3	2839	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	3404	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	2350	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	2346	Sat, 08 January 2011 10:01 By: indrajit2002
Disk Performance Issues By: unex on Fri, 07 January 2011	3	1356	Fri, 07 January 2011 08:15 By: Michel Cadot
ADDM Retention Oracle 10g By: vnkumaresh on Thu, 06 January 2011	2	9051	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	2395	Wed, 05 January 2011 11:47 By: cookiemonster
Procedure taking tomuch time in execution Oracle 10g By: arpitpasari on Sun, 02 January 2011	9	2424	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	9972	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	3256	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	3007	Mon, 03 January 2011 08:20 By: Mahesh Rajendran
ADDM report 10g Linux By: gkrishn on Wed, 22 December 2010	4	4679	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	2608	Mon, 27 December 2010 01:33 By: Michel Cadot
Clustering Factor in Index Oracle 11g By: vnkumaresh on Wed, 15 December 2010	3	5827	Sat, 25 December 2010 01:15 By: Michel Cadot
stored outline 9.2.0.1 By: oragaurav on Thu, 23 December 2010	6	1831	Fri, 24 December 2010 02:04 By: John Watson
Optimizing select from view By: Dimidrol on Thu, 23 December 2010	7	2269	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	1116	Thu, 23 December 2010 03:47 By: Michel Cadot
archive log oracle 10g By: prashant_ora on Sun, 19 December 2010	8	4646	Wed, 22 December 2010 10:47 By: Roachcoach
Temp tablespace full ORACLE,9.2.0.5.0,AIX By: lokeshracdba on Wed, 22 December 2010	1	1720	Wed, 22 December 2010 01:10 By: Michel Cadot
delete procedure taking time oracle,9i,unix By: vickey_sagar1 on Tue, 21 December 2010	7	2006	Wed, 22 December 2010 00:01 By: rleishman
Change in explain plan due to Oracle upgrade Oracle 10.2.0.4.0, Windows Server 2003 By: chowdhhx on Tue, 14 December 2010	5	3783	Thu, 16 December 2010 19:14 By: BlackSwan
Tune the query Oracle9i By: ajaykumarkona on Wed, 15 December 2010	4	1680	Wed, 15 December 2010 17:17 By: cookiemonster
dbms_job oracle 10g By: prashant_ora on Tue, 14 December 2010	9	2359	Wed, 15 December 2010 14:23 By: Haraprasad Hota