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

    Replies Views Last message
  How to delete records without generating redo logs?
Oracle 10g
By: sudheer0886 on Thu, 25 September 2008
11 14053 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 3717 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 1965 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 3667 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 5767 Wed, 24 September 2008 17:11
By: guru_karnam
  procedure tuning
oracle 10g
By: pointers on Wed, 24 September 2008
3 1980 Wed, 24 September 2008 11:01
By: JRowbottom
  Query performance
Oracle 10g
By: ora_2007 on Mon, 22 September 2008
9 2816 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 6627 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 3502 Mon, 22 September 2008 14:17
By: shrinika
  Parallel inserts
Oracle 10g,Rel 2 ,Linux AS4
By: rsreddy28 on Mon, 22 September 2008
1 1416 Mon, 22 September 2008 09:00
By: Michel Cadot
  Query taking long time
By: sreenu80 on Wed, 17 September 2008
4 1893 Mon, 22 September 2008 05:27
By: joshirish
  Why This Execution Plan
By: scottwmackey on Fri, 19 September 2008
22 5214 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 2676 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 2478 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 2114 Sat, 20 September 2008 13:27
By: Michel Cadot
  Tuning query approach
Oracle 9i
By: Olivia on Mon, 15 September 2008
11 3316 Sat, 20 September 2008 02:16
By: Kriptas
  How to avoid TableAccessFull
Performance Tuning
By: srivishnuhari on Wed, 17 September 2008
5 2249 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 1808 Fri, 19 September 2008 14:32
By: shrinika
  SQL query performance issue
By: kirtani on Thu, 11 September 2008
31 6462 Thu, 18 September 2008 17:12
By: harrysmall3
  How the Query works
By: basmraj on Thu, 18 September 2008
1 1348 Thu, 18 September 2008 08:46
By: Michel Cadot
  dbms_stats
10.2.0.1 Solaris
By: varunvir on Wed, 17 September 2008
2 1878 Thu, 18 September 2008 08:38
By: varunvir
  query performance related
By: basmgokul on Mon, 15 September 2008
10 2601 Thu, 18 September 2008 07:54
By: Kriptas
  Help in tuning query
By: trupti111 on Mon, 01 September 2008
11 3007 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 6725 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 6608 Wed, 17 September 2008 15:40
By: shrinika
  Index rebuild
AIX 9.2.0.6
By: pokhraj_das on Wed, 17 September 2008
1 1524 Wed, 17 September 2008 00:55
By: Michel Cadot
  Low oracle performance
oracle 10g r2, HPUX
By: Kriptas on Wed, 04 June 2008
29 6189 Tue, 16 September 2008 10:51
By: Kriptas
  Database buffer cache monitoring
Oracle 10g,solaris
By: balaji1482 on Sun, 14 September 2008
5 2354 Tue, 16 September 2008 04:18
By: JRowbottom
  Problem with SQL Plan
By: majstoru on Thu, 11 September 2008
6 2289 Tue, 16 September 2008 04:09
By: JRowbottom
  Statspack Report - Suggestion
9.2.0.7
By: nazbrian on Fri, 05 September 2008
8 5259 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 7096 Mon, 15 September 2008 08:54
By: orasaket
  How to SQL Tuning? Explain Steps
By: prashant.badhe on Sun, 14 September 2008
2 1605 Mon, 15 September 2008 04:01
By: Alessandro Rossi
  temporary tablespace growing
Oracle 10 R1-Linux
By: dirish on Sun, 14 September 2008
3 1651 Sun, 14 September 2008 23:42
By: BlackSwan
  TKPROF Fetch stats
10g
By: ehegagoka on Sun, 14 September 2008
2 3452 Sun, 14 September 2008 14:05
By: ehegagoka
  NumNull Stats
By: ehegagoka on Fri, 12 September 2008
8 2512 Sat, 13 September 2008 15:26
By: ehegagoka
  Interpreting Histograms
10g
By: ehegagoka on Sat, 13 September 2008
0 6441 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 2522 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 5940 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 4853 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 5349 Fri, 12 September 2008 02:57
By: crazypeter2005
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: Fri Sep 13 10:37:59 CDT 2024