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 960 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 18058 Wed, 28 December 2005 09:46
By: wpaillan
  query waits
By: mjschwenger on Wed, 21 December 2005
7 1284 Tue, 27 December 2005 12:24
By: smartin
  Diff Between Utlxplp.sql and Utlxpls.sql Scripts
By: krajkumar on Sat, 24 December 2005
3 2460 Tue, 27 December 2005 08:07
By: smartin
icon5.gif spfile tunning help!!!
By: 760613 on Sun, 25 December 2005
1 970 Tue, 27 December 2005 08:01
By: smartin
  Interview Qstns
By: toughguy786 on Mon, 26 December 2005
0 2513 Mon, 26 December 2005 14:36
By: toughguy786
  how to change snapshot timings
By: ravivkumar on Sun, 25 December 2005
1 846 Mon, 26 December 2005 11:11
By: vjeedigunta
  Tuning of Select for a View in Report
By: feroze on Mon, 12 December 2005
10 2980 Thu, 22 December 2005 14:34
By: smartin
  suggest
By: sethybibeka on Thu, 22 December 2005
0 2200 Thu, 22 December 2005 07:31
By: sethybibeka
  Analyzing indexes...
By: kinjal on Wed, 21 December 2005
2 1174 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 34084 Wed, 21 December 2005 07:58
By: janeshb
  Finding it impossible to tune this query
By: hututu on Tue, 20 December 2005
3 1165 Wed, 21 December 2005 02:05
By: ChrisJr
  Solaris vs. Windows performance difference
By: jeffeben on Mon, 19 December 2005
1 2150 Mon, 19 December 2005 14:12
By: smartin
  correlated subquery taking a long time to execute
By: vgs2005 on Wed, 14 December 2005
4 1974 Mon, 19 December 2005 09:44
By: smartin
icon5.gif Query using bind variable is slower??
By: claymentlim on Mon, 19 December 2005
1 2593 Mon, 19 December 2005 02:14
By: rleishman
  full table scan
By: alka205 on Thu, 17 November 2005
15 4080 Thu, 15 December 2005 19:49
By: humair77
  when do I need to create an indexes.
By: cuisia on Thu, 15 December 2005
4 1307 Thu, 15 December 2005 19:20
By: cuisia
  query optimization
By: Rajesh Joshi on Thu, 15 December 2005
3 1603 Thu, 15 December 2005 09:52
By: Art Metzer
icon5.gif my application is too slow.
By: cuisia on Wed, 14 December 2005
2 999 Thu, 15 December 2005 09:43
By: smartin
  oracle 10g cbo slower than rbo
By: lazycat on Tue, 13 December 2005
6 5097 Thu, 15 December 2005 09:38
By: smartin
  SQL - very slow response
By: avi123india on Sat, 10 December 2005
4 3515 Wed, 14 December 2005 02:08
By: rleishman
  Interesting predicate found in explain plan
By: smartin on Wed, 07 December 2005
8 1407 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 2423 Mon, 12 December 2005 01:25
By: rleishman
  Tablespace increase - Which is Optimum Method.
By: Jegathees on Thu, 08 December 2005
1 1151 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 1072 Thu, 08 December 2005 00:20
By: Frank
  Explain Plan (Query Transformation)
By: dhar_kiran on Mon, 05 December 2005
8 1433 Wed, 07 December 2005 11:16
By: mchadder
  Database Performance Tuning
By: chenchireddy on Wed, 07 December 2005
1 3070 Wed, 07 December 2005 06:58
By: Art Metzer
  Automatic Workload Repository(AWR) and ADDM
By: pzlj6x on Tue, 06 December 2005
3 1475 Tue, 06 December 2005 15:42
By: smartin
  Difference in the plan output
By: bella13 on Tue, 06 December 2005
4 2327 Tue, 06 December 2005 13:30
By: smartin
  tkprof different types of sort
By: toshidas2000 on Mon, 05 December 2005
2 1172 Tue, 06 December 2005 00:40
By: Frank
  Explain Plan
By: dhar_kiran on Fri, 02 December 2005
6 2858 Tue, 06 December 2005 00:38
By: Frank
  Script Needed -- SQL Statements - Performance Tuning
By: reachriah on Mon, 28 November 2005
3 1021 Mon, 05 December 2005 18:20
By: reachriah
  Performance tuning--- Automatic workload repository (AWR &ADDM)
By: reachriah on Sun, 04 December 2005
1 871 Mon, 05 December 2005 12:02
By: smartin
  Performance tuning without accessing real data
By: rrawasi on Thu, 24 November 2005
16 6618 Sat, 03 December 2005 03:31
By: rrawasi
  Query tuning
By: yram on Mon, 28 November 2005
3 977 Fri, 02 December 2005 03:32
By: yogeshse
  Help - ToTune This Query....
By: sameer9448 on Wed, 30 November 2005
3 959 Fri, 02 December 2005 01:01
By: Frank
  Perfomance problem with partition table
By: chandanbhamra on Mon, 28 November 2005
11 2343 Thu, 01 December 2005 15:17
By: smartin
  priority query
By: rkl1 on Sat, 26 November 2005
3 1008 Wed, 30 November 2005 09:16
By: smartin
  hints on views
By: alka205 on Tue, 22 November 2005
4 1032 Wed, 30 November 2005 08:53
By: smartin
  Incorrect system statistics
By: wdavidsmc on Tue, 22 November 2005
1 730 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: Tue Oct 04 02:55:59 CDT 2022