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

    Replies Views Last message
  Create Index vs Rebuild Index
Oracle 9iR2 on RHEL
By: OraKaran on Thu, 27 January 2011
2 2739 Thu, 27 January 2011 07:52
By: OraKaran
  Optimizer question/ Date handling
Oracle 9.2.0.8.0
By: Roachcoach on Mon, 17 January 2011
9 3582 Wed, 26 January 2011 02:57
By: Roachcoach
  Locker and waiter problem
oraccle 10g RAC environment
By: swadeshi on Tue, 25 January 2011
1 1651 Tue, 25 January 2011 07:39
By: Michel Cadot
  db sequential read (merged)
oracle 10g R2
By: sahadba on Tue, 25 January 2011
1 4341 Tue, 25 January 2011 05:11
By: Michel Cadot
  Query regarding tkprof output and cardinality in it
Oracle 10g R2 on REHL
By: OraKaran on Mon, 24 January 2011
4 4556 Mon, 24 January 2011 08:07
By: OraKaran
  Database Links
Oracle, 10g, Windows Server 2003
By: faizul on Thu, 20 January 2011
12 9429 Thu, 20 January 2011 14:48
By: John Watson
  AWR report in 11g standard not supported?
11.2.0.1
By: sean1970 on Sat, 15 January 2011
6 4159 Wed, 19 January 2011 00:31
By: sean1970
  Avoid chain rows
oracle, 9.2.0.4.0, SunSolaris
By: sathik on Mon, 17 January 2011
5 2488 Mon, 17 January 2011 10:40
By: Michel Cadot
  MEMORY_TARGET and MEMORY_MAX_TARGET
11.2.0.1
By: sean1970 on Sat, 15 January 2011
3 3937 Sat, 15 January 2011 11:15
By: sean1970
  Confusion over Keep Cache (2 Merged)
Oracle 11g, HP-UX B11.23
By: indrajit2002 on Sat, 15 January 2011
2 1813 Sat, 15 January 2011 10:56
By: Michel Cadot
  Retreiving from the Data is slow
Oracle 11g, Linux
By: tariqdba on Wed, 12 January 2011
6 2017 Sat, 15 January 2011 03:13
By: tariqdba
  Query Perfomance
Oracle 10g, Windows XP
By: a_oracle on Wed, 12 January 2011
18 9013 Fri, 14 January 2011 07:33
By: cookiemonster
  AWR report
Oracle 10.2.0.3 + 2 node RAC + HP-UX Itanium 11.31
By: seema.taunk on Mon, 10 January 2011
3 2990 Fri, 14 January 2011 06:29
By: seema.taunk
  Elapsed time not accounted in tkprof file
Oracle 9.2 on HP-UX
By: OraKaran on Thu, 13 January 2011
11 3250 Thu, 13 January 2011 11:17
By: cookiemonster
  How to partition tables and indexes in this scenario?
Oracle 11g R2
By: steffi on Wed, 12 January 2011
3 2293 Thu, 13 January 2011 08:16
By: steffi
  Performance problem, Many "ora_p" processes (merged)
or
By: sahadba on Thu, 13 January 2011
2 14345 Thu, 13 January 2011 07:48
By: sahadba
  SGA
11g Linux
By: gkrishn on Sat, 08 January 2011
12 4841 Thu, 13 January 2011 04:33
By: gkrishn
  Initialization parameters value
Oracle 10g, 10.2.0.4.0, Solaris 10
By: reym21 on Wed, 12 January 2011
8 3285 Thu, 13 January 2011 01:33
By: John Watson
  Session tracing for shared servers
By: sekar52 on Wed, 12 January 2011
1 1556 Wed, 12 January 2011 00:59
By: Michel Cadot
  Query Taking too much time
Oracle 9.2 on HP-UX
By: OraKaran on Tue, 11 January 2011
4 2224 Tue, 11 January 2011 09:41
By: cookiemonster
  Index rebuild online
By: varunvir on Mon, 10 January 2011
3 3117 Mon, 10 January 2011 15:53
By: varunvir
  Query taking time
Oracle 11g HP-UX B11.23
By: indrajit2002 on Mon, 10 January 2011
7 3736 Mon, 10 January 2011 09:48
By: BlackSwan
  performance issue
Oracle 10.2.0.4 windows 64 bit
By: dba_7722 on Sun, 09 January 2011
1 2623 Sun, 09 January 2011 06:38
By: Mahesh Rajendran
  Help with problem query
Oracle 9.2.0.8 (HP-UX B11.23)
By: indrajit2002 on Wed, 05 January 2011
7 2645 Sat, 08 January 2011 10:01
By: indrajit2002
  Disk Performance Issues
By: unex on Fri, 07 January 2011
3 1643 Fri, 07 January 2011 08:15
By: Michel Cadot
  ADDM Retention
Oracle 10g
By: vnkumaresh on Thu, 06 January 2011
2 9531 Thu, 06 January 2011 06:28
By: vnkumaresh
  Procedure runs long time (merged)
Oracle Enterprise Edition 10.2.0.4, Solaris 10
By: jesuisantony on Wed, 05 January 2011
4 2741 Wed, 05 January 2011 11:47
By: cookiemonster
  Procedure taking tomuch time in execution
Oracle 10g
By: arpitpasari on Sun, 02 January 2011
9 2735 Tue, 04 January 2011 04:25
By: michael_bialik
  Oracle Coalesce vs Index Rebuild
10g(10.2.0.4)
By: paradoxkhan on Thu, 30 December 2010
10 10431 Mon, 03 January 2011 23:37
By: ramoradba
  Parse once - Execute many
Oracle 9,10, cross platform
By: trantuananh24hg on Sun, 26 December 2010
4 3578 Mon, 03 January 2011 22:04
By: trantuananh24hg
  Less Cost,Cardinality,Bytes Query is taking More time to execute
By: gururajster on Mon, 03 January 2011
1 3286 Mon, 03 January 2011 08:20
By: Mahesh Rajendran
  ADDM report
10g Linux
By: gkrishn on Wed, 22 December 2010
4 4961 Tue, 28 December 2010 07:27
By: mani.aggarwal
  How to overcome rownum clause from select
Oracle 11g ,windows 2003
By: pradies on Mon, 27 December 2010
3 2908 Mon, 27 December 2010 01:33
By: Michel Cadot
icon5.gif Clustering Factor in Index
Oracle 11g
By: vnkumaresh on Wed, 15 December 2010
3 6117 Sat, 25 December 2010 01:15
By: Michel Cadot
  stored outline
9.2.0.1
By: oragaurav on Thu, 23 December 2010
6 2134 Fri, 24 December 2010 02:04
By: John Watson
  Optimizing select from view
By: Dimidrol on Thu, 23 December 2010
7 2583 Thu, 23 December 2010 11:28
By: cookiemonster
  Performance hit of the application after moving the DB server
oracle 9i, 10g, forms 10g/9i, AS9i
By: rajesh4851 on Thu, 23 December 2010
1 1369 Thu, 23 December 2010 03:47
By: Michel Cadot
  archive log
oracle 10g
By: prashant_ora on Sun, 19 December 2010
8 4981 Wed, 22 December 2010 10:47
By: Roachcoach
  Temp tablespace full
ORACLE,9.2.0.5.0,AIX
By: lokeshracdba on Wed, 22 December 2010
1 2022 Wed, 22 December 2010 01:10
By: Michel Cadot
  delete procedure taking time
oracle,9i,unix
By: vickey_sagar1 on Tue, 21 December 2010
7 2331 Wed, 22 December 2010 00:01
By: rleishman
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 May 24 20:13:34 CDT 2024