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

    Replies Views Last message
  HWM in table
By: shahnazurs on Tue, 01 May 2007
18 4677 Thu, 31 May 2007 01:06
By: Michel Cadot
  Need help
By: rmoturi on Wed, 23 May 2007
4 2410 Tue, 29 May 2007 01:56
By: michael_bialik
  Improving performance of a query using order by clause
By: rolex.mp on Sun, 27 May 2007
5 2900 Mon, 28 May 2007 11:54
By: dbaxchangedba
  Physical gets increasing after scheduled export
By: csharat on Fri, 25 May 2007
2 1858 Mon, 28 May 2007 05:03
By: sujeetsaxena16
  Oracle Database Performance Tuning (Note Sheets)
By: ahmedb72 on Sat, 26 May 2007
2 5619 Sun, 27 May 2007 04:49
By: ahmedb72
icon3.gif Stress Oracle & OAS
By: waveblue on Wed, 23 May 2007
3 4499 Fri, 25 May 2007 02:17
By: waveblue
  Does using dbms_lob package improve performance
By: rolex.mp on Thu, 24 May 2007
3 2540 Thu, 24 May 2007 10:39
By: Michel Cadot
  UL locks in Oracle Workspace Manager
By: rokyta on Thu, 24 May 2007
0 10975 Thu, 24 May 2007 05:34
By: rokyta
  Query Tuning
By: thiyagaraj on Tue, 22 May 2007
4 3089 Wed, 23 May 2007 03:29
By: Michel Cadot
  How to get TRACE for a Sql script which is being called from a shell program
By: adroit.ramesh on Mon, 21 May 2007
11 2904 Tue, 22 May 2007 10:04
By: tahpush
  Need Help
By: faisalferoze on Mon, 21 May 2007
5 2255 Tue, 22 May 2007 00:29
By: faisalferoze
  NEED GUIDENCE
By: pavanv on Sat, 19 May 2007
2 2842 Sun, 20 May 2007 05:29
By: mchadder
  optimizer mode in oracle 10g
By: hanueng on Thu, 17 May 2007
4 9584 Fri, 18 May 2007 13:15
By: DreamzZ
  faq
By: kishore_dba on Thu, 17 May 2007
5 2149 Fri, 18 May 2007 13:00
By: Michel Cadot
  Statspack Report
By: chara on Wed, 16 May 2007
3 5408 Fri, 18 May 2007 11:50
By: DreamzZ
  dbms_profiler
By: guru_karnam on Tue, 15 May 2007
6 4760 Wed, 16 May 2007 05:39
By: sriram717
  My production statspack report
By: kesevan on Mon, 30 April 2007
7 6684 Wed, 16 May 2007 03:33
By: kamkan
icon8.gif Slow query responce
By: dbashailendra on Tue, 08 May 2007
3 4427 Tue, 15 May 2007 04:39
By: jai_subi
  Setting sql trace parameter
By: rolex.mp on Tue, 15 May 2007
2 5301 Tue, 15 May 2007 01:47
By: Mohammad Taj
  Rule based but has cost in explain plan.. why?
By: beetel on Fri, 11 May 2007
3 2416 Mon, 14 May 2007 13:45
By: jrich
  my production database is taking 50% of CPU consumption in main db server
By: kesevan on Thu, 10 May 2007
12 6096 Mon, 14 May 2007 06:39
By: michael_bialik
  SGA size
By: vasudevan on Tue, 08 May 2007
12 6740 Sun, 13 May 2007 04:41
By: sriram717
  Explain plan Cost vs time elapsed
By: beetel on Fri, 11 May 2007
2 3025 Sat, 12 May 2007 02:41
By: Michel Cadot
  sql query too slow -maybe needs indexes?
By: eb222 on Fri, 11 May 2007
4 2710 Fri, 11 May 2007 13:48
By: martijn
  Regarding partitions
By: rolex.mp on Fri, 11 May 2007
4 2369 Fri, 11 May 2007 08:39
By: Michel Cadot
  Tuning update statement
By: rolex.mp on Thu, 10 May 2007
3 3637 Thu, 10 May 2007 07:22
By: sriram717
  indexes difference as table columns
By: fozerol on Thu, 10 May 2007
3 2643 Thu, 10 May 2007 03:42
By: sriram717
  Optimal size for my memory components ( development db )
By: kesevan on Thu, 10 May 2007
1 1876 Thu, 10 May 2007 03:13
By: sriram717
  Long Running SQL -V$session_longops
By: mymot on Wed, 09 May 2007
2 2568 Wed, 09 May 2007 16:34
By: gintsp
  TUNING
By: jayarago on Wed, 09 May 2007
4 3340 Wed, 09 May 2007 09:58
By: pablolee
  Re-creating partitioned tablespaces from backup.
By: Brayan on Tue, 08 May 2007
6 4277 Wed, 09 May 2007 05:08
By: sriram717
  Long Running SQL - Oracle
By: mymot on Tue, 08 May 2007
3 2375 Tue, 08 May 2007 07:53
By: sriram717
  insufficient privileges when generating explain plan for a synonym
By: win3vin on Tue, 08 May 2007
4 6440 Tue, 08 May 2007 04:10
By: win3vin
  DATABASE DOWN WHEN MANY USERS LOG IN
By: MELAKU on Sat, 28 April 2007
19 5625 Mon, 07 May 2007 00:54
By: Michel Cadot
  Index Issues
By: thiyagaraj on Sat, 05 May 2007
5 2812 Sun, 06 May 2007 21:27
By: Teddyboy
  INDEX rebuild with ONLINE Option
By: abcindiaxyz on Sun, 06 May 2007
2 2076 Sun, 06 May 2007 16:10
By: BlackSwan
icon8.gif oracle sql query analyzer optimize tool
By: tssr_2001 on Sat, 05 May 2007
3 4220 Sat, 05 May 2007 09:06
By: saibal
  Gather Statistics - SYS
By: Brayan on Thu, 03 May 2007
2 4744 Fri, 04 May 2007 17:02
By: dbaxchangedba
  Shared Pool Statistics - StatsPack Report
By: Brayan on Fri, 04 May 2007
3 13304 Fri, 04 May 2007 08:01
By: Brayan
  Movting Index partitions to differenet tablespaces.
By: kp_prasanth on Fri, 04 May 2007
1 2034 Fri, 04 May 2007 03:32
By: sriram717
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 Nov 23 05:28:20 CST 2024