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

    Replies Views Last message
  Please help me to tune this query
Oracle 11g
By: ajaykumarkona on Tue, 04 December 2012
2 1049 Wed, 05 December 2012 14:35
By: Flyby
  need more memory for hash joins
9i / 10g / 11gR2
By: Kevin Meade on Wed, 28 November 2012
5 3977 Tue, 04 December 2012 21:03
By: Kevin Meade
  Help in Oracle Query Optimization
Oracle 10g
By: sanand7984 on Tue, 04 December 2012
3 877 Tue, 04 December 2012 17:01
By: Kevin Meade
  Parallel Feature
11g R2
By: TRaj on Tue, 04 December 2012
1 463 Tue, 04 December 2012 09:50
By: BlackSwan
  Checkpoint not complete
By: David King on Thu, 15 September 2005
6 20972 Sat, 01 December 2012 19:51
By: alliejane
  Bloom filters
11.2.0.3
By: John Watson on Fri, 30 November 2012
0 1625 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 917 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 452 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 1918 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 1117 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 566 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 933 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 1183 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 897 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 1137 Mon, 19 November 2012 15:16
By: rleishman
  dba_hist_sqlstat
11.2.0.3 || Solaris
By: Roachcoach on Mon, 12 November 2012
5 2297 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 1106 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 833 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 850 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 919 Mon, 12 November 2012 12:56
By: Kevin Meade
  Long running query
Oracle 11.2
By: lakshmis on Tue, 06 November 2012
9 1269 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 2569 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 1142 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 2838 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 1286 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 656 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 989 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 1179 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 2085 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 1999 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 1421 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 801 Fri, 19 October 2012 05:07
By: ardhendu
  incremental stats not happening
ORACLE 11GR2 SOLARIS
By: guddu_12 on Mon, 15 October 2012
3 792 Thu, 18 October 2012 12:28
By: Littlefoot
  NOLOGGING in Oracle 11gr2
Oracle 11gr2 Server 2008r2
By: segan1415 on Tue, 16 October 2012
26 9040 Thu, 18 October 2012 09:18
By: segan1415
  Improve performance postgre
By: perfectioi on Wed, 10 October 2012
4 721 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 668 Wed, 10 October 2012 05:36
By: ndg123
  cluter in index
oracle 11gr2
By: guddu_12 on Thu, 04 October 2012
4 670 Fri, 05 October 2012 17:19
By: rleishman
  Is this a bug on Oracle11gr2?
11gr2
By: alantany on Tue, 25 September 2012
5 1148 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 2656 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 956 Tue, 02 October 2012 17:24
By: alan.kendall@nfl.com
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: Fri Mar 06 01:58:23 CST 2015

Total time taken to generate the page: 0.10393 seconds