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

    Replies Views Last message
  Improving performance of a query using order by clause
By: rolex.mp on Sun, 27 May 2007
5 2585 Mon, 28 May 2007 11:54
By: dbaxchangedba
  Physical gets increasing after scheduled export
By: csharat on Fri, 25 May 2007
2 1545 Mon, 28 May 2007 05:03
By: sujeetsaxena16
  Oracle Database Performance Tuning (Note Sheets)
By: ahmedb72 on Sat, 26 May 2007
2 5327 Sun, 27 May 2007 04:49
By: ahmedb72
icon3.gif Stress Oracle & OAS
By: waveblue on Wed, 23 May 2007
3 4159 Fri, 25 May 2007 02:17
By: waveblue
  Does using dbms_lob package improve performance
By: rolex.mp on Thu, 24 May 2007
3 1869 Thu, 24 May 2007 10:39
By: Michel Cadot
  UL locks in Oracle Workspace Manager
By: rokyta on Thu, 24 May 2007
0 10542 Thu, 24 May 2007 05:34
By: rokyta
  Query Tuning
By: thiyagaraj on Tue, 22 May 2007
4 2739 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 2459 Tue, 22 May 2007 10:04
By: tahpush
  Need Help
By: faisalferoze on Mon, 21 May 2007
5 1815 Tue, 22 May 2007 00:29
By: faisalferoze
  NEED GUIDENCE
By: pavanv on Sat, 19 May 2007
2 2461 Sun, 20 May 2007 05:29
By: mchadder
  optimizer mode in oracle 10g
By: hanueng on Thu, 17 May 2007
4 9179 Fri, 18 May 2007 13:15
By: DreamzZ
  faq
By: kishore_dba on Thu, 17 May 2007
5 1644 Fri, 18 May 2007 13:00
By: Michel Cadot
  Statspack Report
By: chara on Wed, 16 May 2007
3 4891 Fri, 18 May 2007 11:50
By: DreamzZ
  dbms_profiler
By: guru_karnam on Tue, 15 May 2007
6 4358 Wed, 16 May 2007 05:39
By: sriram717
  My production statspack report
By: kesevan on Mon, 30 April 2007
7 5585 Wed, 16 May 2007 03:33
By: kamkan
icon8.gif Slow query responce
By: dbashailendra on Tue, 08 May 2007
3 4119 Tue, 15 May 2007 04:39
By: jai_subi
  Setting sql trace parameter
By: rolex.mp on Tue, 15 May 2007
2 4898 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 1932 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 5649 Mon, 14 May 2007 06:39
By: michael_bialik
  SGA size
By: vasudevan on Tue, 08 May 2007
12 5788 Sun, 13 May 2007 04:41
By: sriram717
  Explain plan Cost vs time elapsed
By: beetel on Fri, 11 May 2007
2 2760 Sat, 12 May 2007 02:41
By: Michel Cadot
  sql query too slow -maybe needs indexes?
By: eb222 on Fri, 11 May 2007
4 2298 Fri, 11 May 2007 13:48
By: martijn
  Regarding partitions
By: rolex.mp on Fri, 11 May 2007
4 1824 Fri, 11 May 2007 08:39
By: Michel Cadot
  Tuning update statement
By: rolex.mp on Thu, 10 May 2007
3 3250 Thu, 10 May 2007 07:22
By: sriram717
  indexes difference as table columns
By: fozerol on Thu, 10 May 2007
3 1800 Thu, 10 May 2007 03:42
By: sriram717
  Optimal size for my memory components ( development db )
By: kesevan on Thu, 10 May 2007
1 1464 Thu, 10 May 2007 03:13
By: sriram717
  Long Running SQL -V$session_longops
By: mymot on Wed, 09 May 2007
2 2267 Wed, 09 May 2007 16:34
By: gintsp
  TUNING
By: jayarago on Wed, 09 May 2007
4 2625 Wed, 09 May 2007 09:58
By: pablolee
  Re-creating partitioned tablespaces from backup.
By: Brayan on Tue, 08 May 2007
6 2977 Wed, 09 May 2007 05:08
By: sriram717
  Long Running SQL - Oracle
By: mymot on Tue, 08 May 2007
3 2024 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 5917 Tue, 08 May 2007 04:10
By: win3vin
  DATABASE DOWN WHEN MANY USERS LOG IN
By: MELAKU on Sat, 28 April 2007
19 4391 Mon, 07 May 2007 00:54
By: Michel Cadot
  Index Issues
By: thiyagaraj on Sat, 05 May 2007
5 2132 Sun, 06 May 2007 21:27
By: Teddyboy
  INDEX rebuild with ONLINE Option
By: abcindiaxyz on Sun, 06 May 2007
2 1701 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 3398 Sat, 05 May 2007 09:06
By: saibal
  Gather Statistics - SYS
By: Brayan on Thu, 03 May 2007
2 4124 Fri, 04 May 2007 17:02
By: dbaxchangedba
  Shared Pool Statistics - StatsPack Report
By: Brayan on Fri, 04 May 2007
3 12954 Fri, 04 May 2007 08:01
By: Brayan
  Movting Index partitions to differenet tablespaces.
By: kp_prasanth on Fri, 04 May 2007
1 1441 Fri, 04 May 2007 03:32
By: sriram717
  Performance monitoring
By: california_6_1 on Fri, 04 May 2007
1 2114 Fri, 04 May 2007 03:04
By: sriram717
icon9.gif Problem with spreport.sql
By: thorin666 on Thu, 03 May 2007
4 12149 Thu, 03 May 2007 14:03
By: thorin666
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: Mon Apr 29 13:50:17 CDT 2024