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 6732 Fri, 12 September 2008 09:12
By: BlackSwan
  TKPROF - High scattered read
9.2.0.7
By: Brayan on Fri, 12 September 2008
3 5381 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 7039 Fri, 12 September 2008 02:57
By: crazypeter2005
  Doumentation of wait events
Oracle 10.2 documentation
By: martijn on Wed, 10 September 2008
4 3632 Fri, 12 September 2008 02:23
By: harrysmall3
  Distinct versus group by
By: trupti111 on Thu, 11 September 2008
4 3603 Fri, 12 September 2008 01:15
By: Michel Cadot
  Gather statistics
Oracle 9i
By: Olivia on Thu, 11 September 2008
1 1860 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 3436 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 2704 Wed, 10 September 2008 10:49
By: harrysmall3
  how to unpin a table from cache
By: ArvindBhope on Wed, 10 September 2008
3 4129 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 8273 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 8315 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 3657 Tue, 09 September 2008 10:40
By: harrysmall3
  Perfomance tuning of a view
Oracle 10g
By: anantha on Tue, 09 September 2008
3 4435 Tue, 09 September 2008 09:09
By: Olivia
  to find out time taken
By: trupti111 on Tue, 02 September 2008
13 4782 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 4740 Mon, 08 September 2008 19:36
By: harrysmall3
  Use of Index
Oracle 9i
By: me_arindam on Wed, 03 September 2008
9 2959 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 2690 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 6719 Fri, 05 September 2008 14:48
By: Kevin Meade
  help in tuning procedure
By: trupti111 on Thu, 28 August 2008
7 3323 Fri, 05 September 2008 03:19
By: trupti111
  to determine join order for tuning
By: trupti111 on Tue, 02 September 2008
5 2394 Fri, 05 September 2008 02:16
By: trupti111
  tunning
Oracle 10G
By: saagar on Thu, 04 September 2008
9 3046 Thu, 04 September 2008 23:46
By: saagar
  Query to check that statistics gathered
Oracle 9i
By: Olivia on Thu, 04 September 2008
6 5808 Thu, 04 September 2008 10:20
By: Olivia
  What does it signifies
Oracle9i
By: Olivia on Thu, 04 September 2008
1 1447 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 2722 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 2706 Thu, 04 September 2008 01:45
By: Olivia
  Which one is to choose?
Oracle9i
By: Olivia on Tue, 02 September 2008
3 1922 Thu, 04 September 2008 01:32
By: Olivia
  alternative for DISTINCT
Oracle9i
By: Olivia on Tue, 02 September 2008
7 8554 Wed, 03 September 2008 22:25
By: rleishman
  Not Exists Vs Join
10g
By: neha_garg123 on Tue, 02 September 2008
5 6799 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 2692 Tue, 02 September 2008 09:24
By: NewLife
  UPDATE ISSUE
Oracle 10g
By: someswar1 on Tue, 02 September 2008
4 2540 Tue, 02 September 2008 08:11
By: JRowbottom
  Alternative way to avoid full scan?
Oracle9i
By: Olivia on Tue, 02 September 2008
8 2651 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 2127 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 4530 Tue, 02 September 2008 02:08
By: Olivia
  Table Partitioning
Oracle 10g
By: mariaandreou on Tue, 26 August 2008
4 3463 Tue, 02 September 2008 00:49
By: mariaandreou
  Query optimisation using meaningless condition
By: bmikle on Fri, 29 August 2008
16 4717 Mon, 01 September 2008 16:24
By: rleishman
  unstable sort is inapprehensible (merged)
By: stronghearted on Fri, 29 August 2008
3 2374 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 2273 Fri, 29 August 2008 09:51
By: pdhayan@qwest.com
  help in tuning query
By: trupti111 on Fri, 29 August 2008
1 1862 Fri, 29 August 2008 05:54
By: Michel Cadot
  histogram
By: ArvindBhope on Thu, 28 August 2008
4 2287 Thu, 28 August 2008 14:41
By: Mahesh Rajendran
  Definition of wait event
By: lunaut on Wed, 27 August 2008
5 2696 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 Aug 17 06:16:11 CDT 2025