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

    Replies Views Last message
  How can I prove plan invalidations
By: smartin on Thu, 13 October 2005
3 892 Fri, 14 October 2005 13:52
By: smartin
  Analytic function but bad performance (merged 5 cross-posts)
By: Kanagaraj Velusamy on Fri, 07 October 2005
14 2639 Fri, 14 October 2005 10:43
By: smartin
  tuning documentation
By: kartal on Fri, 14 October 2005
1 844 Fri, 14 October 2005 10:03
By: Frank
  Oracle Text performance
By: CrisDK on Mon, 10 October 2005
2 1373 Thu, 13 October 2005 18:48
By: cybotto
  Slow Query
By: abc123 on Thu, 13 October 2005
1 765 Thu, 13 October 2005 18:39
By: cybotto
  Theoretical Question Regarding Full Table Scans
By: scottwmackey on Thu, 13 October 2005
3 814 Thu, 13 October 2005 16:55
By: smartin
  Why two sets of explain plans in tkprof..ed file??
By: wushu_kid on Fri, 07 October 2005
12 2241 Wed, 12 October 2005 17:05
By: wushu_kid
  How can I see the optimized SQL by CBO
By: vgs2005 on Mon, 10 October 2005
1 852 Mon, 10 October 2005 08:23
By: Frank Naude
  defragment in oracle
By: manu_jariwala on Sat, 08 October 2005
2 3133 Mon, 10 October 2005 06:21
By: girish.rohini
  AUM IN ORACLE
By: israel05 on Wed, 05 October 2005
1 967 Mon, 10 October 2005 06:16
By: sunil_v_mishra
  max memory of oracle process
By: gautamvv on Mon, 10 October 2005
1 846 Mon, 10 October 2005 06:04
By: sunil_v_mishra
icon5.gif Partition feature
By: rebeccaz on Thu, 22 September 2005
2 999 Fri, 07 October 2005 08:07
By: wushu_kid
icon8.gif Tuning SQL
By: vikramjogi on Wed, 05 October 2005
1 1743 Fri, 07 October 2005 05:38
By: sunil_v_mishra
  rebuilding indexes ..!!!
By: balavignesh on Thu, 06 October 2005
4 867 Thu, 06 October 2005 15:24
By: smartin
  how oracle calculates statistics from within
By: mjschwenger on Thu, 06 October 2005
0 2587 Thu, 06 October 2005 11:15
By: mjschwenger
  Upgrade
By: manu_jariwala on Thu, 06 October 2005
1 741 Thu, 06 October 2005 08:07
By: Frank Naude
  End user problem
By: oradba16 on Thu, 06 October 2005
2 825 Thu, 06 October 2005 02:58
By: JSI2001
  different performance on old server
By: mjschwenger on Tue, 04 October 2005
2 838 Wed, 05 October 2005 07:35
By: Mahesh Rajendran
  Increasing performance of queries
By: sreek_s on Wed, 05 October 2005
1 859 Wed, 05 October 2005 07:10
By: Mahesh Rajendran
  indexes
By: adi_dba on Fri, 09 September 2005
12 1522 Wed, 05 October 2005 07:03
By: adi_dba
  not using index from application
By: mjschwenger on Thu, 29 September 2005
4 911 Sat, 01 October 2005 21:04
By: smartin
  sizing SGA...???
By: balavignesh on Fri, 16 September 2005
15 9974 Fri, 30 September 2005 13:09
By: Hindustanweb
  Why the Index is not used, even if its forced?
By: nabeelkhan on Thu, 23 June 2005
16 2127 Fri, 30 September 2005 09:00
By: ziggy
  Last n records based on date
By: scottwmackey on Wed, 13 April 2005
19 4171 Fri, 30 September 2005 08:15
By: ziggy
  SQL Query with many joins
By: sebastianR on Thu, 29 September 2005
3 1174 Thu, 29 September 2005 12:06
By: smartin
  how to rebuild index
By: c_gajen on Thu, 29 September 2005
1 874 Thu, 29 September 2005 09:35
By: Mahesh Rajendran
  Statspack
By: pjose on Mon, 26 September 2005
2 830 Thu, 29 September 2005 05:52
By: girish.rohini
  SQL TRACE
By: nitin_228 on Tue, 27 September 2005
2 3731 Wed, 28 September 2005 14:39
By: nitin_228
  RAC: "global cache cr request" events take 1 second ocasionally
By: ollibrandt on Tue, 27 September 2005
1 7369 Tue, 27 September 2005 11:53
By: Mahesh Rajendran
  Use PCTfree/Initran/Maxtran to prevent contention
By: mjschwenger on Sat, 24 September 2005
3 4538 Tue, 27 September 2005 11:46
By: smartin
  Poor Performance in Accessing Remote Database
By: genialsenthil on Mon, 26 September 2005
3 948 Mon, 26 September 2005 06:57
By: Mahesh Rajendran
  Procedure tunning
By: sunil_v_mishra on Fri, 23 September 2005
4 1662 Mon, 26 September 2005 01:57
By: sunil_v_mishra
icon5.gif Solaris 9, 10g hard parse/soft parse what does it mean?
By: nmacdannald on Fri, 23 September 2005
1 2313 Sat, 24 September 2005 06:23
By: Art Metzer
  Can bigger blocksize for indexes help increasing performance and lower I/O
By: mjschwenger on Fri, 23 September 2005
3 917 Fri, 23 September 2005 10:17
By: mjschwenger
  Tuning the sql by using explain plan
By: balasmg on Thu, 22 September 2005
1 1240 Thu, 22 September 2005 11:05
By: Art Metzer
  "slave shutdown wait" - event
By: shlomi_bt on Wed, 21 September 2005
1 822 Wed, 21 September 2005 13:13
By: smartin
  Error while installing Statspack
By: oracledbanewbie on Fri, 16 September 2005
3 6126 Mon, 19 September 2005 11:58
By: oracledbanewbie
  how to increase search in the database
By: genialsenthil on Mon, 19 September 2005
2 1002 Mon, 19 September 2005 08:09
By: Art Metzer
icon9.gif The time of 1 Query is more than 1 hour, HELP ¡¡¡
By: IngRMP on Mon, 19 September 2005
1 795 Mon, 19 September 2005 08:05
By: Art Metzer
  Difference in retrieving number of rows between two queries
By: sharan_it on Mon, 05 September 2005
3 1665 Fri, 16 September 2005 04:12
By: sharan_it
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 27 01:21:56 CDT 2022