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 query taking High CPU and execution time in oracle 11gR2
Oracle 11g R2
By: pappu123 on Mon, 24 December 2012
15 4131 Wed, 26 December 2012 23:49
By: BlackSwan
  Help in tuning the query
Oracle DB, 11.1.0.7.0, AIX 6
By: kiranpuli on Mon, 24 December 2012
6 862 Mon, 24 December 2012 08:38
By: Michel Cadot
  what's operation can cause these wait event?
By: lonion on Thu, 06 December 2012
2 899 Wed, 19 December 2012 12:45
By: alan.kendall@nfl.com
  Adaptive cursor sharing Doubt!!
Oracle 11g (11.2.0.3.0 ) - Linux
By: rishwinger on Tue, 18 December 2012
10 1377 Wed, 19 December 2012 04:52
By: rishwinger
  How to run a query with an different plan_hash value then in GV$SQL_PLAN
Oracle 10.2.0.4.0 RAC on Linux
By: Andrey_R on Tue, 27 November 2012
2 1206 Mon, 17 December 2012 17:14
By: LNossov
  SQL Tuning...?
Oracle 10G
By: gblackiv on Thu, 13 December 2012
6 693 Thu, 13 December 2012 10:41
By: cookiemonster
  Please help me on tune this query
Oracle 11g
By: ajaykumarkona on Mon, 10 December 2012
8 882 Wed, 12 December 2012 11:50
By: Kevin Meade
  RBS usage and longops in toad
By: nunnaravi@yahoo.com on Tue, 11 December 2012
1 1474 Tue, 11 December 2012 06:40
By: Michel Cadot
  Please help me to tune this query
Oracle 11g
By: ajaykumarkona on Tue, 04 December 2012
2 1007 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 3594 Tue, 04 December 2012 21:03
By: Kevin Meade
  Help in Oracle Query Optimization
Oracle 10g
By: sanand7984 on Tue, 04 December 2012
3 835 Tue, 04 December 2012 17:01
By: Kevin Meade
  Parallel Feature
11g R2
By: TRaj on Tue, 04 December 2012
1 440 Tue, 04 December 2012 09:50
By: BlackSwan
  Checkpoint not complete
By: David King on Thu, 15 September 2005
6 20830 Sat, 01 December 2012 19:51
By: alliejane
  Bloom filters
11.2.0.3
By: John Watson on Fri, 30 November 2012
0 1542 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 896 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 441 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 1838 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 1050 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 536 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 886 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 1144 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 877 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 1050 Mon, 19 November 2012 15:16
By: rleishman
  dba_hist_sqlstat
11.2.0.3 || Solaris
By: Roachcoach on Mon, 12 November 2012
5 2166 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 1007 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 801 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 811 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 870 Mon, 12 November 2012 12:56
By: Kevin Meade
  Long running query
Oracle 11.2
By: lakshmis on Tue, 06 November 2012
9 1231 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 2394 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 1072 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 2637 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 985 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 636 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 932 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 1132 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 1943 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 1903 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 1363 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 771 Fri, 19 October 2012 05:07
By: ardhendu
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 Dec 17 23:46:42 CST 2014

Total time taken to generate the page: 0.15165 seconds