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 3126 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 1880 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 1774 Wed, 10 September 2008 10:49
By: harrysmall3
  how to unpin a table from cache
By: ArvindBhope on Wed, 10 September 2008
3 3342 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 7753 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 7646 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 3082 Tue, 09 September 2008 10:40
By: harrysmall3
  Perfomance tuning of a view
Oracle 10g
By: anantha on Tue, 09 September 2008
3 3381 Tue, 09 September 2008 09:09
By: Olivia
  to find out time taken
By: trupti111 on Tue, 02 September 2008
13 3956 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 3874 Mon, 08 September 2008 19:36
By: harrysmall3
  Use of Index
Oracle 9i
By: me_arindam on Wed, 03 September 2008
9 2121 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 2028 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 4853 Fri, 05 September 2008 14:48
By: Kevin Meade
  help in tuning procedure
By: trupti111 on Thu, 28 August 2008
7 2088 Fri, 05 September 2008 03:19
By: trupti111
  to determine join order for tuning
By: trupti111 on Tue, 02 September 2008
5 1901 Fri, 05 September 2008 02:16
By: trupti111
  tunning
Oracle 10G
By: saagar on Thu, 04 September 2008
9 2378 Thu, 04 September 2008 23:46
By: saagar
  Query to check that statistics gathered
Oracle 9i
By: Olivia on Thu, 04 September 2008
6 5198 Thu, 04 September 2008 10:20
By: Olivia
  What does it signifies
Oracle9i
By: Olivia on Thu, 04 September 2008
1 1142 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 2107 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 2049 Thu, 04 September 2008 01:45
By: Olivia
  Which one is to choose?
Oracle9i
By: Olivia on Tue, 02 September 2008
3 1509 Thu, 04 September 2008 01:32
By: Olivia
  alternative for DISTINCT
Oracle9i
By: Olivia on Tue, 02 September 2008
7 7776 Wed, 03 September 2008 22:25
By: rleishman
  Not Exists Vs Join
10g
By: neha_garg123 on Tue, 02 September 2008
5 6214 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 1995 Tue, 02 September 2008 09:24
By: NewLife
  UPDATE ISSUE
Oracle 10g
By: someswar1 on Tue, 02 September 2008
4 1853 Tue, 02 September 2008 08:11
By: JRowbottom
  Alternative way to avoid full scan?
Oracle9i
By: Olivia on Tue, 02 September 2008
8 2091 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 3328 Tue, 02 September 2008 02:08
By: Olivia
  Table Partitioning
Oracle 10g
By: mariaandreou on Tue, 26 August 2008
4 2189 Tue, 02 September 2008 00:49
By: mariaandreou
  Query optimisation using meaningless condition
By: bmikle on Fri, 29 August 2008
16 3905 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 1384 Fri, 29 August 2008 09:51
By: pdhayan@qwest.com
  help in tuning query
By: trupti111 on Fri, 29 August 2008
1 1366 Fri, 29 August 2008 05:54
By: Michel Cadot
  histogram
By: ArvindBhope on Thu, 28 August 2008
4 1265 Thu, 28 August 2008 14:41
By: Mahesh Rajendran
  Definition of wait event
By: lunaut on Wed, 27 August 2008
5 1761 Thu, 28 August 2008 13:16
By: Michel Cadot
  memory in statspack
9i windows
By: blakshmi on Thu, 28 August 2008
2 1465 Thu, 28 August 2008 12:54
By: BlackSwan
  AWR Service Stats
By: lunaut on Thu, 28 August 2008
1 2397 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 1369 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: Sun Jun 30 14:38:17 CDT 2024