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

    Replies Views Last message
  RedoLog Contention
By: Kavitha Suresh on Wed, 28 June 2006
3 2498 Wed, 28 June 2006 11:54
By: Kavitha Suresh
  slow insert/update - same schema on two servers
By: SASA on Tue, 27 June 2006
4 2085 Wed, 28 June 2006 02:12
By: SASA
  Query performance: Hard code values vs. parmeterized values
By: lamhe2804 on Tue, 27 June 2006
1 1717 Tue, 27 June 2006 22:23
By: rleishman
  Server Parameters !!
By: AlinaC on Thu, 22 June 2006
3 1086 Tue, 27 June 2006 07:24
By: AlinaC
  Log filesize
By: yash_v on Tue, 27 June 2006
1 1175 Tue, 27 June 2006 06:16
By: JSI2001
  low buffer hit ratio
By: abs_amit on Mon, 26 June 2006
2 3593 Mon, 26 June 2006 10:08
By: Mahesh Rajendran
  convert partition table to normal table
By: shaygilad on Mon, 26 June 2006
1 2826 Mon, 26 June 2006 09:05
By: Frank Naude
  Configuration of PGA Aggregate Target
By: kumarsz on Tue, 06 June 2006
2 7042 Mon, 26 June 2006 06:52
By: jimit_shaili
  Question on 10.2.0.2 patch application on 10.2.0.1 database
By: rajd on Sun, 25 June 2006
1 3421 Sun, 25 June 2006 19:23
By: Mahesh Rajendran
  improve performance of query over dblink.
By: rajd on Sun, 25 June 2006
5 5219 Sun, 25 June 2006 17:19
By: rajd
  Can I use Pragma Autonomous Transactions for Performance Improvement?
By: Abhishek_Gupta on Tue, 20 June 2006
1 3426 Thu, 22 June 2006 17:22
By: andrew again
  How to reduce nested loops in a big query?
By: Jaime Stuardo on Wed, 21 June 2006
6 3025 Wed, 21 June 2006 09:52
By: Jaime Stuardo
  capture users & statements causing archive log full
By: jasbosky on Wed, 21 June 2006
1 1990 Wed, 21 June 2006 05:09
By: orausern
  How to find the loading session
By: akudba on Wed, 21 June 2006
1 1266 Wed, 21 June 2006 04:48
By: Mahesh Rajendran
  How to Improve Oracle View Performance
By: TheStupid on Tue, 20 June 2006
6 10708 Tue, 20 June 2006 09:39
By: Mahesh Rajendran
  Is there any way for defrage the tablespace in linux Os
By: jimit_shaili on Mon, 19 June 2006
1 1356 Mon, 19 June 2006 10:49
By: Mahesh Rajendran
  Req. help on Temporary Tablespace
By: jimit_shaili on Sun, 18 June 2006
1 2763 Sun, 18 June 2006 07:19
By: Mahesh Rajendran
  Improving materialized view performance
By: ajithgk73 on Fri, 16 June 2006
3 1935 Sat, 17 June 2006 10:47
By: Littlefoot
  Automatic Shared Memory Management (ASMM) !!
By: AlinaC on Fri, 16 June 2006
1 1069 Fri, 16 June 2006 13:08
By: Frank Naude
  More "SQL*Net message to/from client" than expected
By: YodaBoy on Thu, 15 June 2006
3 4482 Thu, 15 June 2006 17:26
By: BlackSwan
icon4.gif Latch Contention
By: vikramjogi on Thu, 15 June 2006
4 2263 Thu, 15 June 2006 13:59
By: vikramjogi
  queries on collecting schema statistics (oracle 9i)
By: orausern on Wed, 14 June 2006
5 4958 Wed, 14 June 2006 13:15
By: asmishra
  is unique index helpful in making query fast?
By: a_developer on Wed, 14 June 2006
1 1207 Wed, 14 June 2006 02:35
By: JSI2001
  database slow
By: chidellanr on Mon, 12 June 2006
2 1033 Mon, 12 June 2006 01:23
By: chidellanr
  OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING
By: orausern on Fri, 09 June 2006
2 4137 Fri, 09 June 2006 09:28
By: orausern
  PL/SQL code review tool
By: kumarsz on Fri, 09 June 2006
2 2987 Fri, 09 June 2006 07:29
By: kumarsz
  Advice
By: puneetsachar on Thu, 08 June 2006
2 1386 Fri, 09 June 2006 02:53
By: JSI2001
  From where can I get all available SQL tuning HINTS for Oracle?
By: mburukimethu on Thu, 08 June 2006
1 1527 Thu, 08 June 2006 13:03
By: BlackSwan
icon13.gif Require Information
By: bhoite_amol83 on Thu, 08 June 2006
3 1034 Thu, 08 June 2006 07:36
By: Mahesh Rajendran
  Considering constraints
By: ehegagoka on Thu, 08 June 2006
3 994 Thu, 08 June 2006 03:38
By: ehegagoka
  I Need information about the value of "row cache enqueue latch"
By: crozas on Wed, 07 June 2006
0 3314 Wed, 07 June 2006 14:53
By: crozas
  Query is really taking a long time. Please help
By: pzlj6x on Fri, 02 June 2006
4 1503 Wed, 07 June 2006 13:18
By: pzlj6x
  Performance tuning commands
By: vikasg2006 on Wed, 07 June 2006
1 1471 Wed, 07 June 2006 06:31
By: Mahesh Rajendran
  Issue with index tablespace.
By: shahnazurs on Tue, 06 June 2006
3 1412 Wed, 07 June 2006 04:45
By: shahnazurs
  Query Tuning ...
By: rahul.priyadarshy on Tue, 06 June 2006
4 1492 Tue, 06 June 2006 22:49
By: rleishman
  Advice on shared_pool and block_size on 9i
By: rkl1 on Tue, 06 June 2006
1 1142 Tue, 06 June 2006 21:01
By: BlackSwan
  Application Turns Slow
By: shilpa.rajput on Thu, 01 June 2006
1 1234 Fri, 02 June 2006 00:58
By: Frank
  Implement Partitioning & Purging of Partitions
By: feroze on Wed, 24 May 2006
11 3136 Thu, 01 June 2006 04:31
By: girish.rohini
  Urgent Help Needed:Oracle 10g
By: AnilOrafaq on Wed, 31 May 2006
1 1296 Wed, 31 May 2006 21:18
By: BlackSwan
  Problem with Object Dependencies
By: kumarsz on Wed, 24 May 2006
9 4629 Wed, 31 May 2006 01:52
By: Mahesh Rajendran
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: Mon Nov 28 06:22:39 CST 2022