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 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 11482 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 3242 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 3185 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 6635 Fri, 13 July 2012 19:44
By: alan.kendall@nfl.com
  Big database migration
By: majstoru on Wed, 04 July 2012
4 3564 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 5877 Thu, 12 July 2012 13:01
By: BeefStu
  DBA performance tools
Oracle 10g
By: ram anand on Wed, 11 July 2012
4 2464 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 7859 Wed, 11 July 2012 10:11
By: avaquestions
  Elapsed time
11.2.0.2 , Linux
By: gkrishn on Sat, 07 July 2012
16 9442 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 8295 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 18860 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 5394 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 8045 Sat, 07 July 2012 01:43
By: John Watson
  DB_BLOCK_SIZE
ORACLE 11GR2 SOLARIS
By: guddu_12 on Thu, 05 July 2012
14 11341 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 2410 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 5580 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 3137 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 2872 Wed, 04 July 2012 01:52
By: Michel Cadot
  partition pruning
oracle 10.2
By: guddu_12 on Tue, 03 July 2012
2 3518 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 21118 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 3204 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 3387 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 2819 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 4624 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 5071 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 10206 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 7433 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 4212 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 2558 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 2588 Tue, 26 June 2012 07:04
By: Michel Cadot
  SGA related queries
By: charuamit on Mon, 25 June 2012
1 2780 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 5363 Fri, 22 June 2012 20:15
By: BlackSwan
  SQL Tuning Help
oracle 11g
By: thalladas on Thu, 21 June 2012
11 21530 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 3032 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 3756 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 5974 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 3348 Wed, 20 June 2012 02:16
By: Andrey_R
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 3612 Tue, 19 June 2012 17:08
By: BlackSwan
  Creation of Index
By: suryamz on Thu, 30 March 2006
4 3963 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 2633 Tue, 19 June 2012 02:01
By: Rektanocrit
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 May 22 10:01:48 CDT 2024