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

    Replies Views Last message
  Sql slow query plan
By: vasudevan on Wed, 12 September 2007
1 1312 Wed, 12 September 2007 10:35
By: Michel Cadot
  Too much memory consumed in SGA
By: rrodriguez56 on Mon, 10 September 2007
2 6504 Wed, 12 September 2007 10:19
By: rrodriguez56
  SMON TOP PROCESS
By: pag63 on Wed, 12 September 2007
1 10477 Wed, 12 September 2007 09:33
By: MarcL
  DB_Cache_Hit Ratio less than 70
By: tkmittal1 on Tue, 11 September 2007
16 2141 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 1823 Wed, 12 September 2007 01:10
By: Michel Cadot
  Trying to tune a query.
By: galan_josel on Mon, 10 September 2007
6 2079 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 2610 Tue, 11 September 2007 05:36
By: alexia_net
  a lot of rollback problem
By: thorin666 on Mon, 10 September 2007
3 1311 Tue, 11 September 2007 04:55
By: Michel Cadot
  How many connection are on line
By: alexia_net on Tue, 11 September 2007
3 1184 Tue, 11 September 2007 04:17
By: alexia_net
  CPU usage has been 100% consistently
By: sreehari on Thu, 16 August 2007
6 3417 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 2638 Tue, 11 September 2007 01:26
By: Arju
  Too many redo log file (merged)
By: vikeshcool@hotmail.com on Thu, 06 September 2007
10 2167 Mon, 10 September 2007 23:15
By: BlackSwan
  Table lock Blocking
By: kflee2000 on Sun, 09 September 2007
5 2063 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 2193 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 1691 Sun, 09 September 2007 10:46
By: mson77
  Instance Efficiency
By: vasudevan on Fri, 07 September 2007
4 2798 Fri, 07 September 2007 13:02
By: Michel Cadot
  Procedure Tuning
By: yashora on Thu, 06 September 2007
6 1894 Thu, 06 September 2007 22:01
By: rleishman
  Oracle10g 10.0.2.0.1 Performance Problems
By: geonet on Mon, 27 August 2007
18 5277 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 1655 Wed, 05 September 2007 23:29
By: mson77
icon6.gif STATSPACK ANALYSIS TOOL
By: navaneethdba on Wed, 01 August 2007
7 14543 Wed, 05 September 2007 23:19
By: mson77
  Help - Tuning query
By: orasaket on Fri, 24 August 2007
5 1879 Wed, 05 September 2007 19:16
By: mson77
  Which is memory set to shared pool?
By: trantuananh24hg on Tue, 04 September 2007
6 2511 Wed, 05 September 2007 10:15
By: DreamzZ
  netstat| grep 1522| wc -l
By: nonstopkaran on Wed, 05 September 2007
0 7861 Wed, 05 September 2007 01:47
By: nonstopkaran
  db_cache_size - correct size
By: rons on Mon, 13 August 2007
11 15880 Tue, 04 September 2007 07:14
By: Michel Cadot
  shared memory realm already exists
By: alexia_net on Fri, 24 August 2007
12 4008 Tue, 04 September 2007 04:02
By: trantuananh24hg
  Hash join vs NL join
By: beetel on Mon, 03 September 2007
6 3278 Mon, 03 September 2007 12:00
By: beetel
icon3.gif Database is slow.
By: sanjay_kant on Sun, 02 September 2007
5 2556 Sun, 02 September 2007 23:08
By: pablolee
  Duplicating ** million record table
By: fakhar55 on Sun, 02 September 2007
1 2039 Sun, 02 September 2007 08:29
By: muzahid
  warning message
By: vasudevan on Thu, 23 August 2007
1 1290 Fri, 31 August 2007 13:54
By: S.Rajaram
  rebuilding index
By: adee_saleh on Thu, 28 June 2007
17 15183 Wed, 29 August 2007 22:03
By: rleishman
  slow in scanning documents
By: vasudevan on Tue, 28 August 2007
1 1628 Wed, 29 August 2007 08:22
By: vasudevan
  CBO vs RBO
By: rubhatta on Tue, 28 August 2007
4 2242 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 1280 Tue, 28 August 2007 08:22
By: Michel Cadot
  DBMS_APPLICATION_INFO Usage
By: orasaket on Fri, 24 August 2007
1 2108 Fri, 24 August 2007 08:07
By: rleishman
  about add more cpus..
By: hot3b3c on Fri, 24 August 2007
2 1276 Fri, 24 August 2007 05:25
By: JRowbottom
  Baby Tuning !!!
By: Creems on Thu, 23 August 2007
1 1284 Thu, 23 August 2007 15:41
By: DreamzZ
  Too much IO
By: marrec on Mon, 20 August 2007
3 1351 Thu, 23 August 2007 06:42
By: JRowbottom
  Help-Histogram
By: orasaket on Sun, 19 August 2007
3 2722 Thu, 23 August 2007 03:14
By: rleishman
  How to Ping (keep) table in db_keep_cache
By: aslamkhalife on Wed, 22 August 2007
2 4897 Wed, 22 August 2007 03:46
By: aslamkhalife
  AWR snap_id sequence
By: adam15612 on Mon, 20 August 2007
6 3646 Mon, 20 August 2007 13:57
By: adam15612
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: Wed May 15 22:51:17 CDT 2024