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

    Replies Views Last message
  V$LibraryCache
By: dhar_kiran on Tue, 17 January 2006
1 681 Wed, 18 January 2006 03:57
By: Mahesh Rajendran
  Sorting a trace file using TKPROF
By: guyj on Thu, 12 January 2006
8 1310 Mon, 16 January 2006 22:43
By: guyj
icon5.gif Getting a list of commonly used views for finding tuning statistics
By: ldebro on Thu, 12 January 2006
1 758 Fri, 13 January 2006 07:32
By: Mahesh Rajendran
  long scans and short scans
By: alanm on Thu, 22 December 2005
10 2077 Tue, 10 January 2006 12:47
By: SQLAREA
  ORACLE TUNING PROBLEM ON LAPTOP
By: gaupa on Mon, 02 January 2006
5 2129 Tue, 10 January 2006 10:56
By: smartin
  Plan-table
By: IA on Sun, 08 January 2006
1 670 Tue, 10 January 2006 10:50
By: smartin
  Poor performance database.. pls help me
By: genialsenthil on Thu, 24 November 2005
16 3462 Sun, 08 January 2006 10:26
By: SQLAREA
  shared pool doubt..?
By: balavignesh on Wed, 04 January 2006
3 957 Sun, 08 January 2006 06:32
By: SQLAREA
  COMPLEX SQL,NESTED
By: feroze on Fri, 06 January 2006
9 1125 Sat, 07 January 2006 00:02
By: Frank
  perfstat report - explanation please
By: alanm on Wed, 04 January 2006
2 5062 Thu, 05 January 2006 03:11
By: alanm
  Improve performance with MV
By: AlinaC on Tue, 03 January 2006
2 798 Wed, 04 January 2006 06:27
By: wpaillan
  long and short table scans
By: alanm on Tue, 03 January 2006
2 2614 Tue, 03 January 2006 08:36
By: alanm
  Inlist operator performance
By: mjschwenger on Wed, 28 December 2005
7 3915 Sun, 01 January 2006 15:31
By: mchadder
  Shrinking Index tablespace
By: toshidas2000 on Wed, 28 December 2005
3 2310 Sat, 31 December 2005 23:34
By: waseem_aijaz
  Turn Logging on, on Index
By: toshidas2000 on Wed, 28 December 2005
1 801 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 6012 Sat, 31 December 2005 23:11
By: waseem_aijaz
  help calculating freelist groups
By: mjschwenger on Fri, 30 December 2005
0 2362 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 774 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 17590 Wed, 28 December 2005 09:46
By: wpaillan
  query waits
By: mjschwenger on Wed, 21 December 2005
7 1060 Tue, 27 December 2005 12:24
By: smartin
  Diff Between Utlxplp.sql and Utlxpls.sql Scripts
By: krajkumar on Sat, 24 December 2005
3 2281 Tue, 27 December 2005 08:07
By: smartin
icon5.gif spfile tunning help!!!
By: 760613 on Sun, 25 December 2005
1 777 Tue, 27 December 2005 08:01
By: smartin
  Interview Qstns
By: toughguy786 on Mon, 26 December 2005
0 2324 Mon, 26 December 2005 14:36
By: toughguy786
  how to change snapshot timings
By: ravivkumar on Sun, 25 December 2005
1 663 Mon, 26 December 2005 11:11
By: vjeedigunta
  Tuning of Select for a View in Report
By: feroze on Mon, 12 December 2005
10 2704 Thu, 22 December 2005 14:34
By: smartin
  suggest
By: sethybibeka on Thu, 22 December 2005
0 2053 Thu, 22 December 2005 07:31
By: sethybibeka
  Analyzing indexes...
By: kinjal on Wed, 21 December 2005
2 986 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 33681 Wed, 21 December 2005 07:58
By: janeshb
  Finding it impossible to tune this query
By: hututu on Tue, 20 December 2005
3 959 Wed, 21 December 2005 02:05
By: ChrisJr
  Solaris vs. Windows performance difference
By: jeffeben on Mon, 19 December 2005
1 1943 Mon, 19 December 2005 14:12
By: smartin
  correlated subquery taking a long time to execute
By: vgs2005 on Wed, 14 December 2005
4 1675 Mon, 19 December 2005 09:44
By: smartin
icon5.gif Query using bind variable is slower??
By: claymentlim on Mon, 19 December 2005
1 2395 Mon, 19 December 2005 02:14
By: rleishman
  full table scan
By: alka205 on Thu, 17 November 2005
15 3731 Thu, 15 December 2005 19:49
By: humair77
  when do I need to create an indexes.
By: cuisia on Thu, 15 December 2005
4 977 Thu, 15 December 2005 19:20
By: cuisia
  query optimization
By: Rajesh Joshi on Thu, 15 December 2005
3 1239 Thu, 15 December 2005 09:52
By: Art Metzer
icon5.gif my application is too slow.
By: cuisia on Wed, 14 December 2005
2 774 Thu, 15 December 2005 09:43
By: smartin
  oracle 10g cbo slower than rbo
By: lazycat on Tue, 13 December 2005
6 4826 Thu, 15 December 2005 09:38
By: smartin
  SQL - very slow response
By: avi123india on Sat, 10 December 2005
4 3003 Wed, 14 December 2005 02:08
By: rleishman
  Interesting predicate found in explain plan
By: smartin on Wed, 07 December 2005
8 1158 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 1866 Mon, 12 December 2005 01:25
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: Sat Sep 19 07:37:40 CDT 2020