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

    Replies Views Last message
  Plan-table
By: IA on Sun, 08 January 2006
1 1275 Tue, 10 January 2006 10:50
By: smartin
  Poor performance database.. pls help me
By: genialsenthil on Thu, 24 November 2005
16 4192 Sun, 08 January 2006 10:26
By: SQLAREA
  shared pool doubt..?
By: balavignesh on Wed, 04 January 2006
3 1662 Sun, 08 January 2006 06:32
By: SQLAREA
  COMPLEX SQL,NESTED
By: feroze on Fri, 06 January 2006
9 2004 Sat, 07 January 2006 00:02
By: Frank
  perfstat report - explanation please
By: alanm on Wed, 04 January 2006
2 5720 Thu, 05 January 2006 03:11
By: alanm
  Improve performance with MV
By: AlinaC on Tue, 03 January 2006
2 1395 Wed, 04 January 2006 06:27
By: wpaillan
  long and short table scans
By: alanm on Tue, 03 January 2006
2 3365 Tue, 03 January 2006 08:36
By: alanm
  Inlist operator performance
By: mjschwenger on Wed, 28 December 2005
7 4713 Sun, 01 January 2006 15:31
By: mchadder
  Shrinking Index tablespace
By: toshidas2000 on Wed, 28 December 2005
3 3049 Sat, 31 December 2005 23:34
By: waseem_aijaz
  Turn Logging on, on Index
By: toshidas2000 on Wed, 28 December 2005
1 1356 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 6755 Sat, 31 December 2005 23:11
By: waseem_aijaz
  help calculating freelist groups
By: mjschwenger on Fri, 30 December 2005
0 2880 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 1365 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 18758 Wed, 28 December 2005 09:46
By: wpaillan
  query waits
By: mjschwenger on Wed, 21 December 2005
7 1952 Tue, 27 December 2005 12:24
By: smartin
  Diff Between Utlxplp.sql and Utlxpls.sql Scripts
By: krajkumar on Sat, 24 December 2005
3 2876 Tue, 27 December 2005 08:07
By: smartin
icon5.gif spfile tunning help!!!
By: 760613 on Sun, 25 December 2005
1 1387 Tue, 27 December 2005 08:01
By: smartin
  Interview Qstns
By: toughguy786 on Mon, 26 December 2005
0 2908 Mon, 26 December 2005 14:36
By: toughguy786
  how to change snapshot timings
By: ravivkumar on Sun, 25 December 2005
1 1238 Mon, 26 December 2005 11:11
By: vjeedigunta
  Tuning of Select for a View in Report
By: feroze on Mon, 12 December 2005
10 3482 Thu, 22 December 2005 14:34
By: smartin
  suggest
By: sethybibeka on Thu, 22 December 2005
0 2553 Thu, 22 December 2005 07:31
By: sethybibeka
  Analyzing indexes...
By: kinjal on Wed, 21 December 2005
2 1577 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 34692 Wed, 21 December 2005 07:58
By: janeshb
  Finding it impossible to tune this query
By: hututu on Tue, 20 December 2005
3 1555 Wed, 21 December 2005 02:05
By: ChrisJr
  Solaris vs. Windows performance difference
By: jeffeben on Mon, 19 December 2005
1 2555 Mon, 19 December 2005 14:12
By: smartin
  correlated subquery taking a long time to execute
By: vgs2005 on Wed, 14 December 2005
4 2554 Mon, 19 December 2005 09:44
By: smartin
icon5.gif Query using bind variable is slower??
By: claymentlim on Mon, 19 December 2005
1 3093 Mon, 19 December 2005 02:14
By: rleishman
  full table scan
By: alka205 on Thu, 17 November 2005
15 4902 Thu, 15 December 2005 19:49
By: humair77
  when do I need to create an indexes.
By: cuisia on Thu, 15 December 2005
4 1759 Thu, 15 December 2005 19:20
By: cuisia
  query optimization
By: Rajesh Joshi on Thu, 15 December 2005
3 2176 Thu, 15 December 2005 09:52
By: Art Metzer
icon5.gif my application is too slow.
By: cuisia on Wed, 14 December 2005
2 1445 Thu, 15 December 2005 09:43
By: smartin
  oracle 10g cbo slower than rbo
By: lazycat on Tue, 13 December 2005
6 5675 Thu, 15 December 2005 09:38
By: smartin
  SQL - very slow response
By: avi123india on Sat, 10 December 2005
4 4195 Wed, 14 December 2005 02:08
By: rleishman
  Interesting predicate found in explain plan
By: smartin on Wed, 07 December 2005
8 2140 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 3128 Mon, 12 December 2005 01:25
By: rleishman
  Tablespace increase - Which is Optimum Method.
By: Jegathees on Thu, 08 December 2005
1 1631 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 1465 Thu, 08 December 2005 00:20
By: Frank
  Explain Plan (Query Transformation)
By: dhar_kiran on Mon, 05 December 2005
8 2034 Wed, 07 December 2005 11:16
By: mchadder
  Database Performance Tuning
By: chenchireddy on Wed, 07 December 2005
1 3510 Wed, 07 December 2005 06:58
By: Art Metzer
  Automatic Workload Repository(AWR) and ADDM
By: pzlj6x on Tue, 06 December 2005
3 1897 Tue, 06 December 2005 15:42
By: smartin
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 Mar 19 05:10:54 CDT 2024