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

    Replies Views Last message
  DB FILE SEQUENTIAL READ IN Full table scan
Oracle,11.1.0.7.0,Aix
By: vattigunta on Tue, 17 July 2012
9 7631 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 7961 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 2091 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 1821 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 5141 Fri, 13 July 2012 19:44
By: alan.kendall@nfl.com
  Big database migration
By: majstoru on Wed, 04 July 2012
4 1983 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 3905 Thu, 12 July 2012 13:01
By: BeefStu
  DBA performance tools
Oracle 10g
By: ram anand on Wed, 11 July 2012
4 1221 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 5870 Wed, 11 July 2012 10:11
By: avaquestions
  Elapsed time
11.2.0.2 , Linux
By: gkrishn on Sat, 07 July 2012
16 6908 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 6803 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 12847 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 3584 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 6116 Sat, 07 July 2012 01:43
By: John Watson
  DB_BLOCK_SIZE
ORACLE 11GR2 SOLARIS
By: guddu_12 on Thu, 05 July 2012
14 9417 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 1157 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 3604 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 1992 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 1639 Wed, 04 July 2012 01:52
By: Michel Cadot
  partition pruning
oracle 10.2
By: guddu_12 on Tue, 03 July 2012
2 1974 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 18108 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 1912 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 2189 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 1547 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 3367 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 3159 Thu, 28 June 2012 15:44
By: alan.kendall@nfl.com
  redo size
Oracle version 11.2.0.2.0, OS AIX basedSystems(64 bit)
By: ashishrnv on Mon, 18 June 2012
18 8141 Thu, 28 June 2012 14:29
By: BlackSwan
  Value for sga_target
Oracle 10.2.0.4.0 on AIX 5.3
By: raj9999 on Fri, 15 June 2012
8 5310 Wed, 27 June 2012 23:15
By: Michel Cadot
  a table deleted or updated frequency issue
By: andy huang on Thu, 14 June 2012
8 2439 Wed, 27 June 2012 19:09
By: alan.kendall@nfl.com
  Outer join causes much slower performance
By: projecttoday on Tue, 26 June 2012
3 1317 Wed, 27 June 2012 10:00
By: BlackSwan
  performance improvement of clob data
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Tue, 26 June 2012
1 1440 Tue, 26 June 2012 07:04
By: Michel Cadot
  SGA related queries
By: charuamit on Mon, 25 June 2012
1 1509 Mon, 25 June 2012 05:12
By: Michel Cadot
  what's the relationship between the number of blocks and consistent gets ?
By: lonion on Wed, 20 June 2012
4 3450 Fri, 22 June 2012 20:15
By: BlackSwan
  SQL Tuning Help
oracle 11g
By: thalladas on Thu, 21 June 2012
11 18337 Fri, 22 June 2012 08:52
By: thalladas
  Reg Awrrpt report in oracle database
oracle 10.2.0.2.0
By: nilesh_pawaskar on Thu, 21 June 2012
1 1617 Thu, 21 June 2012 07:04
By: Michel Cadot
  How to determine the system memory usage by oracle processes
Solaris 10
By: getzeeshan on Wed, 20 June 2012
6 1982 Wed, 20 June 2012 15:26
By: getzeeshan
  Oracle (HP-UX) connection very slow from Windows client
Oracle 9.2.0.7 installed on HP-UX
By: C4poster on Mon, 18 June 2012
13 4214 Wed, 20 June 2012 11:19
By: bobbydurrettdba
  How can i trace a different from current session with LEVEL 4?
Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX
By: Andrey_R on Wed, 13 June 2012
8 1915 Wed, 20 June 2012 02:16
By: Andrey_R
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 2073 Tue, 19 June 2012 17:08
By: BlackSwan
  Creation of Index
By: suryamz on Thu, 30 March 2006
4 2324 Tue, 19 June 2012 11:27
By: Jack14
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: Thu Apr 02 18:59:52 CDT 2020