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

    Replies Views Last message
  8i Inserts + Updates SLOW !
By: saustin on Thu, 04 November 2004
1 2612 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 3336 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 3381 Thu, 04 November 2004 01:21
By: AlanP
  Memory grows steadily - Oracle 9i
By: Ken on Wed, 03 November 2004
1 3543 Wed, 03 November 2004 20:31
By: Frank
  Urgent: finding parameters from V$ Tables
By: Bandaru on Wed, 03 November 2004
1 3304 Wed, 03 November 2004 20:29
By: Frank
  SQL Tuning
By: Sankar B. Mandalika on Wed, 03 November 2004
1 2709 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 3196 Wed, 03 November 2004 00:11
By: sangeeta Prabhu
  Why not use analyze?
By: IA on Mon, 01 November 2004
4 3251 Tue, 02 November 2004 23:02
By: DUncan SLater
  testing performance of queries
By: Milind Deshpande on Mon, 01 November 2004
2 3114 Tue, 02 November 2004 03:55
By: Bruce McCartney
  Oracle Data Block Size
By: BhavinShah on Tue, 19 October 2004
1 3127 Tue, 02 November 2004 00:03
By: Deepa
  oracle
By: Anup on Mon, 01 November 2004
1 2869 Mon, 01 November 2004 22:00
By: Deepa
  Performance tuning
By: manny on Mon, 01 November 2004
0 3250 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 3107 Mon, 01 November 2004 08:00
By: andrew again
  Urgent:-help in rewriting an SQL
By: Milind Deshpande on Sun, 31 October 2004
0 2710 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 3120 Sun, 31 October 2004 01:14
By: Frank
  oracle database file corruption!
By: Soham on Tue, 26 October 2004
1 2580 Sat, 30 October 2004 09:21
By: Edward Stoever
  Can I lock SGA in RAM
By: BhavinShah on Fri, 29 October 2004
1 5305 Fri, 29 October 2004 04:06
By: Mahesh Rajendran
  Cycling alert log
By: Vasco Saavedra on Thu, 28 October 2004
1 3155 Thu, 28 October 2004 07:28
By: Mahesh Rajendran
  Database Buffer Cache
By: Kathy Kerler on Thu, 28 October 2004
1 3155 Thu, 28 October 2004 05:46
By: Mahesh Rajendran
  Leading hint
By: Milind Deshpande on Tue, 26 October 2004
0 2851 Tue, 26 October 2004 04:02
By: Milind Deshpande
  Index not used by SQL
By: Milind Deshpande on Mon, 25 October 2004
2 3020 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 3200 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 3295 Tue, 26 October 2004 03:03
By: BhavinShah
  Parameters changed in INIT.ora
By: Milind Deshpande on Mon, 25 October 2004
1 3892 Mon, 25 October 2004 22:03
By: Frank
  What is hash and nested loop join?
By: BhavinShah on Wed, 20 October 2004
2 4045 Thu, 21 October 2004 05:36
By: Padders
  Scenario : SQL Tuning
By: BhavinShah on Wed, 20 October 2004
1 3021 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 3223 Tue, 19 October 2004 21:30
By: Milind Deshpande
  Big performance difference between 8i and 9i
By: Nicola on Fri, 30 April 2004
3 4431 Tue, 19 October 2004 01:12
By: rajkumar
  Bequeth connections and memory usage in 8i
By: Dale on Mon, 18 October 2004
0 2592 Mon, 18 October 2004 06:44
By: Dale
  Urgent:-SQL taking long time to execute
By: sangeeta Prabhu on Wed, 13 October 2004
1 2695 Sat, 16 October 2004 20:49
By: easyweb
  Terms meaning in V$SYSSTAT
By: Milind Deshpande on Thu, 07 October 2004
1 4390 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 3697 Fri, 15 October 2004 04:04
By: Mike
  URGENT:-Query not performing well
By: Milind Deshpande on Mon, 11 October 2004
2 2964 Fri, 15 October 2004 03:53
By: explain_plan
  cache data problem
By: gulshan on Wed, 13 October 2004
1 2569 Thu, 14 October 2004 02:55
By: Frank
  Removing caching in Oracle
By: MBB on Fri, 08 October 2004
1 2742 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 6980 Tue, 12 October 2004 10:40
By: lily
  Urgent:-SQL Help
By: Milind Deshpande on Tue, 12 October 2004
0 2732 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 3689 Tue, 12 October 2004 03:29
By: gurinder
  Performance of a database
By: Joseph on Sat, 09 October 2004
1 2869 Mon, 11 October 2004 13:20
By: abhay
  Index Efficiency
By: Moftah on Tue, 05 October 2004
1 2914 Mon, 11 October 2004 05:02
By: farky
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 Dec 22 18:21:31 CST 2024