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

    Replies Views Last message
  CURRENT_OBJ# -1 in v$active_session_history
By: tom_watson on Thu, 03 January 2013
8 1297 Fri, 04 January 2013 05:41
By: Michel Cadot
  suggestion for increasing the buffer cache
Oracle, 9.2.0.8, sunOS
By: savugar on Fri, 30 November 2012
11 1124 Fri, 04 January 2013 00:59
By: Michel Cadot
  SQL Plan Baseline Trouble!!!
Oracle 11.2.0.3.0 & Oracle 10.2.0.1.0
By: rishwinger on Thu, 03 January 2013
9 1485 Thu, 03 January 2013 22:33
By: rishwinger
  Memory_target and sga_target in oracle 11gR2
Linux, Oracle 11g, 11.2.0
By: suresh.wst on Sat, 29 December 2012
6 4726 Thu, 03 January 2013 19:32
By: alan.kendall@nfl.com
  OCI client result cache
11.2.x
By: John Watson on Wed, 02 January 2013
4 866 Thu, 03 January 2013 07:03
By: John Watson
  Sql Running Slowly
9i
By: snehal123 on Mon, 31 December 2012
11 821 Wed, 02 January 2013 09:55
By: LNossov
  Tuning the sql query
10.2.0.4
By: grpatwari on Wed, 05 December 2012
29 2184 Tue, 01 January 2013 23:31
By: grpatwari
  indexing
Oracle 10g
By: arif_md2009 on Fri, 21 December 2012
5 839 Sat, 29 December 2012 03:26
By: arif_md2009
  Sql query taking High CPU and execution time in oracle 11gR2
Oracle 11g R2
By: pappu123 on Mon, 24 December 2012
15 3671 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 801 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 808 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 1254 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 1125 Mon, 17 December 2012 17:14
By: LNossov
  SQL Tuning...?
Oracle 10G
By: gblackiv on Thu, 13 December 2012
6 646 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 831 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 1256 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 961 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 3134 Tue, 04 December 2012 21:03
By: Kevin Meade
  Help in Oracle Query Optimization
Oracle 10g
By: sanand7984 on Tue, 04 December 2012
3 776 Tue, 04 December 2012 17:01
By: Kevin Meade
  Parallel Feature
11g R2
By: TRaj on Tue, 04 December 2012
1 400 Tue, 04 December 2012 09:50
By: BlackSwan
  Checkpoint not complete
By: David King on Thu, 15 September 2005
6 20650 Sat, 01 December 2012 19:51
By: alliejane
  Bloom filters
11.2.0.3
By: John Watson on Fri, 30 November 2012
0 1401 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 849 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 407 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 1743 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 957 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 495 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 836 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 1081 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 844 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 951 Mon, 19 November 2012 15:16
By: rleishman
  dba_hist_sqlstat
11.2.0.3 || Solaris
By: Roachcoach on Mon, 12 November 2012
5 1981 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 953 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 755 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 759 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 812 Mon, 12 November 2012 12:56
By: Kevin Meade
  Long running query
Oracle 11.2
By: lakshmis on Tue, 06 November 2012
9 1158 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 2138 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 1004 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 2354 Mon, 05 November 2012 11:40
By: LNossov
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: Sun Sep 21 05:49:58 CDT 2014

Total time taken to generate the page: 0.08242 seconds