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

    Replies Views Last message
  A question about SPM
11.2.0.4 on Linux
By: orausern on Thu, 24 July 2014
2 793 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 2762 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 819 Wed, 16 July 2014 07:18
By: Michel Cadot
  Performance Tuning
11g
By: andrewscharles89 on Thu, 10 July 2014
11 1392 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 1433 Mon, 07 July 2014 10:46
By: Lalit Kumar B
  I/O calibration
By: John Watson on Wed, 02 July 2014
9 1355 Fri, 04 July 2014 06:34
By: Roachcoach
  Shameless plug
By: rleishman on Sat, 05 July 2014
5 1433 Sun, 06 July 2014 07:48
By: rleishman
  performance lag of the quey
11g
By: andrewscharles89 on Tue, 01 July 2014
17 1791 Thu, 24 July 2014 11:36
By: LNossov
  Materialized View- Delay refresh
By: preethi_s0 on Tue, 24 June 2014
7 1182 Tue, 24 June 2014 07:44
By: Michel Cadot
  UNDO Setup Issue
By: VIP2013 on Sat, 21 June 2014
9 2619 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 1261 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 1043 Sat, 12 July 2014 02:03
By: Kevin Meade
  Query Performance
Oracle 11g
By: rohan10k on Tue, 17 June 2014
3 1227 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 1786 Tue, 01 July 2014 08:10
By: martens_b2014
  General question on dbms_stats
11g
By: kiranrathodkr916 on Sat, 14 June 2014
2 880 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 1469 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 2658 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 4880 Thu, 05 June 2014 15:05
By: BlackSwan
  Table with 40 million records problem
By: viba1987 on Fri, 30 May 2014
4 1249 Tue, 10 June 2014 20:21
By: Kevin Meade
  Indexing and Tuning
Oracle 10g
By: m.abdulhaq on Thu, 29 May 2014
5 1652 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 2037 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 1220 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 2501 Fri, 23 May 2014 20:27
By: Kevin Meade
  monitoring
11.2.0.3
By: guru_karnam on Thu, 22 May 2014
3 1007 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 1531 Tue, 20 May 2014 07:30
By: BlackSwan
  % cpu used by a session
By: Malakay79 on Sat, 17 May 2014
2 1002 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 1299 Thu, 15 May 2014 09:43
By: guru_karnam
  LOV taking long time
By: mist598 on Wed, 14 May 2014
29 3594 Thu, 15 May 2014 00:40
By: Lalit Kumar B
  database performance issue
oracle 11gr2
By: guddu_12 on Tue, 13 May 2014
3 6926 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 1651 Thu, 22 May 2014 05:26
By: ashwanth77
  SQL Query too slow
11g, Windows
By: aldy on Thu, 08 May 2014
20 2035 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 1655 Fri, 09 May 2014 02:19
By: John Watson
  slow sql
By: fenor on Tue, 06 May 2014
6 1225 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 1092 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 2120 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 1369 Wed, 30 April 2014 05:42
By: ashishkumarmahanta80
  ODI Performance issue with flat file
ODI 11g
By: giridhar123 on Fri, 25 April 2014
1 1188 Fri, 25 April 2014 07:35
By: BlackSwan
  performance imapct on stats collection
Oracle 11gR2
By: ravikanth_b on Thu, 24 April 2014
8 1312 Thu, 24 April 2014 19:43
By: BlackSwan
  Need to Understand Explain plan
By: na.dharma@gmail.com on Thu, 24 April 2014
2 1048 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 1580 Wed, 23 April 2014 08:17
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: Sun Sep 24 21:47:09 CDT 2017

Total time taken to generate the page: 0.06600 seconds