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

    Replies Views Last message
  taking to much time to update
oracle 9i/Linux
By: tannad on Tue, 23 September 2008
7 2926 Fri, 26 September 2008 00:50
By: Kevin Meade
  How to delete records without generating redo logs?
Oracle 10g
By: sudheer0886 on Thu, 25 September 2008
11 14305 Thu, 25 September 2008 22:55
By: rleishman
  Slow Execution Stored Procedure with cursors
Oracle, 8, Windows 2003
By: sabishs on Thu, 25 September 2008
1 3910 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 2134 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 4073 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 6228 Wed, 24 September 2008 17:11
By: guru_karnam
  procedure tuning
oracle 10g
By: pointers on Wed, 24 September 2008
3 2107 Wed, 24 September 2008 11:01
By: JRowbottom
  Query performance
Oracle 10g
By: ora_2007 on Mon, 22 September 2008
9 3020 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 6837 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 3715 Mon, 22 September 2008 14:17
By: shrinika
  Parallel inserts
Oracle 10g,Rel 2 ,Linux AS4
By: rsreddy28 on Mon, 22 September 2008
1 1823 Mon, 22 September 2008 09:00
By: Michel Cadot
  Query taking long time
By: sreenu80 on Wed, 17 September 2008
4 2406 Mon, 22 September 2008 05:27
By: joshirish
  Why This Execution Plan
By: scottwmackey on Fri, 19 September 2008
22 5671 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 2880 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 3064 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 3144 Sat, 20 September 2008 13:27
By: Michel Cadot
  Tuning query approach
Oracle 9i
By: Olivia on Mon, 15 September 2008
11 3528 Sat, 20 September 2008 02:16
By: Kriptas
  How to avoid TableAccessFull
Performance Tuning
By: srivishnuhari on Wed, 17 September 2008
5 3127 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 2487 Fri, 19 September 2008 14:32
By: shrinika
  SQL query performance issue
By: kirtani on Thu, 11 September 2008
31 6824 Thu, 18 September 2008 17:12
By: harrysmall3
  How the Query works
By: basmraj on Thu, 18 September 2008
1 1713 Thu, 18 September 2008 08:46
By: Michel Cadot
  dbms_stats
10.2.0.1 Solaris
By: varunvir on Wed, 17 September 2008
2 2049 Thu, 18 September 2008 08:38
By: varunvir
  query performance related
By: basmgokul on Mon, 15 September 2008
10 2717 Thu, 18 September 2008 07:54
By: Kriptas
  Help in tuning query
By: trupti111 on Mon, 01 September 2008
11 3182 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 6795 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 6697 Wed, 17 September 2008 15:40
By: shrinika
  Index rebuild
AIX 9.2.0.6
By: pokhraj_das on Wed, 17 September 2008
1 1823 Wed, 17 September 2008 00:55
By: Michel Cadot
  Low oracle performance
oracle 10g r2, HPUX
By: Kriptas on Wed, 04 June 2008
29 6530 Tue, 16 September 2008 10:51
By: Kriptas
  Database buffer cache monitoring
Oracle 10g,solaris
By: balaji1482 on Sun, 14 September 2008
5 2611 Tue, 16 September 2008 04:18
By: JRowbottom
  Problem with SQL Plan
By: majstoru on Thu, 11 September 2008
6 2419 Tue, 16 September 2008 04:09
By: JRowbottom
  Statspack Report - Suggestion
9.2.0.7
By: nazbrian on Fri, 05 September 2008
8 5455 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 7340 Mon, 15 September 2008 08:54
By: orasaket
  How to SQL Tuning? Explain Steps
By: prashant.badhe on Sun, 14 September 2008
2 1987 Mon, 15 September 2008 04:01
By: Alessandro Rossi
  temporary tablespace growing
Oracle 10 R1-Linux
By: dirish on Sun, 14 September 2008
3 2048 Sun, 14 September 2008 23:42
By: BlackSwan
  TKPROF Fetch stats
10g
By: ehegagoka on Sun, 14 September 2008
2 3684 Sun, 14 September 2008 14:05
By: ehegagoka
  NumNull Stats
By: ehegagoka on Fri, 12 September 2008
8 3642 Sat, 13 September 2008 15:26
By: ehegagoka
  Interpreting Histograms
10g
By: ehegagoka on Sat, 13 September 2008
0 6587 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 2651 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 6567 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 5094 Fri, 12 September 2008 03:24
By: rleishman
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: Tue Nov 26 07:11:02 CST 2024