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

    Replies Views Last message
  Explain plan of a query
Oracle 11g
By: sathik on Wed, 05 September 2012
16 2780 Fri, 07 September 2012 07:52
By: BlackSwan
  Help required for tuning referring AWR Reports
Oracle 10.2.0.4.0 on linux
By: orapratap on Thu, 30 August 2012
5 3942 Thu, 04 October 2012 02:17
By: Roachcoach
  index behaviour
11.2.0.3.0
By: piotrtal on Sat, 25 August 2012
6 1652 Sun, 26 August 2012 09:30
By: BlackSwan
  SQL Tuning Assistance Required
Oracle 10.2.0.3, PeopleSoft 8.8, PeopleTools 8.49
By: SBhaumik_DBA on Tue, 28 August 2012
6 2449 Tue, 28 August 2012 06:35
By: cookiemonster
  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 8526 Fri, 24 August 2012 14:11
By: alan.kendall@nfl.com
  SQL Statement taking too long (merged 3)
Oracle 11.2.0, AIX 6.1 (64bit)
By: Creems on Tue, 21 August 2012
5 1179 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 4546 Tue, 21 August 2012 09:36
By: Kevin Meade
  Re: Get Unique row number for list of values (split from unrelated thread by bb)
By: prashanth7582 on Fri, 17 August 2012
0 1052 Fri, 17 August 2012 06:23
By: prashanth7582
  dbms_xplan.display_cursor
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 20 August 2012
4 2106 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 2695 Fri, 17 August 2012 08:18
By: prashanth7582
  query recommedation
Oracle 10.2.0.4 solaris 2.10
By: BeefStu on Thu, 16 August 2012
2 816 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 2907 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 2217 Thu, 16 August 2012 06:34
By: cookiemonster
  Table actual size
oracle 10g
By: savugar on Thu, 09 August 2012
6 1316 Thu, 09 August 2012 10:30
By: Michel Cadot
  Analyzed table
Oracle 8i
By: shyamu on Thu, 09 August 2012
2 845 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 6790 Thu, 09 August 2012 13:24
By: alan.kendall@nfl.com
  get AWR report data
Oracle,10.2.0.4
By: savugar on Wed, 08 August 2012
6 1616 Thu, 09 August 2012 02:45
By: savugar
  How to Control concurrent Inserts of a record by parallel sessions
Oracle 10.2.0.4
By: orapratap on Tue, 07 August 2012
4 1409 Fri, 31 August 2012 21:38
By: Kevin Meade
icon5.gif Frequent changed table stats problem
Oracle 10.2.0.4, AIX 5.3 64bit
By: snowball on Mon, 06 August 2012
10 2032 Wed, 22 August 2012 01:14
By: LNossov
  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 6618 Wed, 08 August 2012 15:46
By: alan.kendall@nfl.com
  Query tuning help
11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
By: knw15pwr on Fri, 10 August 2012
7 1950 Mon, 13 August 2012 18:12
By: alan.kendall@nfl.com
  Not exists inside exists is having very low performence
By: narsimha6 on Thu, 02 August 2012
2 1178 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 1380 Thu, 02 August 2012 06:25
By: cookiemonster
  Oracle 11g high memory usage dbw0 and dbw1
Oracle 11.2.0.3 Redhat Linux
By: preet_kumar on Tue, 31 July 2012
4 5701 Tue, 31 July 2012 07:20
By: John Watson
  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 1152 Mon, 06 August 2012 03:17
By: Andrey_R
  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 11518 Thu, 30 August 2012 15:25
By: wakula
  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 1340 Sat, 04 August 2012 13:44
By: Kevin Meade
  Performance Issue while truncating table partition. (3 Merged)
Oracle 11g , Linux
By: palanisvr on Tue, 24 July 2012
2 2089 Tue, 21 August 2012 06:30
By: Kevin Meade
  SQL optimisation
By: rachcha on Mon, 23 July 2012
1 1457 Mon, 23 July 2012 11:48
By: Michel Cadot
  understanding a SQL plan
Oracle 11.2.0.2 Solaris 2.10
By: BeefStu on Wed, 18 July 2012
5 1533 Mon, 23 July 2012 17:31
By: alan.kendall@nfl.com
  Oracle process exceed SGA_MAX_TARGET
Oracle database 11g R2,Windows 2008 server
By: Sami_Younis on Tue, 17 July 2012
2 1529 Tue, 17 July 2012 21:21
By: alan.kendall@nfl.com
  How to Tune my SQL (5 merged)
10.2.0.3.0
By: grpatwari on Mon, 16 July 2012
4 1231 Mon, 16 July 2012 08:31
By: Michel Cadot
  The percentage of time spent by sessions waiting on redo operations
By: BeefStu on Thu, 12 July 2012
11 1687 Thu, 12 July 2012 13:01
By: BeefStu
  DBA performance tools
Oracle 10g
By: ram anand on Wed, 11 July 2012
4 902 Thu, 12 July 2012 00:57
By: Michel Cadot
  how can i know host name using sql id or sid
oracle 10g rac 10.2.0.4, windows server 2008 64 bit
By: x-oracle on Wed, 11 July 2012
19 5269 Wed, 18 July 2012 13:43
By: alan.kendall@nfl.com
  DB time in AWR Report - (CPU time,I/O and waits)?
Oracle 10.2.0.4
By: orapratap on Mon, 09 July 2012
3 5586 Tue, 10 July 2012 01:04
By: Michel Cadot
  DB FILE SEQUENTIAL READ IN Full table scan
Oracle,11.1.0.7.0,Aix
By: vattigunta on Tue, 17 July 2012
9 4839 Wed, 18 July 2012 14:05
By: LNossov
  Elapsed time
11.2.0.2 , Linux
By: gkrishn on Sat, 07 July 2012
16 3846 Wed, 11 July 2012 09:50
By: LNossov
  where fiter result rows save before join and grop by operation?
oracle 10g 10.2.0.1
By: zengmuansha on Sat, 07 July 2012
11 2091 Sun, 08 July 2012 04:53
By: John Watson
icon9.gif DB file sequential read (9 merged)
oracle 10g
By: bhagyaraj.p on Fri, 06 July 2012
5 4188 Sat, 07 July 2012 01:43
By: John Watson
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 Oct 20 11:24:39 CDT 2017

Total time taken to generate the page: 0.19926 seconds