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

    Replies Views Last message
  The percentage of time spent by sessions waiting on redo operations
By: BeefStu on Thu, 12 July 2012
11 885 Thu, 12 July 2012 13:01
By: BeefStu
  DBA performance tools
Oracle 10g
By: ram anand on Wed, 11 July 2012
4 638 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 1843 Wed, 11 July 2012 10:11
By: avaquestions
  Elapsed time
11.2.0.2 , Linux
By: gkrishn on Sat, 07 July 2012
16 2168 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 4058 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 3885 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 1304 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 2313 Sat, 07 July 2012 01:43
By: John Watson
  DB_BLOCK_SIZE
ORACLE 11GR2 SOLARIS
By: guddu_12 on Thu, 05 July 2012
14 4155 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 436 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 1446 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 1266 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 970 Wed, 04 July 2012 01:52
By: Michel Cadot
  partition pruning
oracle 10.2
By: guddu_12 on Tue, 03 July 2012
2 627 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 8469 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 856 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 925 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 607 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 1422 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 1027 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 3300 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 2078 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 726 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 717 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 757 Tue, 26 June 2012 07:04
By: Michel Cadot
  SGA related queries
By: charuamit on Mon, 25 June 2012
1 757 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 943 Fri, 22 June 2012 20:15
By: BlackSwan
  SQL Tuning Help
oracle 11g
By: thalladas on Thu, 21 June 2012
11 2930 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 737 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 830 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 1715 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 803 Wed, 20 June 2012 02:16
By: Andrey_R
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 1019 Tue, 19 June 2012 17:08
By: BlackSwan
  Creation of Index
By: suryamz on Thu, 30 March 2006
4 1107 Tue, 19 June 2012 11:27
By: Jack14
  PL/SQL Block (LOOP) Comparison
Oracle 10gR2 10.2.0.5, AIX 6.1
By: Rektanocrit on Tue, 19 June 2012
4 600 Tue, 19 June 2012 02:01
By: Rektanocrit
  combination index issue
10.2.0.1
By: andy huang on Sat, 16 June 2012
4 896 Mon, 18 June 2012 22:36
By: andy huang
  Passing record to a variable - Performance Issue
Oracle 10gR2 10.2.0.5 Server:AIX Client:Windows
By: Rektanocrit on Fri, 15 June 2012
3 514 Fri, 15 June 2012 03:34
By: Michel Cadot
  how to find the SQL statement which have many hard parse
By: lonion on Thu, 31 May 2012
11 1323 Thu, 14 June 2012 12:41
By: LNossov
  query for optimisation
oracle 10g
By: raja859 on Thu, 14 June 2012
4 523 Thu, 14 June 2012 10:11
By: flyboy
  Performace issue in transaction system
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Wed, 06 June 2012
6 683 Tue, 12 June 2012 13:40
By: LNossov
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 Jan 31 05:53:20 CST 2015

Total time taken to generate the page: 0.11783 seconds