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

    Replies Views Last message
  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 706 Fri, 20 January 2012 01:17
By: Michel Cadot
  Undo space
By: jack55 on Sun, 15 January 2012
3 856 Thu, 19 January 2012 07:01
By: Michel Cadot
  Join with 30 tables
Sun, Oracle 10
By: RMSoares on Mon, 16 January 2012
15 1039 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 965 Wed, 18 January 2012 03:51
By: Michel Cadot
  finding changed sql plans
By: BeefStu on Tue, 17 January 2012
4 893 Tue, 17 January 2012 15:09
By: LNossov
  AWR report
windows
By: sandeip on Tue, 17 January 2012
6 1219 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 2420 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 343 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 1007 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 855 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 1279 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 3644 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 975 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 992 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 838 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 432 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 1292 Fri, 30 December 2011 04:09
By: Michel Cadot
  performace tunning
By: sb0024297 on Fri, 30 December 2011
1 595 Fri, 30 December 2011 03:04
By: Littlefoot
  Tuning a small but complicated query
Oracle
By: neel_Tannu on Thu, 29 December 2011
2 496 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 950 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 1490 Wed, 28 December 2011 09:48
By: Kevin Meade
  Performance Tuning
All
By: lynndba on Wed, 23 November 2011
11 712 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 817 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 449 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 743 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 738 Tue, 20 December 2011 23:57
By: orapratap
  Query performance related
oracle
By: hemant_khandare on Thu, 17 November 2011
4 864 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 1252 Tue, 20 December 2011 06:35
By: Michel Cadot
  Rowid Range Scan
By: gajini on Mon, 19 December 2011
9 3266 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 1812 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 1544 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 900 Wed, 14 December 2011 04:33
By: gogol_1987
  How to improve performance
Oracle 9i
By: ravi_n on Wed, 07 December 2011
6 706 Wed, 14 December 2011 01:28
By: jameslongenecker
  Can you please provide optimized query
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0, OS - I don't know
By: manubatham20 on Thu, 13 October 2011
30 1406 Tue, 13 December 2011 08:12
By: manubatham20
  Time Calculation in AWR report
Oracle 11g R2 on windows 7 64 bit
By: orapratap on Mon, 12 December 2011
2 2936 Tue, 13 December 2011 00:13
By: orapratap
  Tune long running query
Oracle 10.2.0.4.0, SunOS
By: balaji14 on Mon, 05 December 2011
24 1439 Tue, 13 December 2011 00:05
By: balaji14
  Difficulty in using bind variable to check explain plan
Oracle 10.2.0.4 on Linux
By: orapratap on Mon, 12 December 2011
12 1279 Mon, 12 December 2011 03:56
By: Michel Cadot
  sql tuning for one query
11g 11.2.0,2,IBM aix 64 bit
By: pvgangadar on Thu, 08 December 2011
9 646 Fri, 09 December 2011 08:48
By: John Watson
  SQL Profiles
Solaris 10, Oracle 10.2.0.4
By: suddhasatwa_bhaumik on Fri, 09 December 2011
0 1199 Fri, 09 December 2011 06:28
By: suddhasatwa_bhaumik
  Performance Across DB Links
Oracle 11g2, LINUX
By: mjm22 on Wed, 07 December 2011
1 1153 Wed, 07 December 2011 15:17
By: cookiemonster
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: Thu Apr 17 20:27:05 CDT 2014

Total time taken to generate the page: 0.13806 seconds