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

    Replies Views Last message
  Run TKPROF..............
By: naveenkumar001 on Mon, 20 August 2007
3 3090 Mon, 20 August 2007 12:53
By: Michel Cadot
  Time taken to refresh with DBMS_REFRESH
By: kamragulshan on Mon, 20 August 2007
1 1280 Mon, 20 August 2007 11:34
By: Michel Cadot
  How to implement SQL changes when tuning
By: mson77 on Sun, 19 August 2007
2 1307 Mon, 20 August 2007 01:01
By: mson77
  Currently Executing statement not available in Trace file- Oracle 10g
By: orasaket on Sun, 19 August 2007
4 2328 Sun, 19 August 2007 22:00
By: rleishman
  Currently executing statement for Oracle Job- Oracle 10g
By: orasaket on Sun, 19 August 2007
4 3159 Sun, 19 August 2007 12:31
By: Michel Cadot
  CONTEXT index
By: yesukannan on Sat, 18 August 2007
1 1571 Sat, 18 August 2007 08:58
By: ebrian
  SQL Tuning
By: mson77 on Tue, 14 August 2007
24 4919 Sat, 18 August 2007 00:46
By: mson77
  TUNNING
By: qasim845 on Thu, 16 August 2007
8 6257 Fri, 17 August 2007 07:51
By: qasim845
  Some missing concepts and definitions
By: mson77 on Thu, 16 August 2007
3 6344 Fri, 17 August 2007 00:29
By: mson77
icon5.gif Indexes on LMT
By: sudipsarkar on Thu, 16 August 2007
3 1847 Thu, 16 August 2007 21:59
By: rleishman
  How to recreate statistics to whole schema?
By: mson77 on Thu, 16 August 2007
11 4171 Thu, 16 August 2007 13:31
By: mson77
  DB Monitoring tool
By: winnerMedas on Thu, 16 August 2007
0 7332 Thu, 16 August 2007 12:13
By: winnerMedas
  oracle.exe 100% during many hours
By: mson77 on Thu, 16 August 2007
1 2307 Thu, 16 August 2007 11:09
By: mson77
  very high redo space wait ratios on 10g
By: sumang24 on Tue, 14 August 2007
2 4192 Wed, 15 August 2007 08:36
By: orafaqer
  v$sga_target_advice view
By: sumang24 on Tue, 14 August 2007
1 3168 Tue, 14 August 2007 12:37
By: Michel Cadot
  Update Statement - Performance Tuning
By: mymot on Tue, 14 August 2007
4 2462 Tue, 14 August 2007 08:13
By: S.Rajaram
  how to find out the I/O and CPU bottleneks
By: pavan27 on Mon, 13 August 2007
1 1690 Mon, 13 August 2007 14:24
By: DreamzZ
  Takes more time - DELETE.
By: marlon_loyolite on Sat, 11 August 2007
2 2043 Mon, 13 August 2007 12:30
By: DreamzZ
  Different Explain in Different Instances.
By: maggy_ashee on Mon, 13 August 2007
7 2406 Mon, 13 August 2007 09:35
By: maggy_ashee
  10g performance tuning (how can I practice?)
By: mson77 on Sat, 11 August 2007
9 3221 Sun, 12 August 2007 22:42
By: BlackSwan
  cached objects in buffer
By: pramodgaree on Sat, 11 August 2007
1 1797 Sat, 11 August 2007 09:22
By: Michel Cadot
  Help - Histogram
By: orasaket on Thu, 09 August 2007
4 2020 Thu, 09 August 2007 14:36
By: orasaket
  dead ORADISM process
By: preet_kumar on Thu, 09 August 2007
0 12986 Thu, 09 August 2007 05:30
By: preet_kumar
  Index for Order by clause
By: poratips on Mon, 30 July 2007
19 4107 Wed, 08 August 2007 22:57
By: poratips
  Error during Merge Statment
By: pardeep on Wed, 08 August 2007
6 2506 Wed, 08 August 2007 11:44
By: DreamzZ
  Creation of index
By: donind on Mon, 06 August 2007
3 2069 Tue, 07 August 2007 22:19
By: rleishman
  reverse key index
By: donind on Tue, 07 August 2007
2 1748 Tue, 07 August 2007 22:14
By: rleishman
  Performance Slow - Jobs
By: prashanth_gs on Tue, 07 August 2007
1 1639 Tue, 07 August 2007 20:56
By: BlackSwan
  Performance tunning
By: qasim845 on Mon, 06 August 2007
3 2080 Tue, 07 August 2007 08:15
By: qasim845
icon9.gif Performance problem when using Analytic Functions. Need Help !!!
By: v@to on Tue, 07 August 2007
2 1766 Tue, 07 August 2007 07:50
By: v@to
  stripping in oracle 10g dba?
By: enchantress on Fri, 03 August 2007
4 1696 Mon, 06 August 2007 08:08
By: enchantress
  Monthly Avg. CPU Time usage.. meaningful?
By: subhrajitb on Sun, 05 August 2007
1 1710 Sun, 05 August 2007 19:20
By: BlackSwan
  Sort Area Size - ORA-600 & ORA-02097 (merged)
By: naveenkumar001 on Fri, 03 August 2007
3 3794 Fri, 03 August 2007 10:23
By: BlackSwan
  Problem when installing statspack
By: chaitanya_krishna on Wed, 01 August 2007
13 2491 Fri, 03 August 2007 06:23
By: chaitanya_krishna
icon14.gif Temp Datafiles Size
By: mian imran on Tue, 31 July 2007
5 1855 Fri, 03 August 2007 04:23
By: martijn
  query tuning
By: vimal.negi on Mon, 30 July 2007
16 5290 Thu, 02 August 2007 21:47
By: vimal.negi
  CAN WE USE HINT IN VIEW QUERY STATEMENT
By: jainarayan5484 on Thu, 02 August 2007
2 1920 Thu, 02 August 2007 13:00
By: Michel Cadot
  How to Generate Statistics of a table and how to see in oracle 10g
By: jainarayan5484 on Thu, 02 August 2007
2 1521 Thu, 02 August 2007 10:22
By: DreamzZ
  performance problem when use parallel and hash join on large tables
By: fbucco on Tue, 31 July 2007
5 2094 Wed, 01 August 2007 13:08
By: fbucco
  How to find out the bad sql statemets ?
By: kesevan on Sat, 28 April 2007
7 4885 Wed, 01 August 2007 10:55
By: Michel Cadot
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: Thu May 16 08:51:56 CDT 2024