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

    Replies Views Last message
  SQL execution plan different on different hardware
Oracle 11gR2, AIX
By: hjoshi on Wed, 31 October 2012
3 596 Thu, 01 November 2012 02:36
By: John Watson
  NESTED LOOPS JOIN and DISTRIBUTED OPERATIONS
9i/10g/11g
By: Kevin Meade on Tue, 30 October 2012
5 857 Wed, 31 October 2012 08:13
By: Kevin Meade
  Merge Join Cartesian in Outline Data
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Wed, 31 October 2012
0 1048 Wed, 31 October 2012 06:47
By: manubatham20
  [11g]Direct-path insert / temp usage / PGA
Oracle 11gr2 / linux 2.6 x86_64
By: nikko on Tue, 30 October 2012
3 1749 Wed, 31 October 2012 04:19
By: nikko
  How tune the following query?
Oracle 9i
By: kumar_hi21@yahoo.com on Tue, 23 October 2012
4 1729 Mon, 29 October 2012 23:05
By: Kevin Meade
  How Oracle optimizer choose joins (hash, Merge & nested loop join)
By: ukumarjsr2 on Thu, 18 October 2012
2 1265 Mon, 29 October 2012 22:56
By: Kevin Meade
  Proper index is not used ...
Oracle, 11.2.0.2, Linux 5.5
By: ardhendu on Wed, 17 October 2012
4 722 Fri, 19 October 2012 05:07
By: ardhendu
  incremental stats not happening
ORACLE 11GR2 SOLARIS
By: guddu_12 on Mon, 15 October 2012
3 715 Thu, 18 October 2012 12:28
By: Littlefoot
  NOLOGGING in Oracle 11gr2
Oracle 11gr2 Server 2008r2
By: segan1415 on Tue, 16 October 2012
26 7611 Thu, 18 October 2012 09:18
By: segan1415
  Improve performance postgre
By: perfectioi on Wed, 10 October 2012
4 670 Wed, 10 October 2012 11:39
By: BlackSwan
icon5.gif SSL on database connections
Oracle EE ver 11, linux
By: ndg123 on Wed, 10 October 2012
4 601 Wed, 10 October 2012 05:36
By: ndg123
  cluter in index
oracle 11gr2
By: guddu_12 on Thu, 04 October 2012
4 596 Fri, 05 October 2012 17:19
By: rleishman
  Is this a bug on Oracle11gr2?
11gr2
By: alantany on Tue, 25 September 2012
5 1015 Thu, 04 October 2012 15:20
By: Flyby
  Help required for tuning referring AWR Reports
Oracle 10.2.0.4.0 on linux
By: orapratap on Thu, 30 August 2012
5 2390 Thu, 04 October 2012 02:17
By: Roachcoach
  how to tune 100s of transactions over single table
By: kamilp on Mon, 24 September 2012
10 824 Tue, 02 October 2012 17:24
By: alan.kendall@nfl.com
  What does analyzing a table do for the indexes ?
Oracle 11g Win 7
By: jxh461 on Wed, 26 September 2012
2 1677 Tue, 02 October 2012 16:48
By: alan.kendall@nfl.com
  appropriate memory
Oracle 11g/ 10g/ 9i - Solaris 10
By: reym21 on Sun, 16 September 2012
6 1029 Mon, 24 September 2012 19:39
By: reym21
  Analytics and Predicate Pushing
9i/10g/11g
By: Kevin Meade on Thu, 20 September 2012
18 1915 Mon, 24 September 2012 08:14
By: Kevin Meade
  dbms_stats.gather_index_stats vs dbms_stats.gather_table_stats
11.2.0.1
By: c_stenersen on Fri, 21 September 2012
2 2448 Fri, 21 September 2012 06:28
By: c_stenersen
  HIBERNATE query runs slow but ok in SQLPLUS
Oracle 11g
By: brown_zzz on Fri, 14 September 2012
7 2252 Tue, 18 September 2012 14:20
By: alan.kendall@nfl.com
  Remove SQL*Net waitevent from top 5 list
Oracle 11.2.0.2
By: sathik on Mon, 17 September 2012
11 1546 Tue, 18 September 2012 14:04
By: Littlefoot
  FOR Loop and Driving Site
Oracle 11g
By: wmgonzalbo on Tue, 18 September 2012
1 778 Tue, 18 September 2012 04:21
By: Michel Cadot
  inbound connection timed out (ORA-3136)
ORACLE DB 10g(64 bit) R2
By: p.anshuman1 on Thu, 24 May 2012
4 5657 Mon, 17 September 2012 13:09
By: Michel Cadot
  Improve procedure's performance
By: suryay22 on Fri, 14 September 2012
7 887 Sun, 16 September 2012 14:43
By: Kevin Meade
  Help needed to tune the SQL (merged 2)
By: parthaspaul on Thu, 06 September 2012
7 1166 Sun, 16 September 2012 11:03
By: Kevin Meade
icon9.gif ASH Report
Oracle 11G,Linux 5
By: saagar on Wed, 12 September 2012
7 740 Wed, 12 September 2012 23:50
By: Michel Cadot
  tuning stats command
ORACLE 11GR2 SOLARIS
By: guddu_12 on Tue, 11 September 2012
1 432 Tue, 11 September 2012 04:39
By: Michel Cadot
  Tuning issue
Oracle 10.0.2.1
By: arif_md2009 on Thu, 06 September 2012
4 685 Sat, 08 September 2012 16:36
By: arif_md2009
  Explain plan of a query
Oracle 11g
By: sathik on Wed, 05 September 2012
16 1570 Fri, 07 September 2012 07:52
By: BlackSwan
  Slow running query (3 Merged)
Oracle 11g
By: brown_zzz on Wed, 05 September 2012
4 755 Wed, 05 September 2012 11:57
By: BlackSwan
  How to Control concurrent Inserts of a record by parallel sessions
Oracle 10.2.0.4
By: orapratap on Tue, 07 August 2012
4 939 Fri, 31 August 2012 21:38
By: Kevin Meade
  ORA-01652-unable to extend temp segment by 128 in tablespace TEMP
11.1.0.7.0
By: Scowron on Wed, 25 July 2012
10 8093 Thu, 30 August 2012 15:25
By: wakula
  SQL Tuning Assistance Required
Oracle 10.2.0.3, PeopleSoft 8.8, PeopleTools 8.49
By: SBhaumik_DBA on Tue, 28 August 2012
6 1157 Tue, 28 August 2012 06:35
By: cookiemonster
  index behaviour
11.2.0.3.0
By: piotrtal on Sat, 25 August 2012
6 996 Sun, 26 August 2012 09:30
By: BlackSwan
  restart database after increase the db_cache_size?
oracle 10.2.0.4 , sun solaris 5.10 64bit
By: shmily2012 on Thu, 23 August 2012
6 3293 Fri, 24 August 2012 14:11
By: alan.kendall@nfl.com
  ORA-00439: feature not enabled: Bit-mapped indexes
By: Sunil Bassi on Mon, 29 March 2004
10 19872 Wed, 22 August 2012 06:19
By: Michel Cadot
icon5.gif Frequent changed table stats problem
Oracle 10.2.0.4, AIX 5.3 64bit
By: snowball on Mon, 06 August 2012
10 1085 Wed, 22 August 2012 01:14
By: LNossov
  SQL Statement taking too long (merged 3)
Oracle 11.2.0, AIX 6.1 (64bit)
By: Creems on Tue, 21 August 2012
5 646 Tue, 21 August 2012 16:52
By: Creems
  Slow query with full table scan
ORACLE 11
By: brown_zzz on Sat, 18 August 2012
16 2287 Tue, 21 August 2012 09:36
By: Kevin Meade
  Performance Issue while truncating table partition. (3 Merged)
Oracle 11g , Linux
By: palanisvr on Tue, 24 July 2012
2 1182 Tue, 21 August 2012 06:30
By: Kevin Meade
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 Sep 16 11:16:10 CDT 2014

Total time taken to generate the page: 0.18902 seconds