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

    Replies Views Last message
  Module in Statspack Report
By: kumarsz on Wed, 12 September 2007
3 2084 Wed, 12 September 2007 13:54
By: Michel Cadot
  lots of waits sql*net
By: thorin666 on Wed, 12 September 2007
2 2159 Wed, 12 September 2007 12:04
By: thorin666
  Sql slow query plan
By: vasudevan on Wed, 12 September 2007
1 1797 Wed, 12 September 2007 10:35
By: Michel Cadot
  Too much memory consumed in SGA
By: rrodriguez56 on Mon, 10 September 2007
2 7206 Wed, 12 September 2007 10:19
By: rrodriguez56
  SMON TOP PROCESS
By: pag63 on Wed, 12 September 2007
1 11109 Wed, 12 September 2007 09:33
By: MarcL
  DB_Cache_Hit Ratio less than 70
By: tkmittal1 on Tue, 11 September 2007
16 3710 Wed, 12 September 2007 06:15
By: Michel Cadot
  What is the different between Oracle parse and application parse?
By: trantuananh24hg on Tue, 11 September 2007
1 2373 Wed, 12 September 2007 01:10
By: Michel Cadot
  Trying to tune a query.
By: galan_josel on Mon, 10 September 2007
6 3096 Tue, 11 September 2007 21:41
By: galan_josel
  Error when I try to connect to a database using sqlplus
By: alexia_net on Tue, 11 September 2007
5 3169 Tue, 11 September 2007 05:36
By: alexia_net
  a lot of rollback problem
By: thorin666 on Mon, 10 September 2007
3 2384 Tue, 11 September 2007 04:55
By: Michel Cadot
  How many connection are on line
By: alexia_net on Tue, 11 September 2007
3 2051 Tue, 11 September 2007 04:17
By: alexia_net
  CPU usage has been 100% consistently
By: sreehari on Thu, 16 August 2007
6 4484 Tue, 11 September 2007 01:31
By: rupaliss
icon4.gif Query running slow .. a day before it was fine
By: luckyally on Wed, 22 August 2007
8 3608 Tue, 11 September 2007 01:26
By: Arju
  Too many redo log file (merged)
By: vikeshcool@hotmail.com on Thu, 06 September 2007
10 4162 Mon, 10 September 2007 23:15
By: BlackSwan
  Table lock Blocking
By: kflee2000 on Sun, 09 September 2007
5 2450 Mon, 10 September 2007 01:35
By: Michel Cadot
  How to identify a parse of SQL statement?
By: trantuananh24hg on Fri, 07 September 2007
4 2511 Sun, 09 September 2007 13:43
By: Michel Cadot
  How can we get statistics on a table being used 24/7 in a database
By: coolboy2005in on Sun, 09 September 2007
4 2016 Sun, 09 September 2007 10:46
By: mson77
  Instance Efficiency
By: vasudevan on Fri, 07 September 2007
4 3224 Fri, 07 September 2007 13:02
By: Michel Cadot
  Procedure Tuning
By: yashora on Thu, 06 September 2007
6 3298 Thu, 06 September 2007 22:01
By: rleishman
  Oracle10g 10.0.2.0.1 Performance Problems
By: geonet on Mon, 27 August 2007
18 5928 Wed, 05 September 2007 23:48
By: mson77
  Can anyone sent me the good peformance & tuning pdf file for 10g
By: priyachopra on Sat, 01 September 2007
3 2257 Wed, 05 September 2007 23:29
By: mson77
icon6.gif STATSPACK ANALYSIS TOOL
By: navaneethdba on Wed, 01 August 2007
7 16178 Wed, 05 September 2007 23:19
By: mson77
  Help - Tuning query
By: orasaket on Fri, 24 August 2007
5 2269 Wed, 05 September 2007 19:16
By: mson77
  Which is memory set to shared pool?
By: trantuananh24hg on Tue, 04 September 2007
6 3961 Wed, 05 September 2007 10:15
By: DreamzZ
  netstat| grep 1522| wc -l
By: nonstopkaran on Wed, 05 September 2007
0 8421 Wed, 05 September 2007 01:47
By: nonstopkaran
  db_cache_size - correct size
By: rons on Mon, 13 August 2007
11 16266 Tue, 04 September 2007 07:14
By: Michel Cadot
  shared memory realm already exists
By: alexia_net on Fri, 24 August 2007
12 4523 Tue, 04 September 2007 04:02
By: trantuananh24hg
  Hash join vs NL join
By: beetel on Mon, 03 September 2007
6 4581 Mon, 03 September 2007 12:00
By: beetel
icon3.gif Database is slow.
By: sanjay_kant on Sun, 02 September 2007
5 3508 Sun, 02 September 2007 23:08
By: pablolee
  Duplicating ** million record table
By: fakhar55 on Sun, 02 September 2007
1 2703 Sun, 02 September 2007 08:29
By: muzahid
  warning message
By: vasudevan on Thu, 23 August 2007
1 1816 Fri, 31 August 2007 13:54
By: S.Rajaram
  rebuilding index
By: adee_saleh on Thu, 28 June 2007
17 15770 Wed, 29 August 2007 22:03
By: rleishman
  slow in scanning documents
By: vasudevan on Tue, 28 August 2007
1 1968 Wed, 29 August 2007 08:22
By: vasudevan
  CBO vs RBO
By: rubhatta on Tue, 28 August 2007
4 3012 Tue, 28 August 2007 14:04
By: DreamzZ
  Output of Query is very slow through SQL
By: sarfraz_attari on Tue, 28 August 2007
3 2141 Tue, 28 August 2007 08:22
By: Michel Cadot
  DBMS_APPLICATION_INFO Usage
By: orasaket on Fri, 24 August 2007
1 2361 Fri, 24 August 2007 08:07
By: rleishman
  about add more cpus..
By: hot3b3c on Fri, 24 August 2007
2 1990 Fri, 24 August 2007 05:25
By: JRowbottom
  Baby Tuning !!!
By: Creems on Thu, 23 August 2007
1 1758 Thu, 23 August 2007 15:41
By: DreamzZ
  Too much IO
By: marrec on Mon, 20 August 2007
3 2208 Thu, 23 August 2007 06:42
By: JRowbottom
  Help-Histogram
By: orasaket on Sun, 19 August 2007
3 3077 Thu, 23 August 2007 03:14
By: rleishman
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 04 15:34:30 CST 2024