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 to remove left join and ON JOIN from query and use better things in place of that
11i ( 1 2)
By: nishantranjan00787 on Mon, 21 July 2014
51 4214 Thu, 31 July 2014 05:50
By: John Watson
  After Table analyze, the number of blocks goes Down
Oracle 11gR2
By: hitesh.bhatt on Thu, 24 July 2014
7 909 Wed, 30 July 2014 04:14
By: hitesh.bhatt
  Partitioning on a VARCHAR2 column
11g
By: mafoe on Mon, 28 July 2014
6 1308 Tue, 29 July 2014 04:29
By: Roachcoach
  Performance issue
10.2.0.5.0
By: ramanaapps on Fri, 25 July 2014
16 1670 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 689 Thu, 24 July 2014 12:48
By: orausern
  performance lag of the quey
11g
By: andrewscharles89 on Tue, 01 July 2014
17 1601 Thu, 24 July 2014 11:36
By: LNossov
  Performance Tuning
11g
By: andrewscharles89 on Thu, 10 July 2014
11 1273 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 1969 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 729 Wed, 16 July 2014 07:18
By: Michel Cadot
  Query Performance
Oracle 11g
By: rohan10k on Tue, 17 June 2014
3 1147 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 866 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 1303 Mon, 07 July 2014 10:46
By: Lalit Kumar B
  Shameless plug
By: rleishman on Sat, 05 July 2014
5 1231 Sun, 06 July 2014 07:48
By: rleishman
  I/O calibration
By: John Watson on Wed, 02 July 2014
9 1196 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 1456 Tue, 01 July 2014 08:10
By: martens_b2014
  UNDO Setup Issue
By: VIP2013 on Sat, 21 June 2014
9 2203 Sun, 29 June 2014 04:32
By: Flyby
  Debug Procedure
Oracle 11g,Win7 32 bit
By: Xandot on Thu, 26 June 2014
7 857 Thu, 26 June 2014 09:10
By: Xandot
  Materialized View- Delay refresh
By: preethi_s0 on Tue, 24 June 2014
7 980 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 1125 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 4803 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 2141 Tue, 17 June 2014 02:52
By: Michel Cadot
  General question on dbms_stats
11g
By: kiranrathodkr916 on Sat, 14 June 2014
2 793 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 1385 Sat, 14 June 2014 02:04
By: John Watson
  Indexing and Tuning
Oracle 10g
By: m.abdulhaq on Thu, 29 May 2014
5 1441 Tue, 10 June 2014 20:33
By: Kevin Meade
  Table with 40 million records problem
By: viba1987 on Fri, 30 May 2014
4 1171 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 1262 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 1896 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 1140 Tue, 27 May 2014 02:47
By: Roachcoach
  monitoring
11.2.0.3
By: guru_karnam on Thu, 22 May 2014
3 941 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 2023 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 1390 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 1292 Tue, 20 May 2014 07:30
By: BlackSwan
  % cpu used by a session
By: Malakay79 on Sat, 17 May 2014
2 803 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 1136 Thu, 15 May 2014 09:43
By: guru_karnam
  LOV taking long time
By: mist598 on Wed, 14 May 2014
29 3045 Thu, 15 May 2014 00:40
By: Lalit Kumar B
  database performance issue
oracle 11gr2
By: guddu_12 on Tue, 13 May 2014
3 951 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 1928 Tue, 13 May 2014 10:50
By: ramya_162
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 1849 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 1419 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 1006 Wed, 07 May 2014 10:38
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: Mon Dec 05 13:06:19 CST 2016

Total time taken to generate the page: 0.12040 seconds