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

    Replies Views Last message
  database doesnt start
By: shyamogoti on Thu, 04 November 2004
1 3620 Sun, 07 November 2004 11:13
By: Frank Naude
  FND_STATS.GATHER_SCHEMA_STATISTICS
By: Leonie on Thu, 04 November 2004
5 15754 Thu, 04 November 2004 04:24
By: Mahesh Rajendran
  8i Inserts + Updates SLOW !
By: saustin on Thu, 04 November 2004
1 3122 Thu, 04 November 2004 04:23
By: Mahesh Rajendran
  Gather Schema Stats fails on functional/bitmap index
By: Leonie on Thu, 04 November 2004
0 3721 Thu, 04 November 2004 02:17
By: Leonie
  Why the query is taking so long to execute
By: sangeeta Prabhu on Thu, 04 November 2004
1 3997 Thu, 04 November 2004 01:21
By: AlanP
  Memory grows steadily - Oracle 9i
By: Ken on Wed, 03 November 2004
1 4129 Wed, 03 November 2004 20:31
By: Frank
  Urgent: finding parameters from V$ Tables
By: Bandaru on Wed, 03 November 2004
1 3824 Wed, 03 November 2004 20:29
By: Frank
  SQL Tuning
By: Sankar B. Mandalika on Wed, 03 November 2004
1 3241 Wed, 03 November 2004 20:28
By: Frank
  URGENT:-Problem due to Remote access of a Table in SQL
By: sangeeta Prabhu on Tue, 02 November 2004
2 3934 Wed, 03 November 2004 00:11
By: sangeeta Prabhu
  Why not use analyze?
By: IA on Mon, 01 November 2004
4 4045 Tue, 02 November 2004 23:02
By: DUncan SLater
  testing performance of queries
By: Milind Deshpande on Mon, 01 November 2004
2 3741 Tue, 02 November 2004 03:55
By: Bruce McCartney
  Oracle Data Block Size
By: BhavinShah on Tue, 19 October 2004
1 3715 Tue, 02 November 2004 00:03
By: Deepa
  oracle
By: Anup on Mon, 01 November 2004
1 3358 Mon, 01 November 2004 22:00
By: Deepa
  Performance tuning
By: manny on Mon, 01 November 2004
0 3686 Mon, 01 November 2004 20:29
By: manny
  Does providing a Numeric value in Single quotes affects performance
By: sangeeta Prabhu on Mon, 01 November 2004
1 3608 Mon, 01 November 2004 08:00
By: andrew again
  Urgent:-help in rewriting an SQL
By: Milind Deshpande on Sun, 31 October 2004
0 3128 Sun, 31 October 2004 17:59
By: Milind Deshpande
  what is the configuration to create a fresh database
By: Ravikumar.V on Sat, 30 October 2004
1 3641 Sun, 31 October 2004 01:14
By: Frank
  oracle database file corruption!
By: Soham on Tue, 26 October 2004
1 3092 Sat, 30 October 2004 09:21
By: Edward Stoever
  Can I lock SGA in RAM
By: BhavinShah on Fri, 29 October 2004
1 5846 Fri, 29 October 2004 04:06
By: Mahesh Rajendran
  Cycling alert log
By: Vasco Saavedra on Thu, 28 October 2004
1 3670 Thu, 28 October 2004 07:28
By: Mahesh Rajendran
  Database Buffer Cache
By: Kathy Kerler on Thu, 28 October 2004
1 3708 Thu, 28 October 2004 05:46
By: Mahesh Rajendran
  Leading hint
By: Milind Deshpande on Tue, 26 October 2004
0 3261 Tue, 26 October 2004 04:02
By: Milind Deshpande
  Index not used by SQL
By: Milind Deshpande on Mon, 25 October 2004
2 3668 Tue, 26 October 2004 03:18
By: Mahesh Rajendran
  Pl. clear my douts of nested loop join.
By: BhavinShah on Thu, 21 October 2004
4 4099 Tue, 26 October 2004 03:05
By: BhavinShah
  What is a effecting a analyzing a table for CBO.
By: BhavinShah on Thu, 21 October 2004
3 4147 Tue, 26 October 2004 03:03
By: BhavinShah
  Parameters changed in INIT.ora
By: Milind Deshpande on Mon, 25 October 2004
1 4403 Mon, 25 October 2004 22:03
By: Frank
  What is hash and nested loop join?
By: BhavinShah on Wed, 20 October 2004
2 4976 Thu, 21 October 2004 05:36
By: Padders
  Scenario : SQL Tuning
By: BhavinShah on Wed, 20 October 2004
1 3523 Wed, 20 October 2004 02:11
By: Deepak Panda
  URGENT:-Query taking more than 14 hrs.
By: Milind Deshpande on Tue, 19 October 2004
2 3908 Tue, 19 October 2004 21:30
By: Milind Deshpande
  Big performance difference between 8i and 9i
By: Nicola on Fri, 30 April 2004
3 5276 Tue, 19 October 2004 01:12
By: rajkumar
  Bequeth connections and memory usage in 8i
By: Dale on Mon, 18 October 2004
0 2995 Mon, 18 October 2004 06:44
By: Dale
  Urgent:-SQL taking long time to execute
By: sangeeta Prabhu on Wed, 13 October 2004
1 3200 Sat, 16 October 2004 20:49
By: easyweb
  Terms meaning in V$SYSSTAT
By: Milind Deshpande on Thu, 07 October 2004
1 4844 Fri, 15 October 2004 10:10
By: itgal
  Demonstrating if Insertion is Faster in Partitioned or Non-Partitioned Table
By: Shariq T on Thu, 30 September 2004
3 4450 Fri, 15 October 2004 04:04
By: Mike
  URGENT:-Query not performing well
By: Milind Deshpande on Mon, 11 October 2004
2 3550 Fri, 15 October 2004 03:53
By: explain_plan
  cache data problem
By: gulshan on Wed, 13 October 2004
1 3064 Thu, 14 October 2004 02:55
By: Frank
  Removing caching in Oracle
By: MBB on Fri, 08 October 2004
1 3254 Wed, 13 October 2004 05:59
By: Frank Naude
  Oracle instance running on a system with low open file
By: lily on Mon, 04 October 2004
2 7714 Tue, 12 October 2004 10:40
By: lily
  Urgent:-SQL Help
By: Milind Deshpande on Tue, 12 October 2004
0 3184 Tue, 12 October 2004 05:07
By: Milind Deshpande
  Server gets slow after some days of fresh import
By: gurinder on Sat, 25 September 2004
3 4478 Tue, 12 October 2004 03:29
By: gurinder
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: Sun Apr 19 15:29:46 CDT 2026