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 2115 Wed, 12 September 2007 13:54
By: Michel Cadot
  lots of waits sql*net
By: thorin666 on Wed, 12 September 2007
2 2190 Wed, 12 September 2007 12:04
By: thorin666
  Sql slow query plan
By: vasudevan on Wed, 12 September 2007
1 1824 Wed, 12 September 2007 10:35
By: Michel Cadot
  Too much memory consumed in SGA
By: rrodriguez56 on Mon, 10 September 2007
2 7236 Wed, 12 September 2007 10:19
By: rrodriguez56
  SMON TOP PROCESS
By: pag63 on Wed, 12 September 2007
1 11135 Wed, 12 September 2007 09:33
By: MarcL
  DB_Cache_Hit Ratio less than 70
By: tkmittal1 on Tue, 11 September 2007
16 3742 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 2387 Wed, 12 September 2007 01:10
By: Michel Cadot
  Trying to tune a query.
By: galan_josel on Mon, 10 September 2007
6 3115 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 3270 Tue, 11 September 2007 05:36
By: alexia_net
  a lot of rollback problem
By: thorin666 on Mon, 10 September 2007
3 2407 Tue, 11 September 2007 04:55
By: Michel Cadot
  How many connection are on line
By: alexia_net on Tue, 11 September 2007
3 2084 Tue, 11 September 2007 04:17
By: alexia_net
  CPU usage has been 100% consistently
By: sreehari on Thu, 16 August 2007
6 4516 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 3634 Tue, 11 September 2007 01:26
By: Arju
  Too many redo log file (merged)
By: vikeshcool@hotmail.com on Thu, 06 September 2007
10 4197 Mon, 10 September 2007 23:15
By: BlackSwan
  Table lock Blocking
By: kflee2000 on Sun, 09 September 2007
5 2473 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 2531 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 2045 Sun, 09 September 2007 10:46
By: mson77
  Instance Efficiency
By: vasudevan on Fri, 07 September 2007
4 3270 Fri, 07 September 2007 13:02
By: Michel Cadot
  Procedure Tuning
By: yashora on Thu, 06 September 2007
6 3320 Thu, 06 September 2007 22:01
By: rleishman
  Oracle10g 10.0.2.0.1 Performance Problems
By: geonet on Mon, 27 August 2007
18 5972 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 2272 Wed, 05 September 2007 23:29
By: mson77
icon6.gif STATSPACK ANALYSIS TOOL
By: navaneethdba on Wed, 01 August 2007
7 16214 Wed, 05 September 2007 23:19
By: mson77
  Help - Tuning query
By: orasaket on Fri, 24 August 2007
5 2298 Wed, 05 September 2007 19:16
By: mson77
  Which is memory set to shared pool?
By: trantuananh24hg on Tue, 04 September 2007
6 3993 Wed, 05 September 2007 10:15
By: DreamzZ
  netstat| grep 1522| wc -l
By: nonstopkaran on Wed, 05 September 2007
0 8456 Wed, 05 September 2007 01:47
By: nonstopkaran
  db_cache_size - correct size
By: rons on Mon, 13 August 2007
11 16316 Tue, 04 September 2007 07:14
By: Michel Cadot
  shared memory realm already exists
By: alexia_net on Fri, 24 August 2007
12 4553 Tue, 04 September 2007 04:02
By: trantuananh24hg
  Hash join vs NL join
By: beetel on Mon, 03 September 2007
6 4609 Mon, 03 September 2007 12:00
By: beetel
icon3.gif Database is slow.
By: sanjay_kant on Sun, 02 September 2007
5 3537 Sun, 02 September 2007 23:08
By: pablolee
  Duplicating ** million record table
By: fakhar55 on Sun, 02 September 2007
1 2722 Sun, 02 September 2007 08:29
By: muzahid
  warning message
By: vasudevan on Thu, 23 August 2007
1 1835 Fri, 31 August 2007 13:54
By: S.Rajaram
  rebuilding index
By: adee_saleh on Thu, 28 June 2007
17 15810 Wed, 29 August 2007 22:03
By: rleishman
  slow in scanning documents
By: vasudevan on Tue, 28 August 2007
1 1986 Wed, 29 August 2007 08:22
By: vasudevan
  CBO vs RBO
By: rubhatta on Tue, 28 August 2007
4 3035 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 2162 Tue, 28 August 2007 08:22
By: Michel Cadot
  DBMS_APPLICATION_INFO Usage
By: orasaket on Fri, 24 August 2007
1 2388 Fri, 24 August 2007 08:07
By: rleishman
  about add more cpus..
By: hot3b3c on Fri, 24 August 2007
2 2012 Fri, 24 August 2007 05:25
By: JRowbottom
  Baby Tuning !!!
By: Creems on Thu, 23 August 2007
1 1780 Thu, 23 August 2007 15:41
By: DreamzZ
  Too much IO
By: marrec on Mon, 20 August 2007
3 2227 Thu, 23 August 2007 06:42
By: JRowbottom
  Help-Histogram
By: orasaket on Sun, 19 August 2007
3 3097 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: Thu Jan 23 01:37:09 CST 2025