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 2593 Mon, 28 May 2007 11:54
By: dbaxchangedba
  Physical gets increasing after scheduled export
By: csharat on Fri, 25 May 2007
2 1552 Mon, 28 May 2007 05:03
By: sujeetsaxena16
  Oracle Database Performance Tuning (Note Sheets)
By: ahmedb72 on Sat, 26 May 2007
2 5332 Sun, 27 May 2007 04:49
By: ahmedb72
icon3.gif Stress Oracle & OAS
By: waveblue on Wed, 23 May 2007
3 4167 Fri, 25 May 2007 02:17
By: waveblue
  Does using dbms_lob package improve performance
By: rolex.mp on Thu, 24 May 2007
3 1875 Thu, 24 May 2007 10:39
By: Michel Cadot
  UL locks in Oracle Workspace Manager
By: rokyta on Thu, 24 May 2007
0 10550 Thu, 24 May 2007 05:34
By: rokyta
  Query Tuning
By: thiyagaraj on Tue, 22 May 2007
4 2746 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 2466 Tue, 22 May 2007 10:04
By: tahpush
  Need Help
By: faisalferoze on Mon, 21 May 2007
5 1819 Tue, 22 May 2007 00:29
By: faisalferoze
  NEED GUIDENCE
By: pavanv on Sat, 19 May 2007
2 2471 Sun, 20 May 2007 05:29
By: mchadder
  optimizer mode in oracle 10g
By: hanueng on Thu, 17 May 2007
4 9191 Fri, 18 May 2007 13:15
By: DreamzZ
  faq
By: kishore_dba on Thu, 17 May 2007
5 1649 Fri, 18 May 2007 13:00
By: Michel Cadot
  Statspack Report
By: chara on Wed, 16 May 2007
3 4898 Fri, 18 May 2007 11:50
By: DreamzZ
  dbms_profiler
By: guru_karnam on Tue, 15 May 2007
6 4366 Wed, 16 May 2007 05:39
By: sriram717
  My production statspack report
By: kesevan on Mon, 30 April 2007
7 5590 Wed, 16 May 2007 03:33
By: kamkan
icon8.gif Slow query responce
By: dbashailendra on Tue, 08 May 2007
3 4126 Tue, 15 May 2007 04:39
By: jai_subi
  Setting sql trace parameter
By: rolex.mp on Tue, 15 May 2007
2 4906 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 1939 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 5653 Mon, 14 May 2007 06:39
By: michael_bialik
  SGA size
By: vasudevan on Tue, 08 May 2007
12 5796 Sun, 13 May 2007 04:41
By: sriram717
  Explain plan Cost vs time elapsed
By: beetel on Fri, 11 May 2007
2 2769 Sat, 12 May 2007 02:41
By: Michel Cadot
  sql query too slow -maybe needs indexes?
By: eb222 on Fri, 11 May 2007
4 2305 Fri, 11 May 2007 13:48
By: martijn
  Regarding partitions
By: rolex.mp on Fri, 11 May 2007
4 1830 Fri, 11 May 2007 08:39
By: Michel Cadot
  Tuning update statement
By: rolex.mp on Thu, 10 May 2007
3 3258 Thu, 10 May 2007 07:22
By: sriram717
  indexes difference as table columns
By: fozerol on Thu, 10 May 2007
3 1808 Thu, 10 May 2007 03:42
By: sriram717
  Optimal size for my memory components ( development db )
By: kesevan on Thu, 10 May 2007
1 1470 Thu, 10 May 2007 03:13
By: sriram717
  Long Running SQL -V$session_longops
By: mymot on Wed, 09 May 2007
2 2276 Wed, 09 May 2007 16:34
By: gintsp
  TUNING
By: jayarago on Wed, 09 May 2007
4 2628 Wed, 09 May 2007 09:58
By: pablolee
  Re-creating partitioned tablespaces from backup.
By: Brayan on Tue, 08 May 2007
6 2985 Wed, 09 May 2007 05:08
By: sriram717
  Long Running SQL - Oracle
By: mymot on Tue, 08 May 2007
3 2033 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 5924 Tue, 08 May 2007 04:10
By: win3vin
  DATABASE DOWN WHEN MANY USERS LOG IN
By: MELAKU on Sat, 28 April 2007
19 4397 Mon, 07 May 2007 00:54
By: Michel Cadot
  Index Issues
By: thiyagaraj on Sat, 05 May 2007
5 2139 Sun, 06 May 2007 21:27
By: Teddyboy
  INDEX rebuild with ONLINE Option
By: abcindiaxyz on Sun, 06 May 2007
2 1708 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 3409 Sat, 05 May 2007 09:06
By: saibal
  Gather Statistics - SYS
By: Brayan on Thu, 03 May 2007
2 4128 Fri, 04 May 2007 17:02
By: dbaxchangedba
  Shared Pool Statistics - StatsPack Report
By: Brayan on Fri, 04 May 2007
3 12961 Fri, 04 May 2007 08:01
By: Brayan
  Movting Index partitions to differenet tablespaces.
By: kp_prasanth on Fri, 04 May 2007
1 1452 Fri, 04 May 2007 03:32
By: sriram717
  Performance monitoring
By: california_6_1 on Fri, 04 May 2007
1 2123 Fri, 04 May 2007 03:04
By: sriram717
icon9.gif Problem with spreport.sql
By: thorin666 on Thu, 03 May 2007
4 12156 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: Wed May 08 01:11:07 CDT 2024