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

    Replies Views Last message
  Options for optimising SQL running against Wide tables
11g
By: jasontilbury on Tue, 13 November 2012
9 1116 Mon, 19 November 2012 15:16
By: rleishman
  dba_hist_sqlstat
11.2.0.3 || Solaris
By: Roachcoach on Mon, 12 November 2012
5 2238 Wed, 14 November 2012 20:16
By: alan.kendall@nfl.com
  Slow Join between dba_tab_cols and dba_types
By: ocdeveloper on Wed, 14 November 2012
1 1034 Wed, 14 November 2012 13:20
By: BlackSwan
  Alternate Query instead of querying the table twice
Oracle 11G,R2
By: prashanth7582 on Sun, 11 November 2012
5 824 Wed, 14 November 2012 08:29
By: Kevin Meade
  Tuning SELECT-WHERE-BETWEEN
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: rop4 on Mon, 12 November 2012
4 843 Tue, 13 November 2012 05:52
By: rleishman
icon5.gif how to examine the impact of a too long varchar2 field
Oracle Database 10g R2
By: beingman on Tue, 06 November 2012
13 900 Mon, 12 November 2012 12:56
By: Kevin Meade
  Long running query
Oracle 11.2
By: lakshmis on Tue, 06 November 2012
9 1251 Sun, 11 November 2012 23:50
By: lakshmis
  DBMS_AUTO_SQLTUNE
CentOS 6.2 64-bit, Oracle11gR2 11.2.0.3.0
By: debrucer2 on Mon, 05 November 2012
2 2488 Mon, 05 November 2012 23:54
By: Michel Cadot
  Table rebuild should be done after removing most of its data?
Oracle 10.2.0.4 on Solaris 10
By: orausern on Tue, 23 October 2012
4 1113 Mon, 05 November 2012 17:47
By: alan.kendall@nfl.com
  Different SQL ID for same SQL/HASH_VALUE
10.2.0.3, Solaris 5.9
By: suddhasatwa_bhaumik on Fri, 02 November 2012
10 2735 Mon, 05 November 2012 11:40
By: LNossov
  Performance degrades as dB size increases
Oracle 11gr2 Server 2008r2
By: segan1415 on Thu, 01 November 2012
1 1101 Fri, 02 November 2012 03:52
By: John Watson
  SQL execution plan different on different hardware
Oracle 11gR2, AIX
By: hjoshi on Wed, 31 October 2012
3 647 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 972 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 1160 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 2049 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 1961 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 1401 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 792 Fri, 19 October 2012 05:07
By: ardhendu
  incremental stats not happening
ORACLE 11GR2 SOLARIS
By: guddu_12 on Mon, 15 October 2012
3 783 Thu, 18 October 2012 12:28
By: Littlefoot
  NOLOGGING in Oracle 11gr2
Oracle 11gr2 Server 2008r2
By: segan1415 on Tue, 16 October 2012
26 8843 Thu, 18 October 2012 09:18
By: segan1415
  Improve performance postgre
By: perfectioi on Wed, 10 October 2012
4 714 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 660 Wed, 10 October 2012 05:36
By: ndg123
  cluter in index
oracle 11gr2
By: guddu_12 on Thu, 04 October 2012
4 661 Fri, 05 October 2012 17:19
By: rleishman
  Is this a bug on Oracle11gr2?
11gr2
By: alantany on Tue, 25 September 2012
5 1119 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 2623 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 937 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 1821 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 1123 Mon, 24 September 2012 19:39
By: reym21
  Analytics and Predicate Pushing
9i/10g/11g
By: Kevin Meade on Thu, 20 September 2012
18 2166 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 2891 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 2474 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 1720 Tue, 18 September 2012 14:04
By: Littlefoot
  FOR Loop and Driving Site
Oracle 11g
By: wmgonzalbo on Tue, 18 September 2012
1 858 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 6055 Mon, 17 September 2012 13:09
By: Michel Cadot
  Improve procedure's performance
By: suryay22 on Fri, 14 September 2012
7 1022 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 1272 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 839 Wed, 12 September 2012 23:50
By: Michel Cadot
  tuning stats command
ORACLE 11GR2 SOLARIS
By: guddu_12 on Tue, 11 September 2012
1 485 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 751 Sat, 08 September 2012 16:36
By: arif_md2009
  Explain plan of a query
Oracle 11g
By: sathik on Wed, 05 September 2012
16 1699 Fri, 07 September 2012 07:52
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: Sat Jan 31 23:53:22 CST 2015

Total time taken to generate the page: 0.10771 seconds