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

    Replies Views Last message
  Parallel Feature
11g R2
By: TRaj on Tue, 04 December 2012
1 371 Tue, 04 December 2012 09:50
By: BlackSwan
  Checkpoint not complete
By: David King on Thu, 15 September 2005
6 20551 Sat, 01 December 2012 19:51
By: alliejane
  Bloom filters
11.2.0.3
By: John Watson on Fri, 30 November 2012
0 1328 Fri, 30 November 2012 02:35
By: John Watson
  Database Reorganisation
Oracle 10g, IBM AIX 5.3
By: oradba123 on Sat, 15 October 2011
2 826 Fri, 30 November 2012 01:09
By: atcharao
  Top 5 long running using DBA_* hist views
Oracle 11g, Linux
By: ram anand on Wed, 28 November 2012
1 395 Wed, 28 November 2012 07:40
By: Michel Cadot
  Tune the materialized view
10.2.4.0
By: grpatwari on Thu, 15 November 2012
13 1691 Wed, 28 November 2012 03:22
By: grpatwari
  Query rewrite - high temp utilization
Oracle, 8.1.7.4.0, sunOS
By: sathik on Tue, 27 November 2012
3 916 Tue, 27 November 2012 05:16
By: Michel Cadot
  How to capture the problem with some sql timeout
Oracle 10.2.0.4, AIX 5.3 64bit
By: snowball on Mon, 26 November 2012
4 473 Tue, 27 November 2012 01:11
By: pvsarat
  TKprof generation for short duration
10.2.0.1, linux-4.5
By: ishika_20 on Mon, 05 November 2012
7 805 Sat, 24 November 2012 05:58
By: ishika_20
  Inner join query tuning
10.2.0.3, windows XP
By: ishika_20 on Thu, 22 November 2012
7 1052 Sat, 24 November 2012 05:55
By: ishika_20
  Oracle memory parameters
Oracle 9.2.0.8, Solaris 9
By: milicab on Sun, 18 November 2012
2 818 Wed, 21 November 2012 13:59
By: alan.kendall@nfl.com
  Options for optimising SQL running against Wide tables
11g
By: jasontilbury on Tue, 13 November 2012
9 887 Mon, 19 November 2012 15:16
By: rleishman
  dba_hist_sqlstat
11.2.0.3 || Solaris
By: Roachcoach on Mon, 12 November 2012
5 1884 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 926 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 729 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 726 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 760 Mon, 12 November 2012 12:56
By: Kevin Meade
  Long running query
Oracle 11.2
By: lakshmis on Tue, 06 November 2012
9 1121 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 2010 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 974 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 2184 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 878 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 565 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 819 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 1015 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 1670 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 1659 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 1224 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 697 Fri, 19 October 2012 05:07
By: ardhendu
  incremental stats not happening
ORACLE 11GR2 SOLARIS
By: guddu_12 on Mon, 15 October 2012
3 692 Thu, 18 October 2012 12:28
By: Littlefoot
  NOLOGGING in Oracle 11gr2
Oracle 11gr2 Server 2008r2
By: segan1415 on Tue, 16 October 2012
26 7255 Thu, 18 October 2012 09:18
By: segan1415
  Improve performance postgre
By: perfectioi on Wed, 10 October 2012
4 650 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 571 Wed, 10 October 2012 05:36
By: ndg123
  cluter in index
oracle 11gr2
By: guddu_12 on Thu, 04 October 2012
4 582 Fri, 05 October 2012 17:19
By: rleishman
  Is this a bug on Oracle11gr2?
11gr2
By: alantany on Tue, 25 September 2012
5 986 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 2313 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 779 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 1615 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 992 Mon, 24 September 2012 19:39
By: reym21
  Analytics and Predicate Pushing
9i/10g/11g
By: Kevin Meade on Thu, 20 September 2012
18 1847 Mon, 24 September 2012 08:14
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: Wed Jul 30 19:12:52 CDT 2014

Total time taken to generate the page: 0.13697 seconds