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

    Replies Views Last message
  What does analyzing a table do for the indexes ?
Oracle 11g Win 7
By: jxh461 on Wed, 26 September 2012
2 1760 Tue, 02 October 2012 16:48
By: alan.kendall@nfl.com
  appropriate memory
Oracle 11g/ 10g/ 9i - Solaris 10
By: reym21 on Sun, 16 September 2012
6 1077 Mon, 24 September 2012 19:39
By: reym21
  Analytics and Predicate Pushing
9i/10g/11g
By: Kevin Meade on Thu, 20 September 2012
18 2048 Mon, 24 September 2012 08:14
By: Kevin Meade
  dbms_stats.gather_index_stats vs dbms_stats.gather_table_stats
11.2.0.1
By: c_stenersen on Fri, 21 September 2012
2 2689 Fri, 21 September 2012 06:28
By: c_stenersen
  HIBERNATE query runs slow but ok in SQLPLUS
Oracle 11g
By: brown_zzz on Fri, 14 September 2012
7 2375 Tue, 18 September 2012 14:20
By: alan.kendall@nfl.com
  Remove SQL*Net waitevent from top 5 list
Oracle 11.2.0.2
By: sathik on Mon, 17 September 2012
11 1644 Tue, 18 September 2012 14:04
By: Littlefoot
  FOR Loop and Driving Site
Oracle 11g
By: wmgonzalbo on Tue, 18 September 2012
1 821 Tue, 18 September 2012 04:21
By: Michel Cadot
  inbound connection timed out (ORA-3136)
ORACLE DB 10g(64 bit) R2
By: p.anshuman1 on Thu, 24 May 2012
4 5884 Mon, 17 September 2012 13:09
By: Michel Cadot
  Improve procedure's performance
By: suryay22 on Fri, 14 September 2012
7 959 Sun, 16 September 2012 14:43
By: Kevin Meade
  Help needed to tune the SQL (merged 2)
By: parthaspaul on Thu, 06 September 2012
7 1211 Sun, 16 September 2012 11:03
By: Kevin Meade
icon9.gif ASH Report
Oracle 11G,Linux 5
By: saagar on Wed, 12 September 2012
7 797 Wed, 12 September 2012 23:50
By: Michel Cadot
  tuning stats command
ORACLE 11GR2 SOLARIS
By: guddu_12 on Tue, 11 September 2012
1 462 Tue, 11 September 2012 04:39
By: Michel Cadot
  Tuning issue
Oracle 10.0.2.1
By: arif_md2009 on Thu, 06 September 2012
4 723 Sat, 08 September 2012 16:36
By: arif_md2009
  Explain plan of a query
Oracle 11g
By: sathik on Wed, 05 September 2012
16 1629 Fri, 07 September 2012 07:52
By: BlackSwan
  Slow running query (3 Merged)
Oracle 11g
By: brown_zzz on Wed, 05 September 2012
4 812 Wed, 05 September 2012 11:57
By: BlackSwan
  How to Control concurrent Inserts of a record by parallel sessions
Oracle 10.2.0.4
By: orapratap on Tue, 07 August 2012
4 979 Fri, 31 August 2012 21:38
By: Kevin Meade
  ORA-01652-unable to extend temp segment by 128 in tablespace TEMP
11.1.0.7.0
By: Scowron on Wed, 25 July 2012
10 8478 Thu, 30 August 2012 15:25
By: wakula
  SQL Tuning Assistance Required
Oracle 10.2.0.3, PeopleSoft 8.8, PeopleTools 8.49
By: SBhaumik_DBA on Tue, 28 August 2012
6 1261 Tue, 28 August 2012 06:35
By: cookiemonster
  index behaviour
11.2.0.3.0
By: piotrtal on Sat, 25 August 2012
6 1040 Sun, 26 August 2012 09:30
By: BlackSwan
  restart database after increase the db_cache_size?
oracle 10.2.0.4 , sun solaris 5.10 64bit
By: shmily2012 on Thu, 23 August 2012
6 3652 Fri, 24 August 2012 14:11
By: alan.kendall@nfl.com
  ORA-00439: feature not enabled: Bit-mapped indexes
By: Sunil Bassi on Mon, 29 March 2004
10 20246 Wed, 22 August 2012 06:19
By: Michel Cadot
icon5.gif Frequent changed table stats problem
Oracle 10.2.0.4, AIX 5.3 64bit
By: snowball on Mon, 06 August 2012
10 1145 Wed, 22 August 2012 01:14
By: LNossov
  SQL Statement taking too long (merged 3)
Oracle 11.2.0, AIX 6.1 (64bit)
By: Creems on Tue, 21 August 2012
5 689 Tue, 21 August 2012 16:52
By: Creems
  Slow query with full table scan
ORACLE 11
By: brown_zzz on Sat, 18 August 2012
16 2471 Tue, 21 August 2012 09:36
By: Kevin Meade
  Performance Issue while truncating table partition. (3 Merged)
Oracle 11g , Linux
By: palanisvr on Tue, 24 July 2012
2 1263 Tue, 21 August 2012 06:30
By: Kevin Meade
  dbms_xplan.display_cursor
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 20 August 2012
4 1322 Mon, 20 August 2012 13:50
By: John Watson
  Same query with different Explain Plan in two Database
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
By: prashanth7582 on Fri, 17 August 2012
4 1528 Fri, 17 August 2012 08:18
By: prashanth7582
  Re: Get Unique row number for list of values (split from unrelated thread by bb)
By: prashanth7582 on Fri, 17 August 2012
0 628 Fri, 17 August 2012 06:23
By: prashanth7582
  query recommedation
Oracle 10.2.0.4 solaris 2.10
By: BeefStu on Thu, 16 August 2012
2 467 Fri, 17 August 2012 01:36
By: Michel Cadot
  how to find all indexes scripts in particular schema
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
By: msol25 on Thu, 16 August 2012
4 1469 Fri, 17 August 2012 01:34
By: Michel Cadot
  Buffer_gets/Buffer_cache
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 13 August 2012
22 1192 Thu, 16 August 2012 06:34
By: cookiemonster
  Need help with Queries ( 1 2 3)
By: supiash on Sat, 19 May 2012
105 2370 Tue, 14 August 2012 15:20
By: Barbara Boehmer
  Query tuning help
11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: knw15pwr on Fri, 10 August 2012
7 1127 Mon, 13 August 2012 18:12
By: alan.kendall@nfl.com
  Analyzed table
Oracle 8i
By: shyamu on Thu, 09 August 2012
2 538 Sat, 11 August 2012 10:38
By: BlackSwan
  How to determine slowness in I/O from AWR?
Oracle 11.2.0.3.0
By: orapratap on Thu, 09 August 2012
5 2994 Thu, 09 August 2012 13:24
By: alan.kendall@nfl.com
  Table actual size
oracle 10g
By: savugar on Thu, 09 August 2012
6 711 Thu, 09 August 2012 10:30
By: Michel Cadot
  get AWR report data
Oracle,10.2.0.4
By: savugar on Wed, 08 August 2012
6 1025 Thu, 09 August 2012 02:45
By: savugar
  Increased LOGFILE did not increase performance
Toad 9.5, Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production, Windows Server 2003 R2
By: RedFux on Mon, 06 August 2012
12 3595 Wed, 08 August 2012 15:46
By: alan.kendall@nfl.com
  Cannot find TraceFile for SESSION
Oracle Database 11g Release 11.1.0.7.0 - 64bit Production Windows
By: Andrey_R on Mon, 06 August 2012
0 896 Mon, 06 August 2012 03:17
By: Andrey_R
  Performance difference of same query in 2 database
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi, Solaris
By: sasnrock on Tue, 24 July 2012
4 988 Sat, 04 August 2012 13:44
By: Kevin Meade
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 Nov 28 04:04:11 CST 2014

Total time taken to generate the page: 0.12690 seconds