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

    Replies Views Last message
  Tune Query or Modify Index or Partition
By: p2004 on Fri, 27 January 2012
1 568 Fri, 27 January 2012 02:29
By: Michel Cadot
  PLSQL and related cursors generated in v$sql
10gr2
By: nikko on Thu, 26 January 2012
1 753 Thu, 26 January 2012 03:01
By: Michel Cadot
  Can anyone help to do some tuning on ORACLE 9i?
ORACLE 9i
By: cooldude_no1 on Wed, 25 January 2012
1 669 Wed, 25 January 2012 04:28
By: Michel Cadot
  Primary key - unusable
Oracle - 10g
By: sathik on Fri, 20 January 2012
10 3174 Tue, 24 January 2012 05:34
By: Michel Cadot
  Query execution path
11gR2 Linux
By: gkrishn on Sat, 21 January 2012
8 1220 Sun, 22 January 2012 02:56
By: John Watson
  CBO Query re-write
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit, HP-UX
By: manubatham20 on Sat, 21 January 2012
2 1044 Sun, 22 January 2012 00:40
By: Michel Cadot
  Please help me tune this sql
Oracle 10g
By: manoveg on Tue, 18 January 2011
9 1928 Sat, 21 January 2012 09:18
By: Michel Cadot
  Problem Index with IN Statement (merged)
Oracle 10g Enterprise Edition Release 10.2.0.1.0, Solaris 10
By: MarkusW on Wed, 18 January 2012
12 742 Fri, 20 January 2012 01:17
By: Michel Cadot
  Undo space
By: jack55 on Sun, 15 January 2012
3 913 Thu, 19 January 2012 07:01
By: Michel Cadot
  Join with 30 tables
Sun, Oracle 10
By: RMSoares on Mon, 16 January 2012
15 1090 Thu, 19 January 2012 02:57
By: RMSoares
  SQl ID from peoplesoft process
Oracle 10g Hp-UX
By: pokhraj_d on Wed, 18 January 2012
5 1012 Wed, 18 January 2012 03:51
By: Michel Cadot
  finding changed sql plans
By: BeefStu on Tue, 17 January 2012
4 979 Tue, 17 January 2012 15:09
By: LNossov
  AWR report
windows
By: sandeip on Tue, 17 January 2012
6 1311 Tue, 17 January 2012 07:07
By: Michel Cadot
  Best Practices to optimize a FAST REFRESH Materialized View?
Oracle 11g
By: tsteinmaurer on Mon, 16 January 2012
2 2618 Tue, 17 January 2012 05:53
By: rleishman
  Wait events for a query
Oracle 10.2.0.4
By: himabija on Tue, 17 January 2012
1 372 Tue, 17 January 2012 04:52
By: Michel Cadot
  Oracle10g Standard Edition on Linux machine
SGA Tuning
By: gauravsrivastava on Mon, 16 January 2012
5 1064 Mon, 16 January 2012 02:17
By: himabija
  truncate table
Linux 2.6.18-92.1.13.el5
By: dba_7722 on Fri, 13 January 2012
4 890 Fri, 13 January 2012 04:50
By: Michel Cadot
  Query running more time
Oracle 11g standard Version
By: sank on Mon, 09 January 2012
4 1368 Tue, 10 January 2012 14:50
By: sank
  HTML AWR Report
Red Hat Linux 5.3 and oracle 10g
By: morad_dba on Tue, 10 January 2012
9 4071 Tue, 10 January 2012 09:13
By: ramoradba
icon1.gif Explain Plan
Oracle 10g Hp-UX
By: pokhraj_d on Thu, 05 January 2012
3 1019 Thu, 05 January 2012 06:05
By: rleishman
  Query taking long time on MVs
Oracle 11g, UNIX
By: ind9 on Thu, 29 December 2011
4 1041 Wed, 04 January 2012 12:00
By: LNossov
  Same query using different execution plans, why??
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
By: manubatham20 on Mon, 26 December 2011
8 965 Wed, 04 January 2012 09:15
By: LNossov
  Performance problem with table when using one column as reserved word METHOD
Oracle 10g,Windows XP
By: shajat on Thu, 29 December 2011
2 457 Fri, 30 December 2011 05:58
By: shajat
  Remove Table Fragmentation
oracle 11.2.0 , linux X86
By: crussed_sonu on Thu, 29 December 2011
7 1382 Fri, 30 December 2011 04:09
By: Michel Cadot
  performace tunning
By: sb0024297 on Fri, 30 December 2011
1 619 Fri, 30 December 2011 03:04
By: Littlefoot
  Tuning a small but complicated query
Oracle
By: neel_Tannu on Thu, 29 December 2011
2 542 Thu, 29 December 2011 17:35
By: BlackSwan
  Bitmap Conversion
Oracle 10.2.0.3.0 on AIX
By: chuckstoker on Tue, 20 December 2011
8 1023 Wed, 28 December 2011 09:49
By: Kevin Meade
  Query running long time
Oracle ,10.2.0.4.0 , SunOS
By: Jack14 on Mon, 26 December 2011
5 1632 Wed, 28 December 2011 09:48
By: Kevin Meade
  Performance Tuning
All
By: lynndba on Wed, 23 November 2011
11 762 Tue, 27 December 2011 21:20
By: Kevin Meade
  Performance access direct table vs view
Oracle 10g / Windows XP
By: eeriehunk on Fri, 09 December 2011
9 873 Tue, 27 December 2011 20:23
By: Kevin Meade
  Query cost
oracle, 10g, HP-UX B.11.23
By: aruldts on Tue, 27 December 2011
1 477 Tue, 27 December 2011 01:32
By: Michel Cadot
  How to Track Delay in Displaying data on application GUI
Oracle 10.2.0.4
By: orapratap on Wed, 21 December 2011
3 787 Wed, 21 December 2011 03:59
By: Roachcoach
  Query on Explain Plan Steps
Oracle 10.2.0.4 on RHEL
By: orapratap on Wed, 14 December 2011
9 796 Tue, 20 December 2011 23:57
By: orapratap
  Query performance related
oracle
By: hemant_khandare on Thu, 17 November 2011
4 906 Tue, 20 December 2011 10:42
By: hemant_khandare
  buffer busy wait
Linux 2.6.18-92.1.13.el5
By: dba_7722 on Tue, 20 December 2011
4 1335 Tue, 20 December 2011 06:35
By: Michel Cadot
  Rowid Range Scan
By: gajini on Mon, 19 December 2011
9 3595 Mon, 19 December 2011 04:53
By: Roachcoach
  Question on table statistics
Oracle 10.2.0.4.0 ,Sun solaris
By: Jack14 on Tue, 13 December 2011
23 1940 Thu, 15 December 2011 23:56
By: Jack14
  Situations where FAST REFRESH Materialized View does a COMPLETE REFRESH?
Oracle 10g
By: tsteinmaurer on Thu, 15 December 2011
0 1575 Thu, 15 December 2011 06:03
By: tsteinmaurer
  simple select * from table is taking lot of time
11.2.0.1.0
By: gogol_1987 on Tue, 13 December 2011
9 961 Wed, 14 December 2011 04:33
By: gogol_1987
  How to improve performance
Oracle 9i
By: ravi_n on Wed, 07 December 2011
6 791 Wed, 14 December 2011 01:28
By: jameslongenecker
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 Jul 30 03:36:46 CDT 2014

Total time taken to generate the page: 0.12579 seconds