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

    Replies Views Last message
  LONG to CLOB conversion in huge tables
11g 11.2.0.3
By: gnmurthy86 on Fri, 25 January 2013
6 2070 Wed, 13 February 2013 16:59
By: xtender
  Physical Reads & Logical Reads
10g
By: gatetec on Fri, 18 January 2013
9 4003 Tue, 22 January 2013 17:57
By: alan.kendall@nfl.com
  does 11g not do a soft parse when we set cursor_cached_curosr?
11gr2
By: alantany on Tue, 15 January 2013
4 2300 Tue, 15 January 2013 09:29
By: alantany
icon5.gif Tune a cursor
By: cherryreddi on Mon, 14 January 2013
3 1263 Mon, 14 January 2013 14:46
By: xtender
  AWR Baseline in RAC
Oracle 10.2.0.3 on AIX
By: sysdba007 on Fri, 11 January 2013
1 1102 Fri, 11 January 2013 08:33
By: Michel Cadot
  cpu utilizaton
By: maninderkrb on Tue, 08 January 2013
6 1204 Tue, 08 January 2013 08:41
By: BlackSwan
  num_rows on user_indexes vs table_indexes
11.2 AIX 6.1
By: tom_watson on Mon, 07 January 2013
5 1329 Mon, 07 January 2013 16:12
By: LNossov
  Need the Tuinng Tips for Tuning The package
By: mvrkr44 on Mon, 07 January 2013
5 950 Mon, 07 January 2013 01:55
By: Michel Cadot
  Server Specification
Capacity Building
By: emorka on Thu, 10 January 2013
7 3295 Sat, 09 February 2013 10:31
By: vamsi kasina
  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 10199 Thu, 30 May 2013 09:16
By: sysdba007
  Extended Statistics
By: alantany on Thu, 03 January 2013
12 2001 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 3380 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 2947 Thu, 03 January 2013 22:33
By: rishwinger
  OCI client result cache
11.2.x
By: John Watson on Wed, 02 January 2013
4 1726 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 9650 Thu, 03 January 2013 19:32
By: alan.kendall@nfl.com
  Sql Running Slowly
9i
By: snehal123 on Mon, 31 December 2012
11 1472 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 1732 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 8964 Wed, 26 December 2012 23:49
By: BlackSwan
  indexing
Oracle 10g
By: arif_md2009 on Fri, 21 December 2012
5 1228 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 2472 Wed, 19 December 2012 04:52
By: rishwinger
  SQL Tuning...?
Oracle 10G
By: gblackiv on Thu, 13 December 2012
6 1255 Thu, 13 December 2012 10:41
By: cookiemonster
  RBS usage and longops in toad
By: nunnaravi@yahoo.com on Tue, 11 December 2012
1 3330 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 1419 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 2758 Wed, 30 October 2013 08:49
By: pablolee
  what's operation can cause these wait event?
By: lonion on Thu, 06 December 2012
2 1893 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 3058 Tue, 01 January 2013 23:31
By: grpatwari
  Help in Oracle Query Optimization
Oracle 10g
By: sanand7984 on Tue, 04 December 2012
3 1286 Tue, 04 December 2012 17:01
By: Kevin Meade
  Parallel Feature
11g R2
By: TRaj on Tue, 04 December 2012
1 1013 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 1519 Wed, 05 December 2012 14:35
By: Flyby
  Joins and in-line views
Oracle 11.2
By: lakshmis on Mon, 03 December 2012
8 2967 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 2015 Fri, 04 January 2013 00:59
By: Michel Cadot
  Bloom filters
11.2.0.3
By: John Watson on Fri, 30 November 2012
0 2873 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 7943 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 743 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 1842 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 1777 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 906 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 1794 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 1418 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 2747 Wed, 28 November 2012 03:22
By: grpatwari
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: Sat Oct 21 20:26:30 CDT 2017

Total time taken to generate the page: 0.02166 seconds