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 1136 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 770 Wed, 26 January 2011 02:57
By: Roachcoach
  Locker and waiter problem
oraccle 10g RAC environment
By: swadeshi on Tue, 25 January 2011
1 526 Tue, 25 January 2011 07:39
By: Michel Cadot
  db sequential read (merged)
oracle 10g R2
By: sahadba on Tue, 25 January 2011
1 1692 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 1066 Mon, 24 January 2011 08:07
By: OraKaran
  Database Links
Oracle, 10g, Windows Server 2003
By: faizul on Thu, 20 January 2011
12 4208 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 1712 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 1036 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 2478 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 622 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 616 Sat, 15 January 2011 03:13
By: tariqdba
  Query Perfomance
Oracle 10g, Windows XP
By: a_oracle on Wed, 12 January 2011
18 6256 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 1613 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 1170 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 687 Thu, 13 January 2011 08:16
By: steffi
  Performance problem, Many "ora_p" processes (merged)
or
By: sahadba on Thu, 13 January 2011
2 4445 Thu, 13 January 2011 07:48
By: sahadba
  SGA
11g Linux
By: gkrishn on Sat, 08 January 2011
12 2296 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 1475 Thu, 13 January 2011 01:33
By: John Watson
  Session tracing for shared servers
By: sekar52 on Wed, 12 January 2011
1 502 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 676 Tue, 11 January 2011 09:41
By: cookiemonster
  Index rebuild online
By: varunvir on Mon, 10 January 2011
3 1299 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 993 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 621 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 686 Sat, 08 January 2011 10:01
By: indrajit2002
  Disk Performance Issues
By: unex on Fri, 07 January 2011
3 534 Fri, 07 January 2011 08:15
By: Michel Cadot
  ADDM Retention
Oracle 10g
By: vnkumaresh on Thu, 06 January 2011
2 2023 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 684 Wed, 05 January 2011 11:47
By: cookiemonster
  Procedure taking tomuch time in execution
Oracle 10g
By: arpitpasari on Sun, 02 January 2011
9 786 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 3938 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 905 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 1842 Mon, 03 January 2011 08:20
By: Mahesh Rajendran
  ADDM report
10g Linux
By: gkrishn on Wed, 22 December 2010
4 3617 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 1611 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 3477 Sat, 25 December 2010 01:15
By: Michel Cadot
  stored outline
9.2.0.1
By: oragaurav on Thu, 23 December 2010
6 533 Fri, 24 December 2010 02:04
By: John Watson
  Optimizing select from view
By: Dimidrol on Thu, 23 December 2010
7 612 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 503 Thu, 23 December 2010 03:47
By: Michel Cadot
  archive log
oracle 10g
By: prashant_ora on Sun, 19 December 2010
8 3574 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 953 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 594 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: Wed Apr 16 08:34:13 CDT 2014

Total time taken to generate the page: 0.25493 seconds