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

    Replies Views Last message
  High System I/O Wait Class on AWR
Oracle 10.2.0.4 EE 64-bit, Solaris 10
By: cklh2000 on Fri, 04 January 2013
10 9750 Thu, 30 May 2013 09:16
By: sysdba007
  Extended Statistics
By: alantany on Thu, 03 January 2013
12 1943 Fri, 04 January 2013 23:40
By: alantany
  CURRENT_OBJ# -1 in v$active_session_history
By: tom_watson on Thu, 03 January 2013
8 3194 Fri, 04 January 2013 05:41
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 2789 Thu, 03 January 2013 22:33
By: rishwinger
  OCI client result cache
11.2.x
By: John Watson on Wed, 02 January 2013
4 1684 Thu, 03 January 2013 07:03
By: John Watson
  Memory_target and sga_target in oracle 11gR2
Linux, Oracle 11g, 11.2.0
By: suresh.wst on Sat, 29 December 2012
6 9481 Thu, 03 January 2013 19:32
By: alan.kendall@nfl.com
  Sql Running Slowly
9i
By: snehal123 on Mon, 31 December 2012
11 1421 Wed, 02 January 2013 09:55
By: LNossov
  Help in tuning the query
Oracle DB, 11.1.0.7.0, AIX 6
By: kiranpuli on Mon, 24 December 2012
6 1639 Mon, 24 December 2012 08:38
By: Michel Cadot
  Sql query taking High CPU and execution time in oracle 11gR2
Oracle 11g R2
By: pappu123 on Mon, 24 December 2012
15 8735 Wed, 26 December 2012 23:49
By: BlackSwan
  indexing
Oracle 10g
By: arif_md2009 on Fri, 21 December 2012
5 1202 Sat, 29 December 2012 03:26
By: arif_md2009
  Adaptive cursor sharing Doubt!!
Oracle 11g (11.2.0.3.0 ) - Linux
By: rishwinger on Tue, 18 December 2012
10 2384 Wed, 19 December 2012 04:52
By: rishwinger
  SQL Tuning...?
Oracle 10G
By: gblackiv on Thu, 13 December 2012
6 1210 Thu, 13 December 2012 10:41
By: cookiemonster
  RBS usage and longops in toad
By: nunnaravi@yahoo.com on Tue, 11 December 2012
1 3263 Tue, 11 December 2012 06:40
By: Michel Cadot
  Please help me on tune this query
Oracle 11g
By: ajaykumarkona on Mon, 10 December 2012
8 1386 Wed, 12 December 2012 11:50
By: Kevin Meade
  Please help me on tune this query
Oracle 11g
By: ajaykumarkona on Tue, 11 December 2012
27 2649 Wed, 30 October 2013 08:49
By: pablolee
  what's operation can cause these wait event?
By: lonion on Thu, 06 December 2012
2 1834 Wed, 19 December 2012 12:45
By: alan.kendall@nfl.com
  Tuning the sql query
10.2.0.4
By: grpatwari on Wed, 05 December 2012
29 2975 Tue, 01 January 2013 23:31
By: grpatwari
  Help in Oracle Query Optimization
Oracle 10g
By: sanand7984 on Tue, 04 December 2012
3 1263 Tue, 04 December 2012 17:01
By: Kevin Meade
  Parallel Feature
11g R2
By: TRaj on Tue, 04 December 2012
1 955 Tue, 04 December 2012 09:50
By: BlackSwan
  Please help me to tune this query
Oracle 11g
By: ajaykumarkona on Tue, 04 December 2012
2 1498 Wed, 05 December 2012 14:35
By: Flyby
  Joins and in-line views
Oracle 11.2
By: lakshmis on Mon, 03 December 2012
8 2907 Mon, 18 February 2013 03:18
By: TuneMyQuery
  suggestion for increasing the buffer cache
Oracle, 9.2.0.8, sunOS
By: savugar on Fri, 30 November 2012
11 1957 Fri, 04 January 2013 00:59
By: Michel Cadot
  Bloom filters
11.2.0.3
By: John Watson on Fri, 30 November 2012
0 2829 Fri, 30 November 2012 02:35
By: John Watson
  need more memory for hash joins
9i / 10g / 11gR2
By: Kevin Meade on Wed, 28 November 2012
5 7746 Tue, 04 December 2012 21:03
By: Kevin Meade
  Top 5 long running using DBA_* hist views
Oracle 11g, Linux
By: ram anand on Wed, 28 November 2012
1 732 Wed, 28 November 2012 07:40
By: Michel Cadot
  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 1814 Mon, 17 December 2012 17:14
By: LNossov
  Query rewrite - high temp utilization
Oracle, 8.1.7.4.0, sunOS
By: sathik on Tue, 27 November 2012
3 1749 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 887 Tue, 27 November 2012 01:11
By: pvsarat
  Inner join query tuning
10.2.0.3, windows XP
By: ishika_20 on Thu, 22 November 2012
7 1740 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 1384 Wed, 21 November 2012 13:59
By: alan.kendall@nfl.com
  Tune the materialized view
10.2.4.0
By: grpatwari on Thu, 15 November 2012
13 2682 Wed, 28 November 2012 03:22
By: grpatwari
  Options for optimising SQL running against Wide tables
11g
By: jasontilbury on Tue, 13 November 2012
9 1976 Mon, 19 November 2012 15:16
By: rleishman
  Tuning SELECT-WHERE-BETWEEN
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0
By: rop4 on Mon, 12 November 2012
4 1282 Tue, 13 November 2012 05:52
By: rleishman
  dba_hist_sqlstat
11.2.0.3 || Solaris
By: Roachcoach on Mon, 12 November 2012
5 3534 Wed, 14 November 2012 20:16
By: alan.kendall@nfl.com
  Alternate Query instead of querying the table twice
Oracle 11G,R2
By: prashanth7582 on Sun, 11 November 2012
5 1518 Wed, 14 November 2012 08:29
By: Kevin Meade
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 1848 Mon, 12 November 2012 12:56
By: Kevin Meade
  Long running query
Oracle 11.2
By: lakshmis on Tue, 06 November 2012
9 1815 Sun, 11 November 2012 23:50
By: lakshmis
  TKprof generation for short duration
10.2.0.1, linux-4.5
By: ishika_20 on Mon, 05 November 2012
7 1513 Sat, 24 November 2012 05:58
By: ishika_20
  DBMS_AUTO_SQLTUNE
CentOS 6.2 64-bit, Oracle11gR2 11.2.0.3.0
By: debrucer2 on Mon, 05 November 2012
2 5707 Mon, 05 November 2012 23:54
By: Michel Cadot
  Different SQL ID for same SQL/HASH_VALUE
10.2.0.3, Solaris 5.9
By: suddhasatwa_bhaumik on Fri, 02 November 2012
10 6926 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 Aug 20 18:16:48 CDT 2017

Total time taken to generate the page: 0.15468 seconds