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

    Replies Views Last message
  HIBERNATE query runs slow but ok in SQLPLUS
Oracle 11g
By: brown_zzz on Fri, 14 September 2012
7 3215 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 2307 Tue, 18 September 2012 14:04
By: Littlefoot
  FOR Loop and Driving Site
Oracle 11g
By: wmgonzalbo on Tue, 18 September 2012
1 1080 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 6972 Mon, 17 September 2012 13:09
By: Michel Cadot
  Improve procedure's performance
By: suryay22 on Fri, 14 September 2012
7 1342 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 1609 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 1147 Wed, 12 September 2012 23:50
By: Michel Cadot
  tuning stats command
ORACLE 11GR2 SOLARIS
By: guddu_12 on Tue, 11 September 2012
1 666 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 973 Sat, 08 September 2012 16:36
By: arif_md2009
  Explain plan of a query
Oracle 11g
By: sathik on Wed, 05 September 2012
16 2161 Fri, 07 September 2012 07:52
By: BlackSwan
  Slow running query (3 Merged)
Oracle 11g
By: brown_zzz on Wed, 05 September 2012
4 1143 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 1262 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 10196 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 1991 Tue, 28 August 2012 06:35
By: cookiemonster
  index behaviour
11.2.0.3.0
By: piotrtal on Sat, 25 August 2012
6 1355 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 6139 Fri, 24 August 2012 14:11
By: alan.kendall@nfl.com
icon5.gif Frequent changed table stats problem
Oracle 10.2.0.4, AIX 5.3 64bit
By: snowball on Mon, 06 August 2012
10 1626 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 993 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 3712 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 1780 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 1871 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 2238 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 907 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 728 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 2456 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 1766 Thu, 16 August 2012 06:34
By: cookiemonster
  Need help with Queries ( 1 2 3)
By: supiash on Sat, 19 May 2012
105 2916 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 1658 Mon, 13 August 2012 18:12
By: alan.kendall@nfl.com
  Analyzed table
Oracle 8i
By: shyamu on Thu, 09 August 2012
2 740 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 5185 Thu, 09 August 2012 13:24
By: alan.kendall@nfl.com
  Table actual size
oracle 10g
By: savugar on Thu, 09 August 2012
6 1041 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 1350 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 5249 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 1098 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 1245 Sat, 04 August 2012 13:44
By: Kevin Meade
  Not exists inside exists is having very low performence
By: narsimha6 on Thu, 02 August 2012
2 1046 Fri, 03 August 2012 06:26
By: cookiemonster
  where the second fetch data ?
oracle 10g 10.2.03
By: zengmuansha on Wed, 01 August 2012
3 1186 Thu, 02 August 2012 06:25
By: cookiemonster
  connect database
By: sirumon on Mon, 19 December 2011
13 1100 Wed, 01 August 2012 06:13
By: Michel Cadot
  Oracle 11g high memory usage dbw0 and dbw1
Oracle 11.2.0.3 Redhat Linux
By: preet_kumar on Tue, 31 July 2012
4 4632 Tue, 31 July 2012 07:20
By: John Watson
  understanding a SQL plan
Oracle 11.2.0.2 Solaris 2.10
By: BeefStu on Wed, 18 July 2012
5 1352 Mon, 23 July 2012 17:31
By: alan.kendall@nfl.com
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 May 29 10:47:53 CDT 2016

Total time taken to generate the page: 0.10669 seconds