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

    Replies Views Last message
  Statspack: How to reduce the LNS wait for LGWR redo EVENT and CPU TIME
By: beastjj on Wed, 25 October 2006
0 12201 Wed, 25 October 2006 02:41
By: beastjj
  Search option
By: selvakumar_82 on Fri, 20 October 2006
3 2742 Wed, 25 October 2006 00:29
By: rleishman
  Performance Tuning from scratch!
By: vishnuuu on Sun, 22 October 2006
1 2279 Sun, 22 October 2006 02:25
By: Mohammad Taj
  library cache lock
By: ramkrishna_gosavi on Fri, 20 October 2006
1 11698 Sat, 21 October 2006 00:31
By: Mohammad Taj
  Last Ananlyzed Column in OEM
By: toshidas2000 on Wed, 18 October 2006
3 2622 Wed, 18 October 2006 11:20
By: Mahesh Rajendran
  Slow perfomance through satellite
By: pathfinder on Wed, 11 October 2006
7 3593 Wed, 18 October 2006 08:30
By: pathfinder
  Low performance - Database
By: prashanth_gs on Thu, 12 October 2006
3 3831 Wed, 18 October 2006 06:28
By: kimant
  Basic question in PT
By: selvakumar_82 on Wed, 18 October 2006
1 2032 Wed, 18 October 2006 04:51
By: Mahesh Rajendran
  Spool from DB table to flat file slow
By: yogen on Mon, 16 October 2006
8 6653 Tue, 17 October 2006 07:54
By: rleishman
  datapump parallel
By: cmerrill@concordefs.com on Tue, 10 October 2006
1 2136 Tue, 17 October 2006 07:10
By: kimant
  Fine Tuning This query
By: bagulia_pilla on Tue, 10 October 2006
1 2355 Tue, 17 October 2006 06:38
By: kimant
  Regarding Schema Stats for CBO
By: M.Shakeel Azeem on Tue, 17 October 2006
1 2226 Tue, 17 October 2006 04:02
By: Mahesh Rajendran
  Very low network times when retriving data from a query.
By: petpet on Mon, 16 October 2006
2 2422 Tue, 17 October 2006 03:26
By: petpet
  sql tuning
By: srinivas4u2 on Fri, 13 October 2006
5 4238 Mon, 16 October 2006 21:56
By: rleishman
icon5.gif Differences in query execution between two similar environments
By: pria79 on Thu, 12 October 2006
3 2479 Fri, 13 October 2006 11:48
By: pria79
  Query Takes More time To Run
By: faiz_hyd on Thu, 12 October 2006
3 2580 Thu, 12 October 2006 14:39
By: BlackSwan
  Hint Index
By: lsabster on Wed, 11 October 2006
2 2399 Thu, 12 October 2006 10:27
By: lsabster
  dbms_session.set_sql_trace_in_session('12,25')
By: M.Shakeel Azeem on Sat, 07 October 2006
3 5270 Sat, 07 October 2006 10:50
By: Mohammad Taj
  Converting Non-Partitioned table to Partition table
By: himang on Sat, 07 October 2006
1 2550 Sat, 07 October 2006 10:49
By: Mohammad Taj
  Regarding I/O Performance
By: M.Shakeel Azeem on Sat, 07 October 2006
2 2318 Sat, 07 October 2006 06:42
By: Mahesh Rajendran
  i/o and disk planning
By: spiffi on Thu, 28 September 2006
7 3926 Fri, 06 October 2006 10:51
By: spiffi
  Script to Defragment Tables, Index and TableSpace
By: dvaddi on Wed, 04 October 2006
2 3173 Wed, 04 October 2006 12:12
By: Mahesh Rajendran
  10g - gather_stats_job
By: judym on Tue, 03 October 2006
1 5136 Wed, 04 October 2006 03:07
By: JRowbottom
  Outline help
By: rkl1 on Tue, 03 October 2006
0 4136 Tue, 03 October 2006 12:51
By: rkl1
  want to see the time duration of a statement
By: monasingh on Fri, 21 July 2006
6 3100 Mon, 02 October 2006 09:03
By: skn
  Partitioning In Phases and Impact
By: faiz_hyd on Wed, 27 September 2006
5 2682 Sun, 01 October 2006 07:11
By: Mahesh Rajendran
  performance tools
By: Database admin on Fri, 29 September 2006
2 2299 Sat, 30 September 2006 00:55
By: Database admin
  bottlenecks
By: oracle_coorgi on Fri, 29 September 2006
1 1945 Fri, 29 September 2006 10:39
By: skn
  Which is faster count(*),count(1),count(rowid)
By: guru_karnam on Thu, 28 September 2006
1 2731 Thu, 28 September 2006 09:05
By: Mahesh Rajendran
  performance graph report
By: ramkrishna_gosavi on Wed, 27 September 2006
2 2285 Thu, 28 September 2006 04:14
By: ramkrishna_gosavi
  DBLinks and performance Issues
By: reach_honey on Wed, 27 September 2006
1 2275 Wed, 27 September 2006 20:32
By: rleishman
  Help on First_Rows
By: rajaobj on Wed, 27 September 2006
8 3066 Wed, 27 September 2006 20:15
By: rleishman
icon4.gif Statspack without perstat user
By: amit_nanote on Wed, 27 September 2006
1 2129 Wed, 27 September 2006 09:27
By: Mahesh Rajendran
  how do i create bitmap index?
By: meetamol on Wed, 27 September 2006
1 1899 Wed, 27 September 2006 04:38
By: JSI2001
  ABOUT STATSPACK
By: Database admin on Tue, 26 September 2006
1 2024 Tue, 26 September 2006 05:41
By: JSI2001
  query problem
By: mjschwenger on Sat, 23 September 2006
10 3187 Mon, 25 September 2006 19:05
By: rleishman
  Inefficient sql
By: orausern on Sun, 24 September 2006
1 2417 Sun, 24 September 2006 11:11
By: orausern
  Maximum # of sessions. What can we do.
By: bogey on Wed, 20 September 2006
2 4506 Thu, 21 September 2006 06:55
By: bogey
  sql query tuning
By: vaddiparthi on Wed, 20 September 2006
1 2202 Thu, 21 September 2006 02:15
By: tarundua
  data purging from database
By: manicm on Mon, 18 September 2006
3 6806 Wed, 20 September 2006 14:21
By: manish mendiratta
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: Wed Nov 27 02:59:36 CST 2024