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

    Replies Views Last message
  ORACLE TUNING PROBLEM ON LAPTOP
By: gaupa on Mon, 02 January 2006
5 2858 Tue, 10 January 2006 10:56
By: smartin
  Plan-table
By: IA on Sun, 08 January 2006
1 1317 Tue, 10 January 2006 10:50
By: smartin
  Poor performance database.. pls help me
By: genialsenthil on Thu, 24 November 2005
16 4229 Sun, 08 January 2006 10:26
By: SQLAREA
  shared pool doubt..?
By: balavignesh on Wed, 04 January 2006
3 1705 Sun, 08 January 2006 06:32
By: SQLAREA
  COMPLEX SQL,NESTED
By: feroze on Fri, 06 January 2006
9 2048 Sat, 07 January 2006 00:02
By: Frank
  perfstat report - explanation please
By: alanm on Wed, 04 January 2006
2 5765 Thu, 05 January 2006 03:11
By: alanm
  Improve performance with MV
By: AlinaC on Tue, 03 January 2006
2 1436 Wed, 04 January 2006 06:27
By: wpaillan
  long and short table scans
By: alanm on Tue, 03 January 2006
2 3403 Tue, 03 January 2006 08:36
By: alanm
  Inlist operator performance
By: mjschwenger on Wed, 28 December 2005
7 4752 Sun, 01 January 2006 15:31
By: mchadder
  Shrinking Index tablespace
By: toshidas2000 on Wed, 28 December 2005
3 3096 Sat, 31 December 2005 23:34
By: waseem_aijaz
  Turn Logging on, on Index
By: toshidas2000 on Wed, 28 December 2005
1 1394 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 6788 Sat, 31 December 2005 23:11
By: waseem_aijaz
  help calculating freelist groups
By: mjschwenger on Fri, 30 December 2005
0 2917 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 1409 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 18814 Wed, 28 December 2005 09:46
By: wpaillan
  query waits
By: mjschwenger on Wed, 21 December 2005
7 1995 Tue, 27 December 2005 12:24
By: smartin
  Diff Between Utlxplp.sql and Utlxpls.sql Scripts
By: krajkumar on Sat, 24 December 2005
3 2920 Tue, 27 December 2005 08:07
By: smartin
icon5.gif spfile tunning help!!!
By: 760613 on Sun, 25 December 2005
1 1421 Tue, 27 December 2005 08:01
By: smartin
  Interview Qstns
By: toughguy786 on Mon, 26 December 2005
0 2937 Mon, 26 December 2005 14:36
By: toughguy786
  how to change snapshot timings
By: ravivkumar on Sun, 25 December 2005
1 1286 Mon, 26 December 2005 11:11
By: vjeedigunta
  Tuning of Select for a View in Report
By: feroze on Mon, 12 December 2005
10 3523 Thu, 22 December 2005 14:34
By: smartin
  suggest
By: sethybibeka on Thu, 22 December 2005
0 2588 Thu, 22 December 2005 07:31
By: sethybibeka
  Analyzing indexes...
By: kinjal on Wed, 21 December 2005
2 1611 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 34787 Wed, 21 December 2005 07:58
By: janeshb
  Finding it impossible to tune this query
By: hututu on Tue, 20 December 2005
3 1593 Wed, 21 December 2005 02:05
By: ChrisJr
  Solaris vs. Windows performance difference
By: jeffeben on Mon, 19 December 2005
1 2592 Mon, 19 December 2005 14:12
By: smartin
  correlated subquery taking a long time to execute
By: vgs2005 on Wed, 14 December 2005
4 2598 Mon, 19 December 2005 09:44
By: smartin
icon5.gif Query using bind variable is slower??
By: claymentlim on Mon, 19 December 2005
1 3135 Mon, 19 December 2005 02:14
By: rleishman
  full table scan
By: alka205 on Thu, 17 November 2005
15 4941 Thu, 15 December 2005 19:49
By: humair77
  when do I need to create an indexes.
By: cuisia on Thu, 15 December 2005
4 1801 Thu, 15 December 2005 19:20
By: cuisia
  query optimization
By: Rajesh Joshi on Thu, 15 December 2005
3 2217 Thu, 15 December 2005 09:52
By: Art Metzer
icon5.gif my application is too slow.
By: cuisia on Wed, 14 December 2005
2 1484 Thu, 15 December 2005 09:43
By: smartin
  oracle 10g cbo slower than rbo
By: lazycat on Tue, 13 December 2005
6 5715 Thu, 15 December 2005 09:38
By: smartin
  SQL - very slow response
By: avi123india on Sat, 10 December 2005
4 4232 Wed, 14 December 2005 02:08
By: rleishman
  Interesting predicate found in explain plan
By: smartin on Wed, 07 December 2005
8 2175 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 3162 Mon, 12 December 2005 01:25
By: rleishman
  Tablespace increase - Which is Optimum Method.
By: Jegathees on Thu, 08 December 2005
1 1665 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 1497 Thu, 08 December 2005 00:20
By: Frank
  Explain Plan (Query Transformation)
By: dhar_kiran on Mon, 05 December 2005
8 2084 Wed, 07 December 2005 11:16
By: mchadder
  Database Performance Tuning
By: chenchireddy on Wed, 07 December 2005
1 3545 Wed, 07 December 2005 06:58
By: Art Metzer
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: Tue Apr 23 14:54:35 CDT 2024