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

    Replies Views Last message
  After Table analyze, the number of blocks goes Down
Oracle 11gR2
By: hitesh.bhatt on Thu, 24 July 2014
7 1022 Wed, 30 July 2014 04:14
By: hitesh.bhatt
  A question about SPM
11.2.0.4 on Linux
By: orausern on Thu, 24 July 2014
2 805 Thu, 24 July 2014 12:48
By: orausern
  How to revert the work done by accept_sql_profile procedure & Issues to watch out with SPM (merged)
Oracle 11.2.0.4 on Linux
By: orausern on Mon, 14 July 2014
20 2832 Wed, 16 July 2014 11:16
By: orausern
  Oracle 11g on VMWARE
Oracle 11g, Windows Server 2008
By: josephmaan on Wed, 16 July 2014
3 830 Wed, 16 July 2014 07:18
By: Michel Cadot
  Performance Tuning
11g
By: andrewscharles89 on Thu, 10 July 2014
11 1424 Tue, 22 July 2014 08:20
By: michael_bialik
  AWR and ASH report analyze
Oracle 10g,11g,Linux
By: Database admin on Mon, 07 July 2014
13 1470 Mon, 07 July 2014 10:46
By: Lalit Kumar B
  I/O calibration
By: John Watson on Wed, 02 July 2014
9 1384 Fri, 04 July 2014 06:34
By: Roachcoach
  Shameless plug
By: rleishman on Sat, 05 July 2014
5 1456 Sun, 06 July 2014 07:48
By: rleishman
  performance lag of the quey
11g
By: andrewscharles89 on Tue, 01 July 2014
17 1845 Thu, 24 July 2014 11:36
By: LNossov
  Materialized View- Delay refresh
By: preethi_s0 on Tue, 24 June 2014
7 1209 Tue, 24 June 2014 07:44
By: Michel Cadot
  UNDO Setup Issue
By: VIP2013 on Sat, 21 June 2014
9 2670 Sun, 29 June 2014 04:32
By: Flyby
  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 1281 Fri, 20 June 2014 01:13
By: Michel Cadot
  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 1060 Sat, 12 July 2014 02:03
By: Kevin Meade
  Query Performance
Oracle 11g
By: rohan10k on Tue, 17 June 2014
3 1239 Sat, 12 July 2014 02:09
By: Kevin Meade
  Table Shrink Space and Performance
11g Standard Edition,Linux x86_64
By: preet_kumar on Mon, 16 June 2014
11 1857 Tue, 01 July 2014 08:10
By: martens_b2014
  General question on dbms_stats
11g
By: kiranrathodkr916 on Sat, 14 June 2014
2 889 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 1502 Sat, 14 June 2014 02:04
By: John Watson
  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 2753 Tue, 17 June 2014 02:52
By: Michel Cadot
  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 5035 Thu, 05 June 2014 15:05
By: BlackSwan
  Table with 40 million records problem
By: viba1987 on Fri, 30 May 2014
4 1264 Tue, 10 June 2014 20:21
By: Kevin Meade
  Indexing and Tuning
Oracle 10g
By: m.abdulhaq on Thu, 29 May 2014
5 1674 Tue, 10 June 2014 20:33
By: Kevin Meade
  SQL performance tunning
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
By: msinha8 on Thu, 29 May 2014
21 2091 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 1237 Tue, 27 May 2014 02:47
By: Roachcoach
  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 2550 Fri, 23 May 2014 20:27
By: Kevin Meade
  monitoring
11.2.0.3
By: guru_karnam on Thu, 22 May 2014
3 1019 Fri, 23 May 2014 23:56
By: Michel Cadot
  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 1550 Tue, 20 May 2014 07:30
By: BlackSwan
  % cpu used by a session
By: Malakay79 on Sat, 17 May 2014
2 1011 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 1319 Thu, 15 May 2014 09:43
By: guru_karnam
  LOV taking long time
By: mist598 on Wed, 14 May 2014
29 3717 Thu, 15 May 2014 00:40
By: Lalit Kumar B
  database performance issue
oracle 11gr2
By: guddu_12 on Tue, 13 May 2014
3 7135 Tue, 13 May 2014 21:40
By: BlackSwan
  what are the disadvan of using incremental stats in oracle 11g?
By: ashwanth77 on Fri, 09 May 2014
5 1674 Thu, 22 May 2014 05:26
By: ashwanth77
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 2081 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 1702 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 1256 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 1108 Tue, 06 May 2014 04:03
By: Lalit Kumar B
  Please help me execution plan is looking bad
Oracle 11g
By: ramya_162 on Mon, 12 May 2014
23 2181 Tue, 13 May 2014 10:50
By: ramya_162
  After updating memory_target, performance is degraded
11g, 11.2.0.3, solaris10
By: ashishkumarmahanta80 on Mon, 28 April 2014
7 1391 Wed, 30 April 2014 05:42
By: ashishkumarmahanta80
  ODI Performance issue with flat file
ODI 11g
By: giridhar123 on Fri, 25 April 2014
1 1207 Fri, 25 April 2014 07:35
By: BlackSwan
  performance imapct on stats collection
Oracle 11gR2
By: ravikanth_b on Thu, 24 April 2014
8 1337 Thu, 24 April 2014 19:43
By: BlackSwan
  Need to Understand Explain plan
By: na.dharma@gmail.com on Thu, 24 April 2014
2 1058 Thu, 24 April 2014 02:40
By: cookiemonster
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: Mon Oct 16 21:09:58 CDT 2017

Total time taken to generate the page: 0.02232 seconds