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

    Replies Views Last message
  Slow Execution Stored Procedure with cursors
Oracle, 8, Windows 2003
By: sabishs on Thu, 25 September 2008
1 3663 Thu, 25 September 2008 09:36
By: JRowbottom
  Index Creation with Parallel Option
Oracle 10g Rel 2
By: faiz_hyd on Wed, 24 September 2008
3 1899 Thu, 25 September 2008 09:09
By: faiz_hyd
  Improve in-memory sort performance
Oracle 10g on Linux
By: kpalania on Wed, 24 September 2008
3 3608 Thu, 25 September 2008 05:15
By: rleishman
  Stroring Hierarchical Data(XML) into relational Table
Oracle 9.2,XP
By: rajatratewal on Mon, 14 July 2008
21 5581 Wed, 24 September 2008 17:11
By: guru_karnam
  procedure tuning
oracle 10g
By: pointers on Wed, 24 September 2008
3 1924 Wed, 24 September 2008 11:01
By: JRowbottom
  Query performance
Oracle 10g
By: ora_2007 on Mon, 22 September 2008
9 2705 Tue, 23 September 2008 13:13
By: Kriptas
  First_rows Versus All_rows
Oracle 9.2.0.8
By: shrinika on Mon, 22 September 2008
3 6553 Tue, 23 September 2008 08:48
By: shrinika
  v$sess_io info is not changing.
oracle 9.2.0.8
By: shrinika on Sun, 21 September 2008
2 3447 Mon, 22 September 2008 14:17
By: shrinika
  Parallel inserts
Oracle 10g,Rel 2 ,Linux AS4
By: rsreddy28 on Mon, 22 September 2008
1 1376 Mon, 22 September 2008 09:00
By: Michel Cadot
  Query taking long time
By: sreenu80 on Wed, 17 September 2008
4 1828 Mon, 22 September 2008 05:27
By: joshirish
  Why This Execution Plan
By: scottwmackey on Fri, 19 September 2008
22 4990 Mon, 22 September 2008 00:54
By: scottwmackey
  How to change value of CLUSTERING_FACTOR of index
oracle 10g hpux11
By: reyazan on Thu, 18 September 2008
4 2606 Sun, 21 September 2008 14:38
By: harrysmall3
  Relationsip between Parallel Degree & Clustering Factor
Oracle 10g Rel 2 ( 2 Node RAC ) , Solaris 10
By: feroze on Wed, 10 September 2008
4 2432 Sun, 21 September 2008 09:45
By: VivekSharma
icon8.gif Partitioned table growing too fast
10.2.0.3 on Solaris 8
By: IMRAN2008 on Fri, 19 September 2008
5 2064 Sat, 20 September 2008 13:27
By: Michel Cadot
  Tuning query approach
Oracle 9i
By: Olivia on Mon, 15 September 2008
11 3220 Sat, 20 September 2008 02:16
By: Kriptas
  How to avoid TableAccessFull
Performance Tuning
By: srivishnuhari on Wed, 17 September 2008
5 2188 Fri, 19 September 2008 15:20
By: harrysmall3
  Find out what query is running for specific session?
oracle 9.2.0.8
By: shrinika on Thu, 18 September 2008
2 1770 Fri, 19 September 2008 14:32
By: shrinika
  SQL query performance issue
By: kirtani on Thu, 11 September 2008
31 6242 Thu, 18 September 2008 17:12
By: harrysmall3
  How the Query works
By: basmraj on Thu, 18 September 2008
1 1313 Thu, 18 September 2008 08:46
By: Michel Cadot
  dbms_stats
10.2.0.1 Solaris
By: varunvir on Wed, 17 September 2008
2 1850 Thu, 18 September 2008 08:38
By: varunvir
  query performance related
By: basmgokul on Mon, 15 September 2008
10 2535 Thu, 18 September 2008 07:54
By: Kriptas
  Help in tuning query
By: trupti111 on Mon, 01 September 2008
11 2908 Wed, 17 September 2008 23:23
By: trupti111
  Performance Test: IS NOT NULL check
Oracle 9.2.0.3 Unix
By: harrysmall3 on Wed, 17 September 2008
0 6681 Wed, 17 September 2008 18:48
By: harrysmall3
  Run time versus Elapsed time
Oracle 9.2.0.8
By: shrinika on Wed, 17 September 2008
2 6559 Wed, 17 September 2008 15:40
By: shrinika
  Index rebuild
AIX 9.2.0.6
By: pokhraj_das on Wed, 17 September 2008
1 1492 Wed, 17 September 2008 00:55
By: Michel Cadot
  Low oracle performance
oracle 10g r2, HPUX
By: Kriptas on Wed, 04 June 2008
29 6077 Tue, 16 September 2008 10:51
By: Kriptas
  Database buffer cache monitoring
Oracle 10g,solaris
By: balaji1482 on Sun, 14 September 2008
5 2299 Tue, 16 September 2008 04:18
By: JRowbottom
  Problem with SQL Plan
By: majstoru on Thu, 11 September 2008
6 2188 Tue, 16 September 2008 04:09
By: JRowbottom
  Statspack Report - Suggestion
9.2.0.7
By: nazbrian on Fri, 05 September 2008
8 5154 Tue, 16 September 2008 01:21
By: Brayan
  Help - To get Row Source Operation in Tkprof
Oracle 10g R2 on RHEL 4
By: orasaket on Mon, 15 September 2008
0 7060 Mon, 15 September 2008 08:54
By: orasaket
  How to SQL Tuning? Explain Steps
By: prashant.badhe on Sun, 14 September 2008
2 1554 Mon, 15 September 2008 04:01
By: Alessandro Rossi
  temporary tablespace growing
Oracle 10 R1-Linux
By: dirish on Sun, 14 September 2008
3 1603 Sun, 14 September 2008 23:42
By: BlackSwan
  TKPROF Fetch stats
10g
By: ehegagoka on Sun, 14 September 2008
2 3404 Sun, 14 September 2008 14:05
By: ehegagoka
  NumNull Stats
By: ehegagoka on Fri, 12 September 2008
8 2428 Sat, 13 September 2008 15:26
By: ehegagoka
  Interpreting Histograms
10g
By: ehegagoka on Sat, 13 September 2008
0 6404 Sat, 13 September 2008 14:14
By: ehegagoka
  New predicate increasing response time from 30 sec to 6 min
Oracle 10.2.0.3.0
By: arunprasad_bh on Thu, 11 September 2008
5 2443 Fri, 12 September 2008 11:18
By: harrysmall3
  Index not being used in Oracle 10g
Oracle 10g
By: Karena_Russell on Fri, 12 September 2008
2 5887 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 4775 Fri, 12 September 2008 03:24
By: rleishman
  SUSE Oracle high CPU usgae problem
Linux SUSE x86_64 GNU/Linux 2.6.5-7.97-smp/ Oracle Enterprise Edition 64 bit 10.2.3
By: crazypeter2005 on Thu, 11 September 2008
6 5274 Fri, 12 September 2008 02:57
By: crazypeter2005
  Doumentation of wait events
Oracle 10.2 documentation
By: martijn on Wed, 10 September 2008
4 2962 Fri, 12 September 2008 02:23
By: harrysmall3
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 Aug 18 21:40:44 CDT 2024