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

    Replies Views Last message
  Index not being used in Oracle 10g
Oracle 10g
By: Karena_Russell on Fri, 12 September 2008
2 6941 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 5616 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 7296 Fri, 12 September 2008 02:57
By: crazypeter2005
  Doumentation of wait events
Oracle 10.2 documentation
By: martijn on Wed, 10 September 2008
4 3847 Fri, 12 September 2008 02:23
By: harrysmall3
  Distinct versus group by
By: trupti111 on Thu, 11 September 2008
4 3755 Fri, 12 September 2008 01:15
By: Michel Cadot
  Gather statistics
Oracle 9i
By: Olivia on Thu, 11 September 2008
1 1971 Thu, 11 September 2008 06:56
By: Mahesh Rajendran
icon5.gif Performance impact Kernel Parameters
Oracle 9.2.0.8,HP-UX 11.11 ----> Oracle 9.2.0.8, HP-UX 11.23
By: vikramjogi on Mon, 08 September 2008
6 3624 Wed, 10 September 2008 13:56
By: coleing
  use of index in performance tuning
oracle 8i
By: agrawal.prachi@gmail.com on Wed, 10 September 2008
2 2872 Wed, 10 September 2008 10:49
By: harrysmall3
  how to unpin a table from cache
By: ArvindBhope on Wed, 10 September 2008
3 4272 Wed, 10 September 2008 10:34
By: BlackSwan
  A performance test of Oracle Analtyicals vs Group By
Oracle 9.2.0.3 / Unix
By: harrysmall3 on Mon, 08 September 2008
6 8486 Wed, 10 September 2008 10:05
By: harrysmall3
  Cursor versus select into for simple select
Oracle 9,10
By: goo321 on Sun, 07 September 2008
4 8534 Tue, 09 September 2008 10:45
By: goo321
  Before Asking the Index Question
Oracle 9.2.0.3 Unix
By: harrysmall3 on Sun, 07 September 2008
5 3904 Tue, 09 September 2008 10:40
By: harrysmall3
  Perfomance tuning of a view
Oracle 10g
By: anantha on Tue, 09 September 2008
3 4588 Tue, 09 September 2008 09:09
By: Olivia
  to find out time taken
By: trupti111 on Tue, 02 September 2008
13 5214 Tue, 09 September 2008 03:31
By: tanyaa
  Tuning of delete stmt
Oracle, 9.2.0.8, Unix
By: srihari.gurram on Mon, 01 September 2008
9 5034 Mon, 08 September 2008 19:36
By: harrysmall3
  Use of Index
Oracle 9i
By: me_arindam on Wed, 03 September 2008
9 3340 Mon, 08 September 2008 14:58
By: harrysmall3
  Why showing BITMAP in Plan while no bitmap exists for the table
Oracle9i
By: Olivia on Fri, 05 September 2008
8 3022 Mon, 08 September 2008 13:13
By: harrysmall3
  lobg running query
10.2.0.1 ( 1 2)
By: varunvir on Tue, 26 August 2008
40 7759 Fri, 05 September 2008 14:48
By: Kevin Meade
  help in tuning procedure
By: trupti111 on Thu, 28 August 2008
7 3571 Fri, 05 September 2008 03:19
By: trupti111
  to determine join order for tuning
By: trupti111 on Tue, 02 September 2008
5 2563 Fri, 05 September 2008 02:16
By: trupti111
  tunning
Oracle 10G
By: saagar on Thu, 04 September 2008
9 3371 Thu, 04 September 2008 23:46
By: saagar
  Query to check that statistics gathered
Oracle 9i
By: Olivia on Thu, 04 September 2008
6 5976 Thu, 04 September 2008 10:20
By: Olivia
  What does it signifies
Oracle9i
By: Olivia on Thu, 04 September 2008
1 1548 Thu, 04 September 2008 07:34
By: JRowbottom
  Function Based Join Without Nested Loops
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
By: annagel on Wed, 03 September 2008
6 2973 Thu, 04 September 2008 06:42
By: annagel
icon3.gif Index not being used for Min/Max
Oracle 11g
By: GreekBoy on Wed, 03 September 2008
4 2884 Thu, 04 September 2008 01:45
By: Olivia
  Which one is to choose?
Oracle9i
By: Olivia on Tue, 02 September 2008
3 2062 Thu, 04 September 2008 01:32
By: Olivia
  alternative for DISTINCT
Oracle9i
By: Olivia on Tue, 02 September 2008
7 8922 Wed, 03 September 2008 22:25
By: rleishman
  Not Exists Vs Join
10g
By: neha_garg123 on Tue, 02 September 2008
5 7016 Wed, 03 September 2008 06:11
By: JRowbottom
icon6.gif Performance tuning
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
By: NewLife on Tue, 02 September 2008
9 2922 Tue, 02 September 2008 09:24
By: NewLife
  UPDATE ISSUE
Oracle 10g
By: someswar1 on Tue, 02 September 2008
4 2784 Tue, 02 September 2008 08:11
By: JRowbottom
  Alternative way to avoid full scan?
Oracle9i
By: Olivia on Tue, 02 September 2008
8 2841 Tue, 02 September 2008 07:35
By: Olivia
  Query to check statistics are up to date
Oracle9i
By: Olivia on Tue, 02 September 2008
2 2242 Tue, 02 September 2008 06:56
By: Olivia
  How to make the response time less for this query
Oracle9i
By: Olivia on Mon, 01 September 2008
27 5275 Tue, 02 September 2008 02:08
By: Olivia
  Table Partitioning
Oracle 10g
By: mariaandreou on Tue, 26 August 2008
4 3718 Tue, 02 September 2008 00:49
By: mariaandreou
  Query optimisation using meaningless condition
By: bmikle on Fri, 29 August 2008
16 5112 Mon, 01 September 2008 16:24
By: rleishman
  unstable sort is inapprehensible (merged)
By: stronghearted on Fri, 29 August 2008
3 2504 Mon, 01 September 2008 00:34
By: stronghearted
  DB parameters
ORacle 10.2.0.3
By: pdhayan@qwest.com on Wed, 27 August 2008
3 2417 Fri, 29 August 2008 09:51
By: pdhayan@qwest.com
  help in tuning query
By: trupti111 on Fri, 29 August 2008
1 2035 Fri, 29 August 2008 05:54
By: Michel Cadot
  histogram
By: ArvindBhope on Thu, 28 August 2008
4 2445 Thu, 28 August 2008 14:41
By: Mahesh Rajendran
  Definition of wait event
By: lunaut on Wed, 27 August 2008
5 2844 Thu, 28 August 2008 13:16
By: Michel Cadot
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 Dec 21 15:47:43 CST 2025