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

    Replies Views Last message
icon5.gif Getting a list of commonly used views for finding tuning statistics
By: ldebro on Thu, 12 January 2006
1 2422 Fri, 13 January 2006 07:32
By: Mahesh Rajendran
  long scans and short scans
By: alanm on Thu, 22 December 2005
10 5797 Tue, 10 January 2006 12:47
By: SQLAREA
  ORACLE TUNING PROBLEM ON LAPTOP
By: gaupa on Mon, 02 January 2006
5 4478 Tue, 10 January 2006 10:56
By: smartin
  Plan-table
By: IA on Sun, 08 January 2006
1 2146 Tue, 10 January 2006 10:50
By: smartin
  Poor performance database.. pls help me
By: genialsenthil on Thu, 24 November 2005
16 5742 Sun, 08 January 2006 10:26
By: SQLAREA
  shared pool doubt..?
By: balavignesh on Wed, 04 January 2006
3 3020 Sun, 08 January 2006 06:32
By: SQLAREA
  COMPLEX SQL,NESTED
By: feroze on Fri, 06 January 2006
9 2608 Sat, 07 January 2006 00:02
By: Frank
  perfstat report - explanation please
By: alanm on Wed, 04 January 2006
2 6554 Thu, 05 January 2006 03:11
By: alanm
  Improve performance with MV
By: AlinaC on Tue, 03 January 2006
2 2392 Wed, 04 January 2006 06:27
By: wpaillan
  long and short table scans
By: alanm on Tue, 03 January 2006
2 4684 Tue, 03 January 2006 08:36
By: alanm
  Inlist operator performance
By: mjschwenger on Wed, 28 December 2005
7 5476 Sun, 01 January 2006 15:31
By: mchadder
  Shrinking Index tablespace
By: toshidas2000 on Wed, 28 December 2005
3 4276 Sat, 31 December 2005 23:34
By: waseem_aijaz
  Turn Logging on, on Index
By: toshidas2000 on Wed, 28 December 2005
1 2050 Sat, 31 December 2005 23:26
By: waseem_aijaz
  Error In Analyzing Table (Ora-03114 & ORA-00603)
By: weekend79 on Sat, 31 December 2005
1 7495 Sat, 31 December 2005 23:11
By: waseem_aijaz
  help calculating freelist groups
By: mjschwenger on Fri, 30 December 2005
0 3549 Fri, 30 December 2005 20:31
By: mjschwenger
icon8.gif Show remain cpu time to end Query in OEM
By: luchino75 on Thu, 29 December 2005
2 2176 Fri, 30 December 2005 04:06
By: luchino75
  ORA-12015: cannot create a fast refresh snapshot from a complex query
By: sgv_0226 on Wed, 28 December 2005
1 19349 Wed, 28 December 2005 09:46
By: wpaillan
  query waits
By: mjschwenger on Wed, 21 December 2005
7 2520 Tue, 27 December 2005 12:24
By: smartin
  Diff Between Utlxplp.sql and Utlxpls.sql Scripts
By: krajkumar on Sat, 24 December 2005
3 3927 Tue, 27 December 2005 08:07
By: smartin
icon5.gif spfile tunning help!!!
By: 760613 on Sun, 25 December 2005
1 1900 Tue, 27 December 2005 08:01
By: smartin
  Interview Qstns
By: toughguy786 on Mon, 26 December 2005
0 3447 Mon, 26 December 2005 14:36
By: toughguy786
  how to change snapshot timings
By: ravivkumar on Sun, 25 December 2005
1 1932 Mon, 26 December 2005 11:11
By: vjeedigunta
  Tuning of Select for a View in Report
By: feroze on Mon, 12 December 2005
10 4253 Thu, 22 December 2005 14:34
By: smartin
  suggest
By: sethybibeka on Thu, 22 December 2005
0 3220 Thu, 22 December 2005 07:31
By: sethybibeka
  Analyzing indexes...
By: kinjal on Wed, 21 December 2005
2 2394 Wed, 21 December 2005 11:58
By: smartin
  ORA-00604: error occurred at recursive SQL level 1 ORA-04031
By: janeshb on Wed, 21 December 2005
4 36154 Wed, 21 December 2005 07:58
By: janeshb
  Finding it impossible to tune this query
By: hututu on Tue, 20 December 2005
3 2376 Wed, 21 December 2005 02:05
By: ChrisJr
  Solaris vs. Windows performance difference
By: jeffeben on Mon, 19 December 2005
1 3046 Mon, 19 December 2005 14:12
By: smartin
  correlated subquery taking a long time to execute
By: vgs2005 on Wed, 14 December 2005
4 3061 Mon, 19 December 2005 09:44
By: smartin
icon5.gif Query using bind variable is slower??
By: claymentlim on Mon, 19 December 2005
1 3939 Mon, 19 December 2005 02:14
By: rleishman
  full table scan
By: alka205 on Thu, 17 November 2005
15 7864 Thu, 15 December 2005 19:49
By: humair77
  when do I need to create an indexes.
By: cuisia on Thu, 15 December 2005
4 2610 Thu, 15 December 2005 19:20
By: cuisia
  query optimization
By: Rajesh Joshi on Thu, 15 December 2005
3 2614 Thu, 15 December 2005 09:52
By: Art Metzer
icon5.gif my application is too slow.
By: cuisia on Wed, 14 December 2005
2 2451 Thu, 15 December 2005 09:43
By: smartin
  oracle 10g cbo slower than rbo
By: lazycat on Tue, 13 December 2005
6 7253 Thu, 15 December 2005 09:38
By: smartin
  SQL - very slow response
By: avi123india on Sat, 10 December 2005
4 5261 Wed, 14 December 2005 02:08
By: rleishman
  Interesting predicate found in explain plan
By: smartin on Wed, 07 December 2005
8 2717 Mon, 12 December 2005 10:23
By: smartin
icon5.gif How to tune a sql query to make it run faster ...
By: amankhan on Sat, 10 December 2005
3 4147 Mon, 12 December 2005 01:25
By: rleishman
  Tablespace increase - Which is Optimum Method.
By: Jegathees on Thu, 08 December 2005
1 2459 Fri, 09 December 2005 06:50
By: Mahesh Rajendran
  Performance of the sql due to group by
By: raghuraja_r on Wed, 07 December 2005
1 2306 Thu, 08 December 2005 00:20
By: Frank
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 Nov 27 05:32:45 CST 2024