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

    Replies Views Last message
  To find out the Stored Procedure name and the Full table scan
By: Vijay on Tue, 09 November 2004
1 664 Tue, 09 November 2004 23:37
By: Padders
  how to tuning a hierachical query having "or" conditions
By: dragon wang on Thu, 07 October 2004
2 703 Tue, 09 November 2004 20:00
By: dragon wang
  Coalesion on the tablespaces
By: Abhijit on Tue, 09 November 2004
1 974 Tue, 09 November 2004 02:36
By: Mahesh Rajendran
  Space allocation to TEMP LOB
By: Hyma on Mon, 08 November 2004
1 765 Mon, 08 November 2004 07:15
By: andrew again
  Too much LIO from single row table
By: dejan on Wed, 03 November 2004
3 1055 Mon, 08 November 2004 04:04
By: Mahesh Rajendran
  PGA tuning - Oracle 9i
By: Kenneth on Sun, 07 November 2004
0 1224 Sun, 07 November 2004 16:09
By: Kenneth
  database doesnt start
By: shyamogoti on Thu, 04 November 2004
1 979 Sun, 07 November 2004 11:13
By: Frank Naude
  FND_STATS.GATHER_SCHEMA_STATISTICS
By: Leonie on Thu, 04 November 2004
5 11017 Thu, 04 November 2004 04:24
By: Mahesh Rajendran
  8i Inserts + Updates SLOW !
By: saustin on Thu, 04 November 2004
1 798 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 1446 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 719 Thu, 04 November 2004 01:21
By: AlanP
  Memory grows steadily - Oracle 9i
By: Ken on Wed, 03 November 2004
1 1044 Wed, 03 November 2004 20:31
By: Frank
  Urgent: finding parameters from V$ Tables
By: Bandaru on Wed, 03 November 2004
1 775 Wed, 03 November 2004 20:29
By: Frank
  SQL Tuning
By: Sankar B. Mandalika on Wed, 03 November 2004
1 721 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 790 Wed, 03 November 2004 00:11
By: sangeeta Prabhu
  Why not use analyze?
By: IA on Mon, 01 November 2004
4 746 Tue, 02 November 2004 23:02
By: DUncan SLater
  testing performance of queries
By: Milind Deshpande on Mon, 01 November 2004
2 766 Tue, 02 November 2004 03:55
By: Bruce McCartney
  Oracle Data Block Size
By: BhavinShah on Tue, 19 October 2004
1 1221 Tue, 02 November 2004 00:03
By: Deepa
  oracle
By: Anup on Mon, 01 November 2004
1 764 Mon, 01 November 2004 22:00
By: Deepa
  Performance tuning
By: manny on Mon, 01 November 2004
0 1147 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 792 Mon, 01 November 2004 08:00
By: andrew again
  Urgent:-help in rewriting an SQL
By: Milind Deshpande on Sun, 31 October 2004
0 964 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 820 Sun, 31 October 2004 01:14
By: Frank
  oracle database file corruption!
By: Soham on Tue, 26 October 2004
1 702 Sat, 30 October 2004 09:21
By: Edward Stoever
  Can I lock SGA in RAM
By: BhavinShah on Fri, 29 October 2004
1 3261 Fri, 29 October 2004 04:06
By: Mahesh Rajendran
  Cycling alert log
By: Vasco Saavedra on Thu, 28 October 2004
1 907 Thu, 28 October 2004 07:28
By: Mahesh Rajendran
  Database Buffer Cache
By: Kathy Kerler on Thu, 28 October 2004
1 871 Thu, 28 October 2004 05:46
By: Mahesh Rajendran
  Leading hint
By: Milind Deshpande on Tue, 26 October 2004
0 834 Tue, 26 October 2004 04:02
By: Milind Deshpande
  Index not used by SQL
By: Milind Deshpande on Mon, 25 October 2004
2 757 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 979 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 1326 Tue, 26 October 2004 03:03
By: BhavinShah
  Parameters changed in INIT.ora
By: Milind Deshpande on Mon, 25 October 2004
1 1734 Mon, 25 October 2004 22:03
By: Frank
  What is hash and nested loop join?
By: BhavinShah on Wed, 20 October 2004
2 1305 Thu, 21 October 2004 05:36
By: Padders
  Scenario : SQL Tuning
By: BhavinShah on Wed, 20 October 2004
1 714 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 738 Tue, 19 October 2004 21:30
By: Milind Deshpande
  Big performance difference between 8i and 9i
By: Nicola on Fri, 30 April 2004
3 1595 Tue, 19 October 2004 01:12
By: rajkumar
  Bequeth connections and memory usage in 8i
By: Dale on Mon, 18 October 2004
0 997 Mon, 18 October 2004 06:44
By: Dale
  Urgent:-SQL taking long time to execute
By: sangeeta Prabhu on Wed, 13 October 2004
1 908 Sat, 16 October 2004 20:49
By: easyweb
  Terms meaning in V$SYSSTAT
By: Milind Deshpande on Thu, 07 October 2004
1 2550 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 859 Fri, 15 October 2004 04:04
By: Mike
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: Wed Jan 27 11:00:05 CST 2021