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
SQL performance tunning :- DBMS_STATS procedure errored out Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production By: msinha8 on Thu, 12 June 2014	22	8659	Tue, 17 June 2014 02:52 By: Michel Cadot
General question on dbms_stats 11g By: kiranrathodkr916 on Sat, 14 June 2014	2	3331	Sat, 14 June 2014 10:43 By: Lalit Kumar B
how to troubleshoot slow running queries? 11g By: kiranrathodkr916 on Thu, 12 June 2014	11	5328	Sat, 14 June 2014 02:04 By: John Watson
Indexing and Tuning Oracle 10g By: m.abdulhaq on Thu, 29 May 2014	5	4861	Tue, 10 June 2014 20:33 By: Kevin Meade
Table with 40 million records problem By: viba1987 on Fri, 30 May 2014	4	3611	Tue, 10 June 2014 20:21 By: Kevin Meade
Staging table without indexes, slow queries Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 By: rkhatiwala on Wed, 04 June 2014	4	10965	Thu, 05 June 2014 15:05 By: BlackSwan
SQL performance tunning Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production By: msinha8 on Thu, 29 May 2014	21	7313	Thu, 05 June 2014 08:56 By: msinha8
SQL id shows multiple plan table 11g, 11.2.0.3, sun-solaris10 By: ashishkumarmahanta80 on Tue, 27 May 2014	5	3788	Tue, 27 May 2014 02:47 By: Roachcoach
monitoring 11.2.0.3 By: guru_karnam on Thu, 22 May 2014	3	3052	Fri, 23 May 2014 23:56 By: Michel Cadot
Direct Path Wait event Tune Direct path write temp, Direct path read, Direct path read temp By: guru_karnam on Thu, 22 May 2014	6	6667	Fri, 23 May 2014 20:27 By: Kevin Meade
what are the disadvan of using incremental stats in oracle 11g? By: ashwanth77 on Fri, 09 May 2014	5	4869	Thu, 22 May 2014 05:26 By: ashwanth77
dba_hist_snapshot vs dba_hist_active_sess_history oracle 11g rel 2 (11.2.0.3.0) By: ind9 on Tue, 20 May 2014	1	4118	Tue, 20 May 2014 07:30 By: BlackSwan
% cpu used by a session By: Malakay79 on Sat, 17 May 2014	2	3598	Sat, 17 May 2014 11:00 By: Michel Cadot
Procedure runs slow whereas 11.2.0.1 By: guru_karnam on Wed, 14 May 2014	7	3888	Thu, 15 May 2014 09:43 By: guru_karnam
LOV taking long time By: mist598 on Wed, 14 May 2014	29	11494	Thu, 15 May 2014 00:40 By: Lalit Kumar B
database performance issue oracle 11gr2 By: guddu_12 on Tue, 13 May 2014	3	15490	Tue, 13 May 2014 21:40 By: BlackSwan
Please help me execution plan is looking bad Oracle 11g By: ramya_162 on Mon, 12 May 2014	23	7181	Tue, 13 May 2014 10:50 By: ramya_162
SQL Query too slow 11g, Windows By: aldy on Thu, 08 May 2014	20	7376	Sat, 10 May 2014 10:21 By: Kevin Meade
High CPU Consuming Query Oracle,11.2.0.3, AIX By: nmoham on Wed, 07 May 2014	12	5050	Fri, 09 May 2014 02:19 By: John Watson
slow sql By: fenor on Tue, 06 May 2014	6	3991	Wed, 07 May 2014 10:38 By: BlackSwan
Full table scan - Queries 11g, 11.2.0.3, solaris10 By: ashishkumarmahanta80 on Mon, 05 May 2014	6	3624	Tue, 06 May 2014 04:03 By: Lalit Kumar B
After updating memory_target, performance is degraded 11g, 11.2.0.3, solaris10 By: ashishkumarmahanta80 on Mon, 28 April 2014	7	4579	Wed, 30 April 2014 05:42 By: ashishkumarmahanta80
performance Tuning Oracle 10g By: ramchandru1989 on Tue, 22 April 2014	5	3659	Tue, 29 April 2014 19:20 By: Kevin Meade
ODI Performance issue with flat file ODI 11g By: giridhar123 on Fri, 25 April 2014	1	3155	Fri, 25 April 2014 07:35 By: BlackSwan
performance imapct on stats collection Oracle 11gR2 By: ravikanth_b on Thu, 24 April 2014	8	4429	Thu, 24 April 2014 19:43 By: BlackSwan
Need to Understand Explain plan By: na.dharma@gmail.com on Thu, 24 April 2014	2	3204	Thu, 24 April 2014 02:40 By: cookiemonster
Scripts to find Indexes which are candidate for Rebuild Oracle 11.2.0.3, Linux x86 64-bit By: hitesh.bhatt on Tue, 22 April 2014	9	4238	Wed, 23 April 2014 08:17 By: BlackSwan
Please help me for getting best execution plan as my create view script is taking more time Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Tue, 25 March 2014	5	3833	Tue, 22 April 2014 09:52 By: BlackSwan
Archive log issues By: patdev on Thu, 17 April 2014	1	2633	Thu, 17 April 2014 12:48 By: BlackSwan
Would making indexes "invisible" be the right approach for this? 11.2.0.3 / CentOS Linux By: ThomasG on Wed, 26 March 2014	4	3540	Thu, 17 April 2014 04:30 By: Lalit Kumar B
query optimization phase Oracle DB 11.2.0 By: Johnny_aig on Tue, 15 April 2014	8	4620	Wed, 16 April 2014 08:49 By: Lalit Kumar B
Can I instruct Oracle 11g to deliberately delay query completion? Oracle 11g By: jvanh on Fri, 11 April 2014	3	2823	Tue, 15 April 2014 04:55 By: jvanh
Its confusing me lot.... 11g, AIX By: harpreetsinghkup on Fri, 11 April 2014	5	4089	Mon, 14 April 2014 02:29 By: Roachcoach
enq: TM - contention 11.2.0.3 By: rishwinger on Wed, 09 April 2014	15	46339	Wed, 09 April 2014 05:53 By: Michel Cadot
DATA BASE IS WORKING VERY SLOW ORACLE 9I By: arvindnegi2007 on Wed, 09 April 2014	1	2815	Wed, 09 April 2014 02:29 By: Michel Cadot
COUNT STOPKEY issue -- performance issue oracle 11gr2/unix By: balaji123 on Mon, 07 April 2014	2	4684	Tue, 08 April 2014 19:51 By: rleishman
5M record insert takes two hours 11gR2 By: That Don Guy on Wed, 02 April 2014	4	3920	Mon, 07 April 2014 10:54 By: d_seng
Materialized View not being used on production (works elsewhere) Oracle 11.2.0.2 Enterprise 64 bit By: d_seng on Wed, 26 February 2014	9	6861	Mon, 07 April 2014 10:32 By: d_seng
SQL performance Oracle 11i By: huda_10@yahoo.co.in on Sun, 30 March 2014	13	6961	Thu, 03 April 2014 05:32 By: michael_bialik
elapsed_time_delta in dba_hist_sqlstat By: VIP2013 on Wed, 26 March 2014	1	6016	Thu, 27 March 2014 10:07 By: VIP2013