Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  Please help me execution plan is looking bad
Oracle 11g
By: ramya_162 on Mon, 12 May 2014
23 1439 Tue, 13 May 2014 10:50
By: ramya_162
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 1364 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 829 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 503 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 743 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 768 Wed, 30 April 2014 05:42
By: ashishkumarmahanta80
  performance Tuning
Oracle 10g
By: ramchandru1989 on Tue, 22 April 2014
5 668 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 515 Fri, 25 April 2014 07:35
By: BlackSwan
  performance imapct on stats collection
Oracle 11gR2
By: ravikanth_b on Thu, 24 April 2014
8 591 Thu, 24 April 2014 19:43
By: BlackSwan
  Need to Understand Explain plan
By: na.dharma@gmail.com on Thu, 24 April 2014
2 655 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 1014 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 594 Tue, 22 April 2014 09:52
By: BlackSwan
  Archive log issues
By: patdev on Thu, 17 April 2014
1 357 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 748 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 824 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 511 Tue, 15 April 2014 04:55
By: jvanh
icon3.gif Its confusing me lot....
11g, AIX
By: harpreetsinghkup on Fri, 11 April 2014
5 601 Mon, 14 April 2014 02:29
By: Roachcoach
  enq: TM - contention
11.2.0.3
By: rishwinger on Wed, 09 April 2014
15 5119 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 473 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 848 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 934 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 1406 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 2035 Thu, 03 April 2014 05:32
By: michael_bialik
  elapsed_time_delta in dba_hist_sqlstat
By: VIP2013 on Wed, 26 March 2014
1 844 Thu, 27 March 2014 10:07
By: VIP2013
  Best Design for batch processing using BLOB Types
By: luxofmcc on Tue, 25 March 2014
1 427 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 1971 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 1126 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 734 Fri, 21 March 2014 09:18
By: cookiemonster
  session uga memory
By: ashu205 on Tue, 18 March 2014
1 658 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 906 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 943 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 2056 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 1804 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 943 Thu, 13 March 2014 20:04
By: rleishman
  SQL Repair
Oracle 11g , Unix
By: younusc on Mon, 10 March 2014
3 759 Thu, 13 March 2014 00:02
By: Markwillium
  database performance tuning
By: likhonisrat on Tue, 11 March 2014
1 483 Tue, 11 March 2014 06:42
By: John Watson
  Query is taking long time
11i
By: Vivek_Garg on Sun, 09 March 2014
16 1286 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 1515 Fri, 07 March 2014 01:41
By: suresh.wst
icon5.gif 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 368 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 1183 Sun, 02 March 2014 22:03
By: trantuananh24hg
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Wed Mar 04 22:52:56 CST 2015

Total time taken to generate the page: 0.12234 seconds