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
Please help me execution plan is looking bad Oracle 11g By: ramya_162 on Mon, 12 May 2014	23	16995	Tue, 13 May 2014 10:50 By: ramya_162
SQL Query too slow 11g, Windows By: aldy on Thu, 08 May 2014	20	17504	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	11835	Fri, 09 May 2014 02:19 By: John Watson
slow sql By: fenor on Tue, 06 May 2014	6	8898	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	8658	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	9911	Wed, 30 April 2014 05:42 By: ashishkumarmahanta80
performance Tuning Oracle 10g By: ramchandru1989 on Tue, 22 April 2014	5	8435	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	7530	Fri, 25 April 2014 07:35 By: BlackSwan
performance imapct on stats collection Oracle 11gR2 By: ravikanth_b on Thu, 24 April 2014	8	13656	Thu, 24 April 2014 19:43 By: BlackSwan
Need to Understand Explain plan By: na.dharma@gmail.com on Thu, 24 April 2014	2	7772	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	9897	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	8706	Tue, 22 April 2014 09:52 By: BlackSwan
Archive log issues By: patdev on Thu, 17 April 2014	1	6782	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	8619	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	10565	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	6803	Tue, 15 April 2014 04:55 By: jvanh
Its confusing me lot.... 11g, AIX By: harpreetsinghkup on Fri, 11 April 2014	5	8849	Mon, 14 April 2014 02:29 By: Roachcoach
enq: TM - contention 11.2.0.3 By: rishwinger on Wed, 09 April 2014	15	55124	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	7158	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	9256	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	8866	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	13959	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	14473	Thu, 03 April 2014 05:32 By: michael_bialik
elapsed_time_delta in dba_hist_sqlstat By: VIP2013 on Wed, 26 March 2014	1	9901	Thu, 27 March 2014 10:07 By: VIP2013
Best Design for batch processing using BLOB Types By: luxofmcc on Tue, 25 March 2014	1	7420	Tue, 25 March 2014 14:43 By: BlackSwan
sql result cache for improving the performance (merged 4) 11g By: kiranrathodkr916 on Sat, 22 March 2014	21	18525	Tue, 25 March 2014 05:15 By: ashwanth77
Use of Hints in Oracle 11g to get desired Execution Plan Oracle 11g 2.0, Linux By: rekha.singhal@tcs.com on Thu, 20 March 2014	9	12534	Mon, 24 March 2014 00:29 By: Kevin Meade
statement with big cost Oracle Database 11.2.0.2.0 By: Roger22 on Fri, 21 March 2014	9	9488	Fri, 21 March 2014 09:18 By: cookiemonster
session uga memory By: ashu205 on Tue, 18 March 2014	1	10231	Wed, 19 March 2014 18:42 By: BlackSwan
What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def general By: Kevin Meade on Tue, 18 March 2014	4	9418	Tue, 18 March 2014 06:09 By: Kevin Meade
SQL Execution Runtime Measure Oracle 11g Rel 2 By: ind9 on Fri, 14 March 2014	3	8403	Sat, 15 March 2014 05:45 By: John Watson
What is the most expensive dml transaction, insert, update, delete? Oracle By: steves on Sun, 24 March 2013	12	17708	Fri, 14 March 2014 17:49 By: youngryand
Sql Tuning Advisor - Privileges (sqltrpt.sql) Oracle DB 11g Enterprise - 11.2.0.3 - Linux x86 64-bit By: hitesh.bhatt on Thu, 13 March 2014	2	15287	Thu, 13 March 2014 22:49 By: hitesh.bhatt
Incorrect cardinalty estimate when using a local non-prefixed unique index DB 12.1.0.1 By: John Watson on Fri, 07 March 2014	7	9400	Thu, 13 March 2014 20:04 By: rleishman
SQL Repair Oracle 11g , Unix By: younusc on Mon, 10 March 2014	3	8316	Thu, 13 March 2014 00:02 By: Markwillium
database performance tuning By: likhonisrat on Tue, 11 March 2014	1	6965	Tue, 11 March 2014 06:42 By: John Watson
Query is taking long time 11i By: Vivek_Garg on Sun, 09 March 2014	16	14631	Mon, 10 March 2014 04:49 By: John Watson
How to find throughput by query, session and database wise? Oracle 11.2.0.3, Redhat Linux 5. By: suresh.wst on Sun, 02 March 2014	9	10836	Fri, 07 March 2014 01:41 By: suresh.wst
Difference in elapsed time of the query where everything in the trace seems to be identical Oracle 11g, Windows 7 By: Vivek_Garg on Thu, 06 March 2014	1	6167	Thu, 06 March 2014 07:09 By: John Watson
AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" Oracle 11.2.0.3.0 on HP-UX (64-Bit) By: hitesh.bhatt on Tue, 18 February 2014	3	10694	Sun, 02 March 2014 22:03 By: trantuananh24hg