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

    Replies Views Last message
  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 934 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 1317 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 859 Tue, 27 May 2014 02:47
By: Roachcoach
  monitoring
11.2.0.3
By: guru_karnam on Thu, 22 May 2014
3 656 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 1240 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 845 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 772 Tue, 20 May 2014 07:30
By: BlackSwan
  % cpu used by a session
By: Malakay79 on Sat, 17 May 2014
2 486 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 651 Thu, 15 May 2014 09:43
By: guru_karnam
  LOV taking long time
By: mist598 on Wed, 14 May 2014
29 2209 Thu, 15 May 2014 00:40
By: Lalit Kumar B
  database performance issue
oracle 11gr2
By: guddu_12 on Tue, 13 May 2014
3 598 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 1452 Tue, 13 May 2014 10:50
By: ramya_162
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 1376 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 844 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 522 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 760 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 793 Wed, 30 April 2014 05:42
By: ashishkumarmahanta80
  performance Tuning
Oracle 10g
By: ramchandru1989 on Tue, 22 April 2014
5 695 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 534 Fri, 25 April 2014 07:35
By: BlackSwan
  performance imapct on stats collection
Oracle 11gR2
By: ravikanth_b on Thu, 24 April 2014
8 631 Thu, 24 April 2014 19:43
By: BlackSwan
  Need to Understand Explain plan
By: na.dharma@gmail.com on Thu, 24 April 2014
2 674 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 1035 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 614 Tue, 22 April 2014 09:52
By: BlackSwan
  Archive log issues
By: patdev on Thu, 17 April 2014
1 362 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 760 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 835 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 525 Tue, 15 April 2014 04:55
By: jvanh
icon3.gif Its confusing me lot....
11g, AIX
By: harpreetsinghkup on Fri, 11 April 2014
5 635 Mon, 14 April 2014 02:29
By: Roachcoach
  enq: TM - contention
11.2.0.3
By: rishwinger on Wed, 09 April 2014
15 5788 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 486 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 884 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 961 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 1427 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 2076 Thu, 03 April 2014 05:32
By: michael_bialik
  elapsed_time_delta in dba_hist_sqlstat
By: VIP2013 on Wed, 26 March 2014
1 902 Thu, 27 March 2014 10:07
By: VIP2013
  Best Design for batch processing using BLOB Types
By: luxofmcc on Tue, 25 March 2014
1 436 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 1992 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 1143 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 759 Fri, 21 March 2014 09:18
By: cookiemonster
  session uga memory
By: ashu205 on Tue, 18 March 2014
1 702 Wed, 19 March 2014 18:42
By: BlackSwan
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 Apr 01 06:27:03 CDT 2015

Total time taken to generate the page: 0.15469 seconds