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

    Replies Views Last message
  TIMED_STATISTICS parameter
By: tanmoy1048 on Thu, 13 September 2007
2 2220 Thu, 13 September 2007 04:57
By: tanmoy1048
  How to rebuild indexes
By: coolboy2005in on Wed, 12 September 2007
1 1782 Thu, 13 September 2007 00:03
By: Michel Cadot
  Module in Statspack Report
By: kumarsz on Wed, 12 September 2007
3 2406 Wed, 12 September 2007 13:54
By: Michel Cadot
  lots of waits sql*net
By: thorin666 on Wed, 12 September 2007
2 2441 Wed, 12 September 2007 12:04
By: thorin666
  Sql slow query plan
By: vasudevan on Wed, 12 September 2007
1 2026 Wed, 12 September 2007 10:35
By: Michel Cadot
  Too much memory consumed in SGA
By: rrodriguez56 on Mon, 10 September 2007
2 7579 Wed, 12 September 2007 10:19
By: rrodriguez56
  SMON TOP PROCESS
By: pag63 on Wed, 12 September 2007
1 11334 Wed, 12 September 2007 09:33
By: MarcL
  DB_Cache_Hit Ratio less than 70
By: tkmittal1 on Tue, 11 September 2007
16 4436 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 2689 Wed, 12 September 2007 01:10
By: Michel Cadot
  Trying to tune a query.
By: galan_josel on Mon, 10 September 2007
6 3446 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 3765 Tue, 11 September 2007 05:36
By: alexia_net
  a lot of rollback problem
By: thorin666 on Mon, 10 September 2007
3 2689 Tue, 11 September 2007 04:55
By: Michel Cadot
  How many connection are on line
By: alexia_net on Tue, 11 September 2007
3 2344 Tue, 11 September 2007 04:17
By: alexia_net
  CPU usage has been 100% consistently
By: sreehari on Thu, 16 August 2007
6 4895 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 3993 Tue, 11 September 2007 01:26
By: Arju
  Too many redo log file (merged)
By: vikeshcool@hotmail.com on Thu, 06 September 2007
10 4678 Mon, 10 September 2007 23:15
By: BlackSwan
  Table lock Blocking
By: kflee2000 on Sun, 09 September 2007
5 2833 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 2944 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 2458 Sun, 09 September 2007 10:46
By: mson77
  Instance Efficiency
By: vasudevan on Fri, 07 September 2007
4 3691 Fri, 07 September 2007 13:02
By: Michel Cadot
  Procedure Tuning
By: yashora on Thu, 06 September 2007
6 3825 Thu, 06 September 2007 22:01
By: rleishman
  Oracle10g 10.0.2.0.1 Performance Problems
By: geonet on Mon, 27 August 2007
18 6991 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 2561 Wed, 05 September 2007 23:29
By: mson77
icon6.gif STATSPACK ANALYSIS TOOL
By: navaneethdba on Wed, 01 August 2007
7 16626 Wed, 05 September 2007 23:19
By: mson77
  Help - Tuning query
By: orasaket on Fri, 24 August 2007
5 2730 Wed, 05 September 2007 19:16
By: mson77
  Which is memory set to shared pool?
By: trantuananh24hg on Tue, 04 September 2007
6 4383 Wed, 05 September 2007 10:15
By: DreamzZ
  netstat| grep 1522| wc -l
By: nonstopkaran on Wed, 05 September 2007
0 8666 Wed, 05 September 2007 01:47
By: nonstopkaran
  db_cache_size - correct size
By: rons on Mon, 13 August 2007
11 17013 Tue, 04 September 2007 07:14
By: Michel Cadot
  shared memory realm already exists
By: alexia_net on Fri, 24 August 2007
12 5089 Tue, 04 September 2007 04:02
By: trantuananh24hg
  Hash join vs NL join
By: beetel on Mon, 03 September 2007
6 5037 Mon, 03 September 2007 12:00
By: beetel
icon3.gif Database is slow.
By: sanjay_kant on Sun, 02 September 2007
5 4005 Sun, 02 September 2007 23:08
By: pablolee
  Duplicating ** million record table
By: fakhar55 on Sun, 02 September 2007
1 2955 Sun, 02 September 2007 08:29
By: muzahid
  warning message
By: vasudevan on Thu, 23 August 2007
1 2020 Fri, 31 August 2007 13:54
By: S.Rajaram
  rebuilding index
By: adee_saleh on Thu, 28 June 2007
17 16523 Wed, 29 August 2007 22:03
By: rleishman
  slow in scanning documents
By: vasudevan on Tue, 28 August 2007
1 2221 Wed, 29 August 2007 08:22
By: vasudevan
  CBO vs RBO
By: rubhatta on Tue, 28 August 2007
4 3411 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 2424 Tue, 28 August 2007 08:22
By: Michel Cadot
  DBMS_APPLICATION_INFO Usage
By: orasaket on Fri, 24 August 2007
1 2691 Fri, 24 August 2007 08:07
By: rleishman
  about add more cpus..
By: hot3b3c on Fri, 24 August 2007
2 2227 Fri, 24 August 2007 05:25
By: JRowbottom
  Baby Tuning !!!
By: Creems on Thu, 23 August 2007
1 1964 Thu, 23 August 2007 15:41
By: DreamzZ
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 Oct 02 14:23:27 CDT 2025