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

    Replies Views Last message
  gather stats estimated
By: ArvindBhope on Mon, 11 August 2008
 3 2712 Mon, 11 August 2008 10:13
By: Michel Cadot
  shink blob column
oracle 10.1.0.3
By: ankush_chawla on Mon, 11 August 2008
 0 7100 Mon, 11 August 2008 08:23
By: ankush_chawla
  Performance issue
Oracle 9.2.0.1.0
By: manoj12 on Wed, 06 August 2008
 23 6945 Sun, 10 August 2008 07:24
By: michael_bialik
  How to simplify this pivot query
By: bztom33 on Thu, 20 September 2007
 8 5020 Sat, 09 August 2008 07:05
By: bztom33
  UNION and UNION ALL discrepancy
Oracle 9i, Solaris
By: bijou on Fri, 01 August 2008
 13 8212 Thu, 07 August 2008 21:52
By: rleishman
  Index is used still problem
By: bubbly on Wed, 06 August 2008
 5 3110 Thu, 07 August 2008 03:36
By: sunil_v_mishra
  How to estimate query response time and number of rows without executing query
Oracle 10.2.0.3 on Sun Solaris 5.10
By: gkodakalla on Thu, 07 August 2008
 4 3586 Thu, 07 August 2008 02:52
By: gkodakalla
  need assist to delete histograms
oracle 10.2.0.3 solaris 10
By: kumar.joy on Wed, 06 August 2008
 2 3951 Wed, 06 August 2008 12:09
By: Mahesh Rajendran
  Help me tune the query
Oracle 9.0.0.2
By: thalladas on Wed, 06 August 2008
 1 2154 Wed, 06 August 2008 11:19
By: BlackSwan
  How gathering of stats/ analyze stats work?
10g
By: beetel on Wed, 06 August 2008
 4 2726 Wed, 06 August 2008 08:48
By: BlackSwan
  sql consumes more cpu
oracle 10g, 10.2.0.1, Linux AS 3
By: guyj on Wed, 06 August 2008
 5 3154 Wed, 06 August 2008 05:56
By: rajatratewal
  to decide pctused,pctfree in Oracle8i (merged)
By: chinmayikkalki on Wed, 06 August 2008
 3 2308 Wed, 06 August 2008 04:11
By: Michel Cadot
  buffer cache handles
oracle 10g
By: holdersav2000 on Tue, 05 August 2008
 6 4803 Wed, 06 August 2008 02:17
By: holdersav2000
  selectivity in index usage
Oracle 9i
By: krshnn592 on Tue, 05 August 2008
 3 2687 Tue, 05 August 2008 10:50
By: Michel Cadot
  QUERY REWRITING
9.2.0.7.WONDOWS SERVER 2003
By: jayarajkrishna on Sun, 03 August 2008
 2 2575 Tue, 05 August 2008 08:24
By: JRowbottom
  DB link query.
10.2.0.3
By: sonumalhi on Mon, 04 August 2008
 1 4931 Mon, 04 August 2008 16:26
By: BlackSwan
  Merging large amounts of data into large tables
oracle 10
By: zzasteven on Mon, 04 August 2008
 6 5292 Mon, 04 August 2008 14:04
By: zzasteven
  Need suggestion for a better query.
By: pravin3032 on Tue, 22 July 2008
 6 4246 Mon, 04 August 2008 07:27
By: pravin3032
  SQL Tuning Methods & Books
9i/10g
By: oraclegyaani on Sun, 03 August 2008
 1 2181 Sun, 03 August 2008 11:51
By: Michel Cadot
  CREATE TABLE using SEQUENCE
ORacle 9i
By: ravashingravi on Sat, 02 August 2008
 3 4601 Sun, 03 August 2008 01:48
By: Michel Cadot
  statspack report
Oracle 9i
By: manoj12 on Thu, 31 July 2008
 8 6000 Sun, 03 August 2008 01:40
By: Michel Cadot
  HIGH no of LOCKS exclusive in tables for UPDATE Statement
Oracle 9.2.0.8
By: udara on Mon, 21 July 2008
 3 2969 Sat, 02 August 2008 20:59
By: Kevin Meade
  criteria for partitioning
Oracle 10gR2
By: eaganfox on Tue, 22 July 2008
 5 3247 Fri, 01 August 2008 01:24
By: Michel Cadot
  Adding INDEX_DESC hint slow down the query
Oracle9i
By: shrinika on Mon, 28 July 2008
 3 6127 Thu, 31 July 2008 13:28
By: shrinika
  Report hangs
ORACLE 10.2.0.4.0, WINDOWS 2003 SERVER SP2
By: srini_thiru on Thu, 31 July 2008
 1 2563 Thu, 31 July 2008 08:57
By: BlackSwan
  Performance issues after Database Hang during backup
Oracle 10g
By: virmahi on Mon, 28 July 2008
 7 4363 Thu, 31 July 2008 06:28
By: Mahesh Rajendran
  ora-04030
By: srini_thiru on Fri, 25 July 2008
 8 13406 Thu, 31 July 2008 05:42
By: Michel Cadot
  Reverse key index
By: getritesh on Tue, 29 July 2008
 8 5428 Wed, 30 July 2008 22:52
By: rleishman
  Performance
Oracle 9i(9.2.0.1.0)
By: manoj12 on Thu, 24 July 2008
 8 4175 Tue, 29 July 2008 22:09
By: rleishman
  Stale Statisics
Oracle 10g,Rel 2 ,Linux AS4
By: rsreddy28 on Tue, 29 July 2008
 1 2384 Tue, 29 July 2008 05:24
By: Michel Cadot
  gather stats
By: ArvindBhope on Tue, 29 July 2008
 3 2363 Tue, 29 July 2008 03:19
By: Michel Cadot
  Tuning 'LIKE' Clause
Oracle,10g,Windows XP
By: getritesh on Mon, 28 July 2008
 2 3260 Mon, 28 July 2008 14:24
By: Michel Cadot
  type tables in plsql/ variable IN list
By: eaganfox on Fri, 25 July 2008
 3 3096 Fri, 25 July 2008 17:54
By: coleing
  need help to optimize the query
oracle 10.2.0.3 solaris 10
By: skumar.dba on Wed, 23 July 2008
 1 2062 Thu, 24 July 2008 22:26
By: rleishman
  need assistance to tune the query
solarin 5.10, oracle 10.2.0.3
By: kumar.joy on Thu, 24 July 2008
 8 3794 Thu, 24 July 2008 22:22
By: rleishman
  Testing of generated test data from Sequence
oracle 10g
By: sreechaitu on Thu, 24 July 2008
 1 2071 Thu, 24 July 2008 13:08
By: BlackSwan
  how find SGA size is sufficient or not?
oracle 10.2.0.3 solaris 10
By: skumar.dba on Tue, 22 July 2008
 8 18914 Thu, 24 July 2008 01:44
By: Michel Cadot
  Is possible to turn the following into a view
Oracle 10g
By: bztom33 on Mon, 21 July 2008
 4 3004 Wed, 23 July 2008 16:03
By: Kevin Meade
  high cost
oracle 10g,TOAD
By: balaji1482 on Thu, 17 July 2008
 12 4874 Wed, 23 July 2008 10:28
By: balaji1482
  Avoiding : ORA-00470: LGWR process terminated with error
By: Josphat Kioko on Tue, 12 October 2004
 1 19173 Wed, 23 July 2008 07:54
By: sunil_v_mishra
Goto Forum:
  
 [ Syndicate this forum (XML) ] [ RSS ]
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: Tue May 26 04:03:00 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.