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

    Replies Views Last message
icon8.gif Show remain cpu time to end Query in OEM
By: luchino75 on Thu, 29 December 2005
2 951 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 18047 Wed, 28 December 2005 09:46
By: wpaillan
  query waits
By: mjschwenger on Wed, 21 December 2005
7 1266 Tue, 27 December 2005 12:24
By: smartin
  Diff Between Utlxplp.sql and Utlxpls.sql Scripts
By: krajkumar on Sat, 24 December 2005
3 2447 Tue, 27 December 2005 08:07
By: smartin
icon5.gif spfile tunning help!!!
By: 760613 on Sun, 25 December 2005
1 958 Tue, 27 December 2005 08:01
By: smartin
  Interview Qstns
By: toughguy786 on Mon, 26 December 2005
0 2500 Mon, 26 December 2005 14:36
By: toughguy786
  how to change snapshot timings
By: ravivkumar on Sun, 25 December 2005
1 841 Mon, 26 December 2005 11:11
By: vjeedigunta
  Tuning of Select for a View in Report
By: feroze on Mon, 12 December 2005
10 2970 Thu, 22 December 2005 14:34
By: smartin
  suggest
By: sethybibeka on Thu, 22 December 2005
0 2192 Thu, 22 December 2005 07:31
By: sethybibeka
  Analyzing indexes...
By: kinjal on Wed, 21 December 2005
2 1162 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 34070 Wed, 21 December 2005 07:58
By: janeshb
  Finding it impossible to tune this query
By: hututu on Tue, 20 December 2005
3 1156 Wed, 21 December 2005 02:05
By: ChrisJr
  Solaris vs. Windows performance difference
By: jeffeben on Mon, 19 December 2005
1 2138 Mon, 19 December 2005 14:12
By: smartin
  correlated subquery taking a long time to execute
By: vgs2005 on Wed, 14 December 2005
4 1952 Mon, 19 December 2005 09:44
By: smartin
icon5.gif Query using bind variable is slower??
By: claymentlim on Mon, 19 December 2005
1 2584 Mon, 19 December 2005 02:14
By: rleishman
  full table scan
By: alka205 on Thu, 17 November 2005
15 4064 Thu, 15 December 2005 19:49
By: humair77
  when do I need to create an indexes.
By: cuisia on Thu, 15 December 2005
4 1300 Thu, 15 December 2005 19:20
By: cuisia
  query optimization
By: Rajesh Joshi on Thu, 15 December 2005
3 1573 Thu, 15 December 2005 09:52
By: Art Metzer
icon5.gif my application is too slow.
By: cuisia on Wed, 14 December 2005
2 989 Thu, 15 December 2005 09:43
By: smartin
  oracle 10g cbo slower than rbo
By: lazycat on Tue, 13 December 2005
6 5083 Thu, 15 December 2005 09:38
By: smartin
  SQL - very slow response
By: avi123india on Sat, 10 December 2005
4 3458 Wed, 14 December 2005 02:08
By: rleishman
  Interesting predicate found in explain plan
By: smartin on Wed, 07 December 2005
8 1391 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 2369 Mon, 12 December 2005 01:25
By: rleishman
  Tablespace increase - Which is Optimum Method.
By: Jegathees on Thu, 08 December 2005
1 1136 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 1065 Thu, 08 December 2005 00:20
By: Frank
  Explain Plan (Query Transformation)
By: dhar_kiran on Mon, 05 December 2005
8 1423 Wed, 07 December 2005 11:16
By: mchadder
  Database Performance Tuning
By: chenchireddy on Wed, 07 December 2005
1 3055 Wed, 07 December 2005 06:58
By: Art Metzer
  Automatic Workload Repository(AWR) and ADDM
By: pzlj6x on Tue, 06 December 2005
3 1458 Tue, 06 December 2005 15:42
By: smartin
  Difference in the plan output
By: bella13 on Tue, 06 December 2005
4 2316 Tue, 06 December 2005 13:30
By: smartin
  tkprof different types of sort
By: toshidas2000 on Mon, 05 December 2005
2 1166 Tue, 06 December 2005 00:40
By: Frank
  Explain Plan
By: dhar_kiran on Fri, 02 December 2005
6 2851 Tue, 06 December 2005 00:38
By: Frank
  Script Needed -- SQL Statements - Performance Tuning
By: reachriah on Mon, 28 November 2005
3 1012 Mon, 05 December 2005 18:20
By: reachriah
  Performance tuning--- Automatic workload repository (AWR &ADDM)
By: reachriah on Sun, 04 December 2005
1 864 Mon, 05 December 2005 12:02
By: smartin
  Performance tuning without accessing real data
By: rrawasi on Thu, 24 November 2005
16 6607 Sat, 03 December 2005 03:31
By: rrawasi
  Query tuning
By: yram on Mon, 28 November 2005
3 964 Fri, 02 December 2005 03:32
By: yogeshse
  Help - ToTune This Query....
By: sameer9448 on Wed, 30 November 2005
3 944 Fri, 02 December 2005 01:01
By: Frank
  Perfomance problem with partition table
By: chandanbhamra on Mon, 28 November 2005
11 2281 Thu, 01 December 2005 15:17
By: smartin
  priority query
By: rkl1 on Sat, 26 November 2005
3 980 Wed, 30 November 2005 09:16
By: smartin
  hints on views
By: alka205 on Tue, 22 November 2005
4 1014 Wed, 30 November 2005 08:53
By: smartin
  Incorrect system statistics
By: wdavidsmc on Tue, 22 November 2005
1 723 Wed, 30 November 2005 08:48
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: Sat Aug 20 00:43:15 CDT 2022