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

    Replies Views Last message
  Distinct versus group by
By: trupti111 on Thu, 11 September 2008
4 3123 Fri, 12 September 2008 01:15
By: Michel Cadot
  Gather statistics
Oracle 9i
By: Olivia on Thu, 11 September 2008
1 1175 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 1877 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 1769 Wed, 10 September 2008 10:49
By: harrysmall3
  how to unpin a table from cache
By: ArvindBhope on Wed, 10 September 2008
3 3335 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 7749 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 7642 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 3077 Tue, 09 September 2008 10:40
By: harrysmall3
  Perfomance tuning of a view
Oracle 10g
By: anantha on Tue, 09 September 2008
3 3378 Tue, 09 September 2008 09:09
By: Olivia
  to find out time taken
By: trupti111 on Tue, 02 September 2008
13 3946 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 3868 Mon, 08 September 2008 19:36
By: harrysmall3
  Use of Index
Oracle 9i
By: me_arindam on Wed, 03 September 2008
9 2115 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 2024 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 4838 Fri, 05 September 2008 14:48
By: Kevin Meade
  help in tuning procedure
By: trupti111 on Thu, 28 August 2008
7 2086 Fri, 05 September 2008 03:19
By: trupti111
  to determine join order for tuning
By: trupti111 on Tue, 02 September 2008
5 1896 Fri, 05 September 2008 02:16
By: trupti111
  tunning
Oracle 10G
By: saagar on Thu, 04 September 2008
9 2375 Thu, 04 September 2008 23:46
By: saagar
  Query to check that statistics gathered
Oracle 9i
By: Olivia on Thu, 04 September 2008
6 5195 Thu, 04 September 2008 10:20
By: Olivia
  What does it signifies
Oracle9i
By: Olivia on Thu, 04 September 2008
1 1139 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 2104 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 2047 Thu, 04 September 2008 01:45
By: Olivia
  Which one is to choose?
Oracle9i
By: Olivia on Tue, 02 September 2008
3 1506 Thu, 04 September 2008 01:32
By: Olivia
  alternative for DISTINCT
Oracle9i
By: Olivia on Tue, 02 September 2008
7 7771 Wed, 03 September 2008 22:25
By: rleishman
  Not Exists Vs Join
10g
By: neha_garg123 on Tue, 02 September 2008
5 6212 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 1989 Tue, 02 September 2008 09:24
By: NewLife
  UPDATE ISSUE
Oracle 10g
By: someswar1 on Tue, 02 September 2008
4 1851 Tue, 02 September 2008 08:11
By: JRowbottom
  Alternative way to avoid full scan?
Oracle9i
By: Olivia on Tue, 02 September 2008
8 2089 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 1301 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 3320 Tue, 02 September 2008 02:08
By: Olivia
  Table Partitioning
Oracle 10g
By: mariaandreou on Tue, 26 August 2008
4 2186 Tue, 02 September 2008 00:49
By: mariaandreou
  Query optimisation using meaningless condition
By: bmikle on Fri, 29 August 2008
16 3894 Mon, 01 September 2008 16:24
By: rleishman
  unstable sort is inapprehensible (merged)
By: stronghearted on Fri, 29 August 2008
3 1972 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 1381 Fri, 29 August 2008 09:51
By: pdhayan@qwest.com
  help in tuning query
By: trupti111 on Fri, 29 August 2008
1 1363 Fri, 29 August 2008 05:54
By: Michel Cadot
  histogram
By: ArvindBhope on Thu, 28 August 2008
4 1258 Thu, 28 August 2008 14:41
By: Mahesh Rajendran
  Definition of wait event
By: lunaut on Wed, 27 August 2008
5 1757 Thu, 28 August 2008 13:16
By: Michel Cadot
  memory in statspack
9i windows
By: blakshmi on Thu, 28 August 2008
2 1458 Thu, 28 August 2008 12:54
By: BlackSwan
  AWR Service Stats
By: lunaut on Thu, 28 August 2008
1 2395 Thu, 28 August 2008 12:54
By: Michel Cadot
  10g Database Performance
By: Asma123 on Thu, 28 August 2008
1 1274 Thu, 28 August 2008 10:47
By: Michel Cadot
  response time
By: ArvindBhope on Wed, 27 August 2008
3 1368 Thu, 28 August 2008 01:24
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: Sat Jun 22 21:54:39 CDT 2024