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

    Replies Views Last message
  Proper index is not used ...
Oracle, 11.2.0.2, Linux 5.5
By: ardhendu on Wed, 17 October 2012
4 713 Fri, 19 October 2012 05:07
By: ardhendu
  incremental stats not happening
ORACLE 11GR2 SOLARIS
By: guddu_12 on Mon, 15 October 2012
3 708 Thu, 18 October 2012 12:28
By: Littlefoot
  NOLOGGING in Oracle 11gr2
Oracle 11gr2 Server 2008r2
By: segan1415 on Tue, 16 October 2012
26 7463 Thu, 18 October 2012 09:18
By: segan1415
  Improve performance postgre
By: perfectioi on Wed, 10 October 2012
4 664 Wed, 10 October 2012 11:39
By: BlackSwan
icon5.gif SSL on database connections
Oracle EE ver 11, linux
By: ndg123 on Wed, 10 October 2012
4 594 Wed, 10 October 2012 05:36
By: ndg123
  cluter in index
oracle 11gr2
By: guddu_12 on Thu, 04 October 2012
4 591 Fri, 05 October 2012 17:19
By: rleishman
  Is this a bug on Oracle11gr2?
11gr2
By: alantany on Tue, 25 September 2012
5 1003 Thu, 04 October 2012 15:20
By: Flyby
  Help required for tuning referring AWR Reports
Oracle 10.2.0.4.0 on linux
By: orapratap on Thu, 30 August 2012
5 2366 Thu, 04 October 2012 02:17
By: Roachcoach
  how to tune 100s of transactions over single table
By: kamilp on Mon, 24 September 2012
10 809 Tue, 02 October 2012 17:24
By: alan.kendall@nfl.com
  What does analyzing a table do for the indexes ?
Oracle 11g Win 7
By: jxh461 on Wed, 26 September 2012
2 1659 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 1014 Mon, 24 September 2012 19:39
By: reym21
  Analytics and Predicate Pushing
9i/10g/11g
By: Kevin Meade on Thu, 20 September 2012
18 1882 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 2413 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 2219 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 1524 Tue, 18 September 2012 14:04
By: Littlefoot
  FOR Loop and Driving Site
Oracle 11g
By: wmgonzalbo on Tue, 18 September 2012
1 767 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 5620 Mon, 17 September 2012 13:09
By: Michel Cadot
  Improve procedure's performance
By: suryay22 on Fri, 14 September 2012
7 876 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 1156 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 734 Wed, 12 September 2012 23:50
By: Michel Cadot
  tuning stats command
ORACLE 11GR2 SOLARIS
By: guddu_12 on Tue, 11 September 2012
1 429 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 674 Sat, 08 September 2012 16:36
By: arif_md2009
  Explain plan of a query
Oracle 11g
By: sathik on Wed, 05 September 2012
16 1551 Fri, 07 September 2012 07:52
By: BlackSwan
  Slow running query (3 Merged)
Oracle 11g
By: brown_zzz on Wed, 05 September 2012
4 740 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 934 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 8001 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 1140 Tue, 28 August 2012 06:35
By: cookiemonster
  index behaviour
11.2.0.3.0
By: piotrtal on Sat, 25 August 2012
6 979 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 3233 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 19801 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 1068 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 638 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 2267 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 1171 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 1212 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 1388 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 592 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 426 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 1289 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 1089 Thu, 16 August 2012 06:34
By: cookiemonster
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 Aug 30 22:02:26 CDT 2014

Total time taken to generate the page: 0.13030 seconds