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 3579 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 1809 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 3524 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 5466 Wed, 24 September 2008 17:11
By: guru_karnam
  procedure tuning
oracle 10g
By: pointers on Wed, 24 September 2008
3 1838 Wed, 24 September 2008 11:01
By: JRowbottom
  Query performance
Oracle 10g
By: ora_2007 on Mon, 22 September 2008
9 2609 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 6459 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 3337 Mon, 22 September 2008 14:17
By: shrinika
  Parallel inserts
Oracle 10g,Rel 2 ,Linux AS4
By: rsreddy28 on Mon, 22 September 2008
1 1289 Mon, 22 September 2008 09:00
By: Michel Cadot
  Query taking long time
By: sreenu80 on Wed, 17 September 2008
4 1748 Mon, 22 September 2008 05:27
By: joshirish
  Why This Execution Plan
By: scottwmackey on Fri, 19 September 2008
22 4871 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 2521 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 2346 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 1991 Sat, 20 September 2008 13:27
By: Michel Cadot
  Tuning query approach
Oracle 9i
By: Olivia on Mon, 15 September 2008
11 3124 Sat, 20 September 2008 02:16
By: Kriptas
  How to avoid TableAccessFull
Performance Tuning
By: srivishnuhari on Wed, 17 September 2008
5 2101 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 1673 Fri, 19 September 2008 14:32
By: shrinika
  SQL query performance issue
By: kirtani on Thu, 11 September 2008
31 6125 Thu, 18 September 2008 17:12
By: harrysmall3
  How the Query works
By: basmraj on Thu, 18 September 2008
1 1224 Thu, 18 September 2008 08:46
By: Michel Cadot
  dbms_stats
10.2.0.1 Solaris
By: varunvir on Wed, 17 September 2008
2 1771 Thu, 18 September 2008 08:38
By: varunvir
  query performance related
By: basmgokul on Mon, 15 September 2008
10 2441 Thu, 18 September 2008 07:54
By: Kriptas
  Help in tuning query
By: trupti111 on Mon, 01 September 2008
11 2807 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 6587 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 6453 Wed, 17 September 2008 15:40
By: shrinika
  Index rebuild
AIX 9.2.0.6
By: pokhraj_das on Wed, 17 September 2008
1 1406 Wed, 17 September 2008 00:55
By: Michel Cadot
  Low oracle performance
oracle 10g r2, HPUX
By: Kriptas on Wed, 04 June 2008
29 5958 Tue, 16 September 2008 10:51
By: Kriptas
  Database buffer cache monitoring
Oracle 10g,solaris
By: balaji1482 on Sun, 14 September 2008
5 2216 Tue, 16 September 2008 04:18
By: JRowbottom
  Problem with SQL Plan
By: majstoru on Thu, 11 September 2008
6 2088 Tue, 16 September 2008 04:09
By: JRowbottom
  Statspack Report - Suggestion
9.2.0.7
By: nazbrian on Fri, 05 September 2008
8 5047 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 6974 Mon, 15 September 2008 08:54
By: orasaket
  How to SQL Tuning? Explain Steps
By: prashant.badhe on Sun, 14 September 2008
2 1468 Mon, 15 September 2008 04:01
By: Alessandro Rossi
  temporary tablespace growing
Oracle 10 R1-Linux
By: dirish on Sun, 14 September 2008
3 1514 Sun, 14 September 2008 23:42
By: BlackSwan
  TKPROF Fetch stats
10g
By: ehegagoka on Sun, 14 September 2008
2 3327 Sun, 14 September 2008 14:05
By: ehegagoka
  NumNull Stats
By: ehegagoka on Fri, 12 September 2008
8 2339 Sat, 13 September 2008 15:26
By: ehegagoka
  Interpreting Histograms
10g
By: ehegagoka on Sat, 13 September 2008
0 6328 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 2356 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 5795 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 4672 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 5171 Fri, 12 September 2008 02:57
By: crazypeter2005
  Doumentation of wait events
Oracle 10.2 documentation
By: martijn on Wed, 10 September 2008
4 2862 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: Mon Jul 01 03:17:50 CDT 2024