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

    Replies Views Last message
  Sql Trace and tkprof
By: sonia.ali on Fri, 14 May 2010
1 1883 Fri, 14 May 2010 01:13
By: Michel Cadot
  Tune sql query
oracle 10.2.0.4
By: ankush_chawla on Mon, 03 May 2010
5 2532 Fri, 14 May 2010 00:45
By: nitinkrmishra
  Function based index
Oracle, 10g, Windows Server 2003
By: getritesh on Wed, 12 May 2010
8 2459 Thu, 13 May 2010 12:07
By: Michel Cadot
  Help required to tune a query
Oralce,9.2.0.8.0,sun solaris 5.2
By: sathik on Wed, 05 May 2010
13 2705 Thu, 13 May 2010 04:02
By: sathik
  Consistent gets reduced but Elapsed time increased.. please help.
By: nitinkrmishra on Mon, 10 May 2010
4 2002 Wed, 12 May 2010 08:55
By: Alessandro Rossi
  performance problem
oracle 10g, windows
By: klinki on Thu, 06 May 2010
4 2048 Tue, 11 May 2010 01:37
By: klinki
icon4.gif Optimisation Strategies
Oracle 11g Enterprise R1
By: dsub42 on Fri, 07 May 2010
26 3856 Mon, 10 May 2010 01:25
By: rahulvb
  AWR report
10.2.0.4
By: new_dba on Thu, 06 May 2010
1 1581 Thu, 06 May 2010 07:12
By: John Watson
  Tuning
Oracle, 10g, Windows Server 2003
By: getritesh on Mon, 03 May 2010
4 1941 Wed, 05 May 2010 03:07
By: michael_bialik
  simultaneous query processing
11g,solaris (urgent)
By: orafacjublu on Mon, 03 May 2010
1 1513 Mon, 03 May 2010 03:36
By: Michel Cadot
  Interpreting tuning task Report
Oracle 10.2.0.4,AIX
By: dbcop on Wed, 28 April 2010
4 7001 Sun, 02 May 2010 05:58
By: michael_bialik
  execution time versus plan cost
10.2.0.4
By: ankush_chawla on Fri, 30 April 2010
2 1875 Fri, 30 April 2010 07:14
By: cookiemonster
  Updating a huge table of size 750Gb
Oracle 10g, Linux
By: nawasthi on Fri, 30 April 2010
1 1678 Fri, 30 April 2010 00:57
By: Michel Cadot
  alter table to add list partition
oracle 10g
By: swas_fly on Thu, 29 April 2010
1 2362 Thu, 29 April 2010 02:37
By: Michel Cadot
  awr report
By: zodiacsom on Mon, 26 April 2010
3 17468 Wed, 28 April 2010 01:31
By: zodiacsom
  DBMS SQL Tuning Advisor
10.2.0.4
By: ankush_chawla on Mon, 26 April 2010
3 4082 Tue, 27 April 2010 01:03
By: John Watson
  DBMS SQL TUNE Problem
Oracle 10.2.0.4/AIX 5
By: dbcop on Mon, 26 April 2010
1 6582 Mon, 26 April 2010 10:47
By: mherlindo
  Tuning query having not exists clause.
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production.
By: Gangaprasad on Thu, 22 April 2010
3 2746 Thu, 22 April 2010 04:55
By: cookiemonster
  Tune sql query
10.2.0.4
By: ankush_chawla on Tue, 20 April 2010
9 2992 Wed, 21 April 2010 06:29
By: JRowbottom
  Analse tables
Oracle 9i ,AIx 5.2
By: soundar on Mon, 19 April 2010
3 1837 Tue, 20 April 2010 07:57
By: soundar
  Parsing of sql-statements
Oracle rdbms / 11.2.0.1.0 / Linux / FC 12 32 bit
By: martijn on Fri, 16 April 2010
5 2572 Sun, 18 April 2010 08:29
By: mnitu
  Compare Query Performance
Oracle 10.2.0.4.0 on windows and HP-UX
By: kumarsz on Mon, 12 April 2010
3 2558 Fri, 16 April 2010 01:04
By: hkchital
  same query different explain plan
11g ,solaris
By: orafacjublu on Mon, 12 April 2010
2 3168 Wed, 14 April 2010 09:01
By: mjohanss
  SQL Logic (merged by CM)
Oracle9i
By: kkmohan1 on Wed, 14 April 2010
1 1639 Wed, 14 April 2010 05:47
By: cookiemonster
  Using 9i stored outlines by 11g SPM
11g , solaris9
By: orafacjublu on Mon, 12 April 2010
3 2586 Mon, 12 April 2010 13:09
By: John Watson
  awr snapshots
oracle 10g,unix
By: ranganathan1984 on Fri, 09 April 2010
3 1850 Fri, 09 April 2010 14:47
By: Michel Cadot
  hash join vs nested loops
11g
By: orafacjublu on Wed, 07 April 2010
3 4385 Thu, 08 April 2010 08:02
By: rleishman
  Using SQL Tuning Advisor Interactively on already running task/job/batch
By: samg4ug on Thu, 08 April 2010
2 1603 Thu, 08 April 2010 04:51
By: samg4ug
  Resolving Latch Free Waits
Oracle 9.2.0.6.0 and 9.2.0.8.0 on HP-UX
By: kumarsz on Tue, 06 April 2010
12 10640 Wed, 07 April 2010 05:44
By: kumarsz
  Please help me in tuning below query
By: Gangaprasad on Mon, 05 April 2010
8 3219 Wed, 07 April 2010 04:44
By: JRowbottom
  Query benchmarking
Oracle 10gR2 RHEL 4
By: sussus2326 on Wed, 07 April 2010
1 1701 Wed, 07 April 2010 03:23
By: Michel Cadot
  Performance tuning with date comparison
oracle 10g
By: sray_suman on Tue, 30 March 2010
18 6128 Fri, 02 April 2010 02:05
By: mnitu
  Inline View
Oracle 10G
By: harshalonline22 on Mon, 29 March 2010
6 4514 Thu, 01 April 2010 08:02
By: cookiemonster
  Difference in Cardinality, Cost, Temp Space
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: knw15pwr on Tue, 30 March 2010
16 4905 Wed, 31 March 2010 04:44
By: cookiemonster
  Missing Index but strange column
Oracle 10.2.0.1, Sun Solaris 10
By: trantuananh24hg on Thu, 11 March 2010
4 3444 Wed, 31 March 2010 04:07
By: cookiemonster
  Full Table Scan Instead of Index Usage
Oracle 10g
By: MartinMM on Thu, 17 July 2008
34 15700 Tue, 30 March 2010 07:39
By: cookiemonster
  11g- query Performance issue
11g,Release 11.1.0.6.0,windowsXP
By: vs0037476 on Sun, 28 March 2010
4 2980 Mon, 29 March 2010 02:14
By: vs0037476
  Query fetching time before hand
11g,solaris9
By: orafacjublu on Thu, 25 March 2010
3 2226 Sun, 28 March 2010 08:17
By: Michel Cadot
  materialize view
11g, solaris9
By: orafacjublu on Wed, 24 March 2010
13 4027 Sun, 28 March 2010 06:29
By: Kevin Meade
  sql tuning
11g,Solaris 9
By: orafacjublu on Mon, 22 March 2010
6 3143 Sun, 28 March 2010 06:16
By: Kevin Meade
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 23 11:59:59 CDT 2024