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

    Replies Views Last message
  How to determine slowness in I/O from AWR?
Oracle 11.2.0.3.0
By: orapratap on Thu, 09 August 2012
5 2580 Thu, 09 August 2012 13:24
By: alan.kendall@nfl.com
  Table actual size
oracle 10g
By: savugar on Thu, 09 August 2012
6 665 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 947 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 3214 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 858 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 939 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 724 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 731 Thu, 02 August 2012 06:25
By: cookiemonster
  connect database
By: sirumon on Mon, 19 December 2011
13 771 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 2857 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 960 Mon, 23 July 2012 17:31
By: alan.kendall@nfl.com
  Undo advice.
11.0.2.3 Sol 10 64bit
By: Roachcoach on Fri, 06 July 2012
12 1119 Mon, 23 July 2012 16:41
By: alan.kendall@nfl.com
  SQL optimisation
By: rachcha on Mon, 23 July 2012
1 684 Mon, 23 July 2012 11:48
By: Michel Cadot
icon5.gif Sentence tuning
Oracle9i
By: estonolose on Wed, 04 July 2012
7 1088 Wed, 18 July 2012 15:05
By: alan.kendall@nfl.com
  DB FILE SEQUENTIAL READ IN Full table scan
Oracle,11.1.0.7.0,Aix
By: vattigunta on Tue, 17 July 2012
9 2453 Wed, 18 July 2012 14:05
By: LNossov
  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 2614 Wed, 18 July 2012 13:43
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 829 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 615 Mon, 16 July 2012 08:31
By: Michel Cadot
icon5.gif Response very slow
oracle database 10g
By: hielh on Thu, 31 May 2012
8 1416 Fri, 13 July 2012 19:44
By: alan.kendall@nfl.com
  Big database migration
By: majstoru on Wed, 04 July 2012
4 665 Fri, 13 July 2012 15:45
By: majstoru
  The percentage of time spent by sessions waiting on redo operations
By: BeefStu on Thu, 12 July 2012
11 709 Thu, 12 July 2012 13:01
By: BeefStu
  DBA performance tools
Oracle 10g
By: ram anand on Wed, 11 July 2012
4 564 Thu, 12 July 2012 00:57
By: Michel Cadot
  Oracle 10g showing problem with index (2 Merged)
10g
By: avaquestions on Mon, 02 July 2012
22 1631 Wed, 11 July 2012 10:11
By: avaquestions
  Elapsed time
11.2.0.2 , Linux
By: gkrishn on Sat, 07 July 2012
16 1853 Wed, 11 July 2012 09:50
By: LNossov
  DB time in AWR Report - (CPU time,I/O and waits)?
Oracle 10.2.0.4
By: orapratap on Mon, 09 July 2012
3 3723 Tue, 10 July 2012 01:04
By: Michel Cadot
  Force Index Unique Scan
Oracle 10g 10.2.0.4 HP-UX
By: manubatham20 on Thu, 14 June 2012
19 3332 Sun, 08 July 2012 20:32
By: rleishman
  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 1154 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 1952 Sat, 07 July 2012 01:43
By: John Watson
  DB_BLOCK_SIZE
ORACLE 11GR2 SOLARIS
By: guddu_12 on Thu, 05 July 2012
14 3602 Fri, 06 July 2012 03:06
By: Michel Cadot
  Query running slow
11.2.0.2.5 , Solaris 10
By: getzeeshan on Thu, 05 July 2012
1 391 Thu, 05 July 2012 17:08
By: BlackSwan
  How to find out who is the locking SQL statement?
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
By: Andrey_R on Wed, 04 July 2012
13 1261 Wed, 04 July 2012 13:16
By: Andrey_R
  Investigating sudden Temp Tablespace growth from AWR?
Oracle 10.2.0.4
By: orapratap on Wed, 04 July 2012
0 1113 Wed, 04 July 2012 05:24
By: orapratap
  use_hash hint without arguments
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Tue, 03 July 2012
3 886 Wed, 04 July 2012 01:52
By: Michel Cadot
  partition pruning
oracle 10.2
By: guddu_12 on Tue, 03 July 2012
2 551 Tue, 03 July 2012 06:44
By: guddu_12
  Slow db performance on Oracle 11.2.0.3
Oracle 11.2.0..3, Linux
By: u570744 on Sat, 30 June 2012
6 7735 Mon, 02 July 2012 11:28
By: LNossov
  SGA related queries
Oracle 10.1.0.2.0
By: charuamit on Sat, 30 June 2012
4 721 Sat, 30 June 2012 01:50
By: charuamit
  tools for monitoring the load of the db
oracle 10g
By: crocuta on Fri, 03 December 2010
4 840 Fri, 29 June 2012 21:24
By: alan.kendall@nfl.com
  Performance issue
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ,Windows XP
By: a_oracle on Thu, 14 June 2012
6 525 Fri, 29 June 2012 02:22
By: John Watson
  how to reduce dml locks?
oracle 11.2.0.1.0,windows server 2008 R2
By: vijenderkdba on Thu, 24 May 2012
6 1222 Thu, 28 June 2012 23:22
By: Michel Cadot
  Tuning Queries
Oracle 10.1.0.2
By: arif_md2009 on Wed, 16 May 2012
13 933 Thu, 28 June 2012 15:44
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: Wed Aug 20 13:33:07 CDT 2014

Total time taken to generate the page: 0.26999 seconds