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 :: Show Polls :: Message Navigator

	Topic	Replies	Views	Last message
	sticky: How to tune SQL or Identify Performance Problem and Bottleneck By: Michel Cadot on Fri, 22 June 2007	5	38711	Tue, 05 July 2011 07:40 By: LNossov
	inbound connection timed out (ORA-3136) ORACLE DB 10g(64 bit) R2 By: p.anshuman1 on Thu, 24 May 2012	2	38	Thu, 24 May 2012 08:52 By: Michel Cadot
	BULK COLLECT issue 10.2.0.1 By: andy huang on Tue, 22 May 2012	14	186	Wed, 23 May 2012 04:42 By: Michel Cadot
	Index skip scan oracle,11.2.0.2,aix6.1 By: chandusatyam on Sat, 19 May 2012	8	207	Tue, 22 May 2012 16:30 By: rleishman
	Tune data coming from legacy system into Oracle DB Oracle 11gR1 By: vivekgupta15 on Tue, 22 May 2012	6	100	Tue, 22 May 2012 14:03 By: vivekgupta15
	Application Slow in EE but fast in XE (2 Merged) Oracle 10g, Windows 2003 By: syed.dastagir on Tue, 22 May 2012	1	74	Tue, 22 May 2012 09:41 By: BlackSwan
	Query not hitting index on date column Oracle 10G By: priyankt on Fri, 18 May 2012	6	256	Tue, 22 May 2012 08:21 By: John Watson
Book on Materialized Views (3 Merged) has been moved to Replication by the moderator.
	Problem in Update ORACLE 10g By: priyankt on Fri, 11 May 2012	7	357	Fri, 18 May 2012 03:46 By: priyankt
	Tuning Queries Oracle 10.1.0.2 By: arif_md2009 on Wed, 16 May 2012	9	200	Wed, 16 May 2012 05:23 By: arif_md2009
	query slow in application, fast on SQL*Plus executing Oracle Database 10g(RAC) Enterprise Edition Release 10.2.0.4.0 - 64bit By: Andrey_R on Mon, 14 May 2012	6	262	Tue, 15 May 2012 06:08 By: LNossov
	PLSQL taking long time 11.2.0.2.5 By: getzeeshan on Thu, 10 May 2012	5	211	Fri, 11 May 2012 11:34 By: Kevin Meade
	filesystemio_options=SETALL is slower than ASYNCH, why? 11gr2 hp redhat By: Kevin Meade on Sat, 28 January 2012	7	935	Fri, 11 May 2012 10:27 By: Kevin Meade
	Query hang oracle 10g r2,windows 2003 server By: zeeshan047 on Thu, 10 May 2012	5	208	Thu, 10 May 2012 08:57 By: Michel Cadot
	Help to alternate or rewrite the query (5 threads merged by bb) oracle10.2.0.2,Unix By: krajasekhar.v on Wed, 09 May 2012	2	171	Thu, 10 May 2012 03:07 By: cookiemonster
	Slow İnsert Fast Select problem Oracle 10.2.0.4 Enterprise Edition Operation sys Linux By: fabi88 on Thu, 10 May 2012	1	171	Thu, 10 May 2012 02:14 By: Michel Cadot
	Expplain plan output 10.1.0.1 By: guddu_12 on Wed, 09 May 2012	6	175	Wed, 09 May 2012 07:29 By: John Watson
	how to set the sql_profile 10.2.0.1 By: andy huang on Tue, 08 May 2012	2	181	Tue, 08 May 2012 21:13 By: andy huang
	Performance issue in query Oracle 10 G By: rangan.s on Wed, 02 May 2012	3	312	Tue, 08 May 2012 09:52 By: LNossov
	Help required in analyzing AWR report Oracle 10.2.0.3.0 By: orapratap on Mon, 07 May 2012	6	243	Tue, 08 May 2012 08:08 By: John Watson
	cannot see a-rows while querying dbms_xplan.display_cursor Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX By: Andrey_R on Thu, 03 May 2012	15	358	Mon, 07 May 2012 10:48 By: Andrey_R
	unexplained performance degradation of PL/SQL procedures Oracle 10gr2, Solaris 10 By: apaju on Tue, 01 May 2012	12	346	Mon, 07 May 2012 04:48 By: apaju
	Parallel index with Non-partitioned Noparallel table Oracle 10.2.0.4 By: orapratap on Mon, 30 April 2012	5	290	Sat, 05 May 2012 20:31 By: rleishman
	How we can find %age completion of query when is in running status Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit By: msol25 on Wed, 02 May 2012	35	375	Sat, 05 May 2012 06:38 By: martijn
	How we can check count for each partition Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit By: msol25 on Wed, 02 May 2012	12	219	Wed, 02 May 2012 22:22 By: BlackSwan
	Achieve same execution plan Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit By: manubatham20 on Mon, 30 April 2012	10	289	Wed, 02 May 2012 09:46 By: LNossov
	How to change the execution order Oracle,11g,AIX By: vattigunta on Wed, 02 May 2012	3	240	Wed, 02 May 2012 08:30 By: cookiemonster
	Gather statistics on SYS objects Oracle 11.2.0.2.0. Sun OS By: Jack14 on Wed, 07 March 2012	4	407	Sun, 29 April 2012 11:15 By: Jack14
	Query Running for a long time in Second Schema Oracle 11G By: gan.chowdary on Fri, 27 April 2012	2	200	Sat, 28 April 2012 19:14 By: rleishman
	Stale statistics for table Oracle 11g,Linux By: pokhraj_d on Fri, 27 April 2012	3	164	Fri, 27 April 2012 22:51 By: BlackSwan
	OWB Cube load SQL tuning 119, exadata By: onlinedev on Fri, 27 April 2012	1	159	Fri, 27 April 2012 13:28 By: BlackSwan
	Lot of time being taken to delete the data from a table Oracle 10G By: harsh shah on Fri, 27 April 2012	26	401	Fri, 27 April 2012 07:25 By: John Watson
	Locking of two sessions Oracle, 10g,Windows By: manjumagesh on Fri, 27 April 2012	3	216	Fri, 27 April 2012 07:24 By: cookiemonster
	Tablespace full warning 11g By: najeeb7 on Thu, 26 April 2012	4	276	Thu, 26 April 2012 07:36 By: BlackSwan
	Querying GTT in Parallel Mode Oracle 10.2.0.2 By: orapratap on Tue, 24 April 2012	3	317	Thu, 26 April 2012 00:43 By: orapratap
	Tuneup the SQL Oracle 11.2.0.1.0 OS RH Linux 5.1 By: javed.khan on Mon, 23 April 2012	7	324	Wed, 25 April 2012 22:49 By: Kevin Meade
	Troublesome trigger By: rishwinger on Mon, 23 April 2012	3	237	Wed, 25 April 2012 22:41 By: Kevin Meade
	Query on the performance of JOIN on indexed columns Oracle 10.2.0.4 By: orapratap on Fri, 23 March 2012	4	702	Wed, 25 April 2012 22:15 By: zengmuansha
	How to Tune Long running queries? Oracle 10.2.0.4 By: orapratap on Wed, 11 April 2012	16	791	Wed, 25 April 2012 07:41 By: bobbydurrettdba
	how do oracle filter data? Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi By: zengmuansha on Sun, 22 April 2012	7	264	Sun, 22 April 2012 22:31 By: BlackSwan