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 5085 Wed, 30 July 2014 04:14
By: hitesh.bhatt
  Partitioning on a VARCHAR2 column
11g
By: mafoe on Mon, 28 July 2014
6 6513 Tue, 29 July 2014 04:29
By: Roachcoach
  Performance issue
10.2.0.5.0
By: ramanaapps on Fri, 25 July 2014
16 9988 Sat, 26 July 2014 08:55
By: Kevin Meade
  A question about SPM
11.2.0.4 on Linux
By: orausern on Thu, 24 July 2014
2 4160 Thu, 24 July 2014 12:48
By: orausern
  performance lag of the quey
11g
By: andrewscharles89 on Tue, 01 July 2014
17 7694 Thu, 24 July 2014 11:36
By: LNossov
  Performance Tuning
11g
By: andrewscharles89 on Thu, 10 July 2014
11 6480 Tue, 22 July 2014 08:20
By: michael_bialik
  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 12482 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 4202 Wed, 16 July 2014 07:18
By: Michel Cadot
  Query Performance
Oracle 11g
By: rohan10k on Tue, 17 June 2014
3 4522 Sat, 12 July 2014 02:09
By: Kevin Meade
  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 5254 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 7027 Mon, 07 July 2014 10:46
By: Lalit Kumar B
  Shameless plug
By: rleishman on Sat, 05 July 2014
5 6677 Sun, 06 July 2014 07:48
By: rleishman
  I/O calibration
By: John Watson on Wed, 02 July 2014
9 5918 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 6661 Tue, 01 July 2014 08:10
By: martens_b2014
  UNDO Setup Issue
By: VIP2013 on Sat, 21 June 2014
9 9320 Sun, 29 June 2014 04:32
By: Flyby
  Debug Procedure
Oracle 11g,Win7 32 bit
By: Xandot on Thu, 26 June 2014
7 5176 Thu, 26 June 2014 09:10
By: Xandot
  Materialized View- Delay refresh
By: preethi_s0 on Tue, 24 June 2014
7 6025 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 5653 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 14826 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 10631 Tue, 17 June 2014 02:52
By: Michel Cadot
  General question on dbms_stats
11g
By: kiranrathodkr916 on Sat, 14 June 2014
2 4495 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 6601 Sat, 14 June 2014 02:04
By: John Watson
  Indexing and Tuning
Oracle 10g
By: m.abdulhaq on Thu, 29 May 2014
5 5949 Tue, 10 June 2014 20:33
By: Kevin Meade
  Table with 40 million records problem
By: viba1987 on Fri, 30 May 2014
4 4782 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 12295 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 9311 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 4954 Tue, 27 May 2014 02:47
By: Roachcoach
  monitoring
11.2.0.3
By: guru_karnam on Thu, 22 May 2014
3 4115 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 8283 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 6291 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 5362 Tue, 20 May 2014 07:30
By: BlackSwan
  % cpu used by a session
By: Malakay79 on Sat, 17 May 2014
2 4780 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 5236 Thu, 15 May 2014 09:43
By: guru_karnam
  LOV taking long time
By: mist598 on Wed, 14 May 2014
29 13898 Thu, 15 May 2014 00:40
By: Lalit Kumar B
  database performance issue
oracle 11gr2
By: guddu_12 on Tue, 13 May 2014
3 16685 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 8816 Tue, 13 May 2014 10:50
By: ramya_162
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 9665 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 6450 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 5132 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 4850 Tue, 06 May 2014 04:03
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: Tue Mar 19 06:58:39 CDT 2024