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

    Replies Views Last message
  AWR report
windows
By: sandeip on Tue, 17 January 2012
6 1370 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 2739 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 380 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 1096 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 906 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 1432 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 4294 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 1044 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 1065 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 1029 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 468 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 1431 Fri, 30 December 2011 04:09
By: Michel Cadot
  performace tunning
By: sb0024297 on Fri, 30 December 2011
1 627 Fri, 30 December 2011 03:04
By: Littlefoot
  Tuning a small but complicated query
Oracle
By: neel_Tannu on Thu, 29 December 2011
2 587 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 1075 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 1750 Wed, 28 December 2011 09:48
By: Kevin Meade
  Performance Tuning
All
By: lynndba on Wed, 23 November 2011
11 803 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 914 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 496 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 813 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 839 Tue, 20 December 2011 23:57
By: orapratap
  Query performance related
oracle
By: hemant_khandare on Thu, 17 November 2011
4 924 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 1390 Tue, 20 December 2011 06:35
By: Michel Cadot
  Rowid Range Scan
By: gajini on Mon, 19 December 2011
9 3809 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 2023 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 1579 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 996 Wed, 14 December 2011 04:33
By: gogol_1987
  How to improve performance
Oracle 9i
By: ravi_n on Wed, 07 December 2011
6 837 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 1579 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 3180 Tue, 13 December 2011 00:13
By: orapratap
  Tune long running query
Oracle 10.2.0.4.0, SunOS
By: Database admin on Mon, 05 December 2011
24 1596 Tue, 13 December 2011 00:05
By: Database admin
  Difficulty in using bind variable to check explain plan
Oracle 10.2.0.4 on Linux
By: orapratap on Mon, 12 December 2011
12 1473 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 749 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 1240 Fri, 09 December 2011 06:28
By: suddhasatwa_bhaumik
  Performance Across DB Links
Oracle 11g2, LINUX
By: mjm22 on Wed, 07 December 2011
1 1305 Wed, 07 December 2011 15:17
By: cookiemonster
  create index
10.2.0.4
By: varunvir on Tue, 06 December 2011
13 624 Wed, 07 December 2011 07:57
By: Michel Cadot
  performance problem
Oracle 9i
By: ajaykumarkona on Wed, 07 December 2011
3 486 Wed, 07 December 2011 02:39
By: Michel Cadot
  How to improve the performance of export job(expdp)?
Oracle10gr2, Linux.
By: konkalasiva on Tue, 06 December 2011
1 1494 Tue, 06 December 2011 03:44
By: Michel Cadot
  How to reduce cost of my query?
sql developer
By: Naga_naga_naga on Sat, 03 December 2011
3 1541 Sat, 03 December 2011 01:16
By: flyboy
  urgent please modify this query frenz sloww performance
By: arivazhagancsegmailcom on Thu, 01 December 2011
12 918 Fri, 02 December 2011 16:07
By: LNossov
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 Oct 02 01:50:59 CDT 2014

Total time taken to generate the page: 0.13295 seconds