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 3569 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 1801 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 3517 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 5460 Wed, 24 September 2008 17:11
By: guru_karnam
  procedure tuning
oracle 10g
By: pointers on Wed, 24 September 2008
3 1832 Wed, 24 September 2008 11:01
By: JRowbottom
  Query performance
Oracle 10g
By: ora_2007 on Mon, 22 September 2008
9 2600 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 6445 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 3330 Mon, 22 September 2008 14:17
By: shrinika
  Parallel inserts
Oracle 10g,Rel 2 ,Linux AS4
By: rsreddy28 on Mon, 22 September 2008
1 1283 Mon, 22 September 2008 09:00
By: Michel Cadot
  Query taking long time
By: sreenu80 on Wed, 17 September 2008
4 1742 Mon, 22 September 2008 05:27
By: joshirish
  Why This Execution Plan
By: scottwmackey on Fri, 19 September 2008
22 4861 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 2514 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 2341 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 1983 Sat, 20 September 2008 13:27
By: Michel Cadot
  Tuning query approach
Oracle 9i
By: Olivia on Mon, 15 September 2008
11 3116 Sat, 20 September 2008 02:16
By: Kriptas
  How to avoid TableAccessFull
Performance Tuning
By: srivishnuhari on Wed, 17 September 2008
5 2091 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 1667 Fri, 19 September 2008 14:32
By: shrinika
  SQL query performance issue
By: kirtani on Thu, 11 September 2008
31 6115 Thu, 18 September 2008 17:12
By: harrysmall3
  How the Query works
By: basmraj on Thu, 18 September 2008
1 1218 Thu, 18 September 2008 08:46
By: Michel Cadot
  dbms_stats
10.2.0.1 Solaris
By: varunvir on Wed, 17 September 2008
2 1762 Thu, 18 September 2008 08:38
By: varunvir
  query performance related
By: basmgokul on Mon, 15 September 2008
10 2432 Thu, 18 September 2008 07:54
By: Kriptas
  Help in tuning query
By: trupti111 on Mon, 01 September 2008
11 2800 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 6579 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 6444 Wed, 17 September 2008 15:40
By: shrinika
  Index rebuild
AIX 9.2.0.6
By: pokhraj_das on Wed, 17 September 2008
1 1401 Wed, 17 September 2008 00:55
By: Michel Cadot
  Low oracle performance
oracle 10g r2, HPUX
By: Kriptas on Wed, 04 June 2008
29 5945 Tue, 16 September 2008 10:51
By: Kriptas
  Database buffer cache monitoring
Oracle 10g,solaris
By: balaji1482 on Sun, 14 September 2008
5 2209 Tue, 16 September 2008 04:18
By: JRowbottom
  Problem with SQL Plan
By: majstoru on Thu, 11 September 2008
6 2079 Tue, 16 September 2008 04:09
By: JRowbottom
  Statspack Report - Suggestion
9.2.0.7
By: nazbrian on Fri, 05 September 2008
8 5027 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 6967 Mon, 15 September 2008 08:54
By: orasaket
  How to SQL Tuning? Explain Steps
By: prashant.badhe on Sun, 14 September 2008
2 1461 Mon, 15 September 2008 04:01
By: Alessandro Rossi
  temporary tablespace growing
Oracle 10 R1-Linux
By: dirish on Sun, 14 September 2008
3 1507 Sun, 14 September 2008 23:42
By: BlackSwan
  TKPROF Fetch stats
10g
By: ehegagoka on Sun, 14 September 2008
2 3320 Sun, 14 September 2008 14:05
By: ehegagoka
  NumNull Stats
By: ehegagoka on Fri, 12 September 2008
8 2332 Sat, 13 September 2008 15:26
By: ehegagoka
  Interpreting Histograms
10g
By: ehegagoka on Sat, 13 September 2008
0 6322 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 2351 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 5782 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 4663 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 5159 Fri, 12 September 2008 02:57
By: crazypeter2005
  Doumentation of wait events
Oracle 10.2 documentation
By: martijn on Wed, 10 September 2008
4 2851 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: Sat Jun 22 21:48:49 CDT 2024