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 2637 Mon, 28 May 2007 11:54
By: dbaxchangedba
  Physical gets increasing after scheduled export
By: csharat on Fri, 25 May 2007
2 1597 Mon, 28 May 2007 05:03
By: sujeetsaxena16
  Oracle Database Performance Tuning (Note Sheets)
By: ahmedb72 on Sat, 26 May 2007
2 5371 Sun, 27 May 2007 04:49
By: ahmedb72
icon3.gif Stress Oracle & OAS
By: waveblue on Wed, 23 May 2007
3 4205 Fri, 25 May 2007 02:17
By: waveblue
  Does using dbms_lob package improve performance
By: rolex.mp on Thu, 24 May 2007
3 1914 Thu, 24 May 2007 10:39
By: Michel Cadot
  UL locks in Oracle Workspace Manager
By: rokyta on Thu, 24 May 2007
0 10600 Thu, 24 May 2007 05:34
By: rokyta
  Query Tuning
By: thiyagaraj on Tue, 22 May 2007
4 2784 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 2511 Tue, 22 May 2007 10:04
By: tahpush
  Need Help
By: faisalferoze on Mon, 21 May 2007
5 1857 Tue, 22 May 2007 00:29
By: faisalferoze
  NEED GUIDENCE
By: pavanv on Sat, 19 May 2007
2 2516 Sun, 20 May 2007 05:29
By: mchadder
  optimizer mode in oracle 10g
By: hanueng on Thu, 17 May 2007
4 9268 Fri, 18 May 2007 13:15
By: DreamzZ
  faq
By: kishore_dba on Thu, 17 May 2007
5 1692 Fri, 18 May 2007 13:00
By: Michel Cadot
  Statspack Report
By: chara on Wed, 16 May 2007
3 4937 Fri, 18 May 2007 11:50
By: DreamzZ
  dbms_profiler
By: guru_karnam on Tue, 15 May 2007
6 4407 Wed, 16 May 2007 05:39
By: sriram717
  My production statspack report
By: kesevan on Mon, 30 April 2007
7 5638 Wed, 16 May 2007 03:33
By: kamkan
icon8.gif Slow query responce
By: dbashailendra on Tue, 08 May 2007
3 4168 Tue, 15 May 2007 04:39
By: jai_subi
  Setting sql trace parameter
By: rolex.mp on Tue, 15 May 2007
2 4950 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 1974 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 5698 Mon, 14 May 2007 06:39
By: michael_bialik
  SGA size
By: vasudevan on Tue, 08 May 2007
12 5836 Sun, 13 May 2007 04:41
By: sriram717
  Explain plan Cost vs time elapsed
By: beetel on Fri, 11 May 2007
2 2809 Sat, 12 May 2007 02:41
By: Michel Cadot
  sql query too slow -maybe needs indexes?
By: eb222 on Fri, 11 May 2007
4 2341 Fri, 11 May 2007 13:48
By: martijn
  Regarding partitions
By: rolex.mp on Fri, 11 May 2007
4 1868 Fri, 11 May 2007 08:39
By: Michel Cadot
  Tuning update statement
By: rolex.mp on Thu, 10 May 2007
3 3296 Thu, 10 May 2007 07:22
By: sriram717
  indexes difference as table columns
By: fozerol on Thu, 10 May 2007
3 1848 Thu, 10 May 2007 03:42
By: sriram717
  Optimal size for my memory components ( development db )
By: kesevan on Thu, 10 May 2007
1 1510 Thu, 10 May 2007 03:13
By: sriram717
  Long Running SQL -V$session_longops
By: mymot on Wed, 09 May 2007
2 2313 Wed, 09 May 2007 16:34
By: gintsp
  TUNING
By: jayarago on Wed, 09 May 2007
4 2661 Wed, 09 May 2007 09:58
By: pablolee
  Re-creating partitioned tablespaces from backup.
By: Brayan on Tue, 08 May 2007
6 3019 Wed, 09 May 2007 05:08
By: sriram717
  Long Running SQL - Oracle
By: mymot on Tue, 08 May 2007
3 2081 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 5988 Tue, 08 May 2007 04:10
By: win3vin
  DATABASE DOWN WHEN MANY USERS LOG IN
By: MELAKU on Sat, 28 April 2007
19 4467 Mon, 07 May 2007 00:54
By: Michel Cadot
  Index Issues
By: thiyagaraj on Sat, 05 May 2007
5 2180 Sun, 06 May 2007 21:27
By: Teddyboy
  INDEX rebuild with ONLINE Option
By: abcindiaxyz on Sun, 06 May 2007
2 1743 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 3443 Sat, 05 May 2007 09:06
By: saibal
  Gather Statistics - SYS
By: Brayan on Thu, 03 May 2007
2 4171 Fri, 04 May 2007 17:02
By: dbaxchangedba
  Shared Pool Statistics - StatsPack Report
By: Brayan on Fri, 04 May 2007
3 13018 Fri, 04 May 2007 08:01
By: Brayan
  Movting Index partitions to differenet tablespaces.
By: kp_prasanth on Fri, 04 May 2007
1 1497 Fri, 04 May 2007 03:32
By: sriram717
  Performance monitoring
By: california_6_1 on Fri, 04 May 2007
1 2158 Fri, 04 May 2007 03:04
By: sriram717
icon9.gif Problem with spreport.sql
By: thorin666 on Thu, 03 May 2007
4 12212 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: Sun Jun 16 05:25:03 CDT 2024