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

    Replies Views Last message
  How about performance using index on the column which is using in WHERE and SET clause.
Oracle 11g
By: ramya_162 on Wed, 18 June 2014
3 859 Sat, 12 July 2014 02:03
By: Kevin Meade
  AWR and ASH report analyze
Oracle 10g,11g,Linux
By: Database admin on Mon, 07 July 2014
13 1276 Mon, 07 July 2014 10:46
By: Lalit Kumar B
  Shameless plug
By: rleishman on Sat, 05 July 2014
5 1188 Sun, 06 July 2014 07:48
By: rleishman
  I/O calibration
By: John Watson on Wed, 02 July 2014
9 1165 Fri, 04 July 2014 06:34
By: Roachcoach
  Table Shrink Space and Performance
11g Standard Edition,Linux x86_64
By: preet_kumar on Mon, 16 June 2014
11 1395 Tue, 01 July 2014 08:10
By: martens_b2014
  UNDO Setup Issue
By: VIP2013 on Sat, 21 June 2014
9 2110 Sun, 29 June 2014 04:32
By: Flyby
  Debug Procedure
Oracle 11g,Win7 32 bit
By: Xandot on Thu, 26 June 2014
7 840 Thu, 26 June 2014 09:10
By: Xandot
  Materialized View- Delay refresh
By: preethi_s0 on Tue, 24 June 2014
7 955 Tue, 24 June 2014 07:44
By: Michel Cadot
  Calculating schema statistics during a huge 10 hour batch job
Oracle 11gR2(11.2.0.4) on Linux
By: orausern on Thu, 19 June 2014
7 1080 Fri, 20 June 2014 01:13
By: Michel Cadot
  DBA_HIST_SEG_STAT view
11.2.0.3
By: rishwinger on Mon, 06 January 2014
7 4500 Fri, 20 June 2014 00:50
By: Michel Cadot
  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 2054 Tue, 17 June 2014 02:52
By: Michel Cadot
  General question on dbms_stats
11g
By: kiranrathodkr916 on Sat, 14 June 2014
2 777 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 1381 Sat, 14 June 2014 02:04
By: John Watson
  Indexing and Tuning
Oracle 10g
By: m.abdulhaq on Thu, 29 May 2014
5 1401 Tue, 10 June 2014 20:33
By: Kevin Meade
  Table with 40 million records problem
By: viba1987 on Fri, 30 May 2014
4 1152 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 1245 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 1859 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 1128 Tue, 27 May 2014 02:47
By: Roachcoach
  monitoring
11.2.0.3
By: guru_karnam on Thu, 22 May 2014
3 926 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 1932 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 1342 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 1259 Tue, 20 May 2014 07:30
By: BlackSwan
  % cpu used by a session
By: Malakay79 on Sat, 17 May 2014
2 786 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 1097 Thu, 15 May 2014 09:43
By: guru_karnam
  LOV taking long time
By: mist598 on Wed, 14 May 2014
29 2961 Thu, 15 May 2014 00:40
By: Lalit Kumar B
  database performance issue
oracle 11gr2
By: guddu_12 on Tue, 13 May 2014
3 906 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 1876 Tue, 13 May 2014 10:50
By: ramya_162
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 1809 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 1370 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 967 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 1000 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 1124 Wed, 30 April 2014 05:42
By: ashishkumarmahanta80
  performance Tuning
Oracle 10g
By: ramchandru1989 on Tue, 22 April 2014
5 977 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 1027 Fri, 25 April 2014 07:35
By: BlackSwan
  performance imapct on stats collection
Oracle 11gR2
By: ravikanth_b on Thu, 24 April 2014
8 1114 Thu, 24 April 2014 19:43
By: BlackSwan
  Need to Understand Explain plan
By: na.dharma@gmail.com on Thu, 24 April 2014
2 929 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 1392 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 954 Tue, 22 April 2014 09:52
By: BlackSwan
  Archive log issues
By: patdev on Thu, 17 April 2014
1 571 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 1042 Thu, 17 April 2014 04:30
By: Lalit Kumar B
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: Sat Oct 01 02:19:51 CDT 2016

Total time taken to generate the page: 0.07881 seconds