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 6837 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 5555 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 7245 Fri, 12 September 2008 02:57
By: crazypeter2005
  Doumentation of wait events
Oracle 10.2 documentation
By: martijn on Wed, 10 September 2008
4 3771 Fri, 12 September 2008 02:23
By: harrysmall3
  Distinct versus group by
By: trupti111 on Thu, 11 September 2008
4 3708 Fri, 12 September 2008 01:15
By: Michel Cadot
  Gather statistics
Oracle 9i
By: Olivia on Thu, 11 September 2008
1 1945 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 3594 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 2800 Wed, 10 September 2008 10:49
By: harrysmall3
  how to unpin a table from cache
By: ArvindBhope on Wed, 10 September 2008
3 4246 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 8428 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 8482 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 3785 Tue, 09 September 2008 10:40
By: harrysmall3
  Perfomance tuning of a view
Oracle 10g
By: anantha on Tue, 09 September 2008
3 4539 Tue, 09 September 2008 09:09
By: Olivia
  to find out time taken
By: trupti111 on Tue, 02 September 2008
13 5112 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 4965 Mon, 08 September 2008 19:36
By: harrysmall3
  Use of Index
Oracle 9i
By: me_arindam on Wed, 03 September 2008
9 3172 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 2884 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 7581 Fri, 05 September 2008 14:48
By: Kevin Meade
  help in tuning procedure
By: trupti111 on Thu, 28 August 2008
7 3534 Fri, 05 September 2008 03:19
By: trupti111
  to determine join order for tuning
By: trupti111 on Tue, 02 September 2008
5 2518 Fri, 05 September 2008 02:16
By: trupti111
  tunning
Oracle 10G
By: saagar on Thu, 04 September 2008
9 3291 Thu, 04 September 2008 23:46
By: saagar
  Query to check that statistics gathered
Oracle 9i
By: Olivia on Thu, 04 September 2008
6 5943 Thu, 04 September 2008 10:20
By: Olivia
  What does it signifies
Oracle9i
By: Olivia on Thu, 04 September 2008
1 1528 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 2862 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 2843 Thu, 04 September 2008 01:45
By: Olivia
  Which one is to choose?
Oracle9i
By: Olivia on Tue, 02 September 2008
3 2018 Thu, 04 September 2008 01:32
By: Olivia
  alternative for DISTINCT
Oracle9i
By: Olivia on Tue, 02 September 2008
7 8739 Wed, 03 September 2008 22:25
By: rleishman
  Not Exists Vs Join
10g
By: neha_garg123 on Tue, 02 September 2008
5 6937 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 2830 Tue, 02 September 2008 09:24
By: NewLife
  UPDATE ISSUE
Oracle 10g
By: someswar1 on Tue, 02 September 2008
4 2694 Tue, 02 September 2008 08:11
By: JRowbottom
  Alternative way to avoid full scan?
Oracle9i
By: Olivia on Tue, 02 September 2008
8 2804 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 2208 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 5026 Tue, 02 September 2008 02:08
By: Olivia
  Table Partitioning
Oracle 10g
By: mariaandreou on Tue, 26 August 2008
4 3601 Tue, 02 September 2008 00:49
By: mariaandreou
  Query optimisation using meaningless condition
By: bmikle on Fri, 29 August 2008
16 5013 Mon, 01 September 2008 16:24
By: rleishman
  unstable sort is inapprehensible (merged)
By: stronghearted on Fri, 29 August 2008
3 2467 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 2375 Fri, 29 August 2008 09:51
By: pdhayan@qwest.com
  help in tuning query
By: trupti111 on Fri, 29 August 2008
1 1990 Fri, 29 August 2008 05:54
By: Michel Cadot
  histogram
By: ArvindBhope on Thu, 28 August 2008
4 2404 Thu, 28 August 2008 14:41
By: Mahesh Rajendran
  Definition of wait event
By: lunaut on Wed, 27 August 2008
5 2809 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: Wed Nov 12 00:12:00 CST 2025