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 tuning for one query
11g 11.2.0,2,IBM aix 64 bit
By: pvgangadar on Thu, 08 December 2011
9 4500 Fri, 09 December 2011 08:48
By: John Watson
  SQL Profiles
Solaris 10, Oracle 10.2.0.4
By: suddhasatwa_bhaumik on Fri, 09 December 2011
0 3138 Fri, 09 December 2011 06:28
By: suddhasatwa_bhaumik
  Performance Across DB Links
Oracle 11g2, LINUX
By: mjm22 on Wed, 07 December 2011
1 4038 Wed, 07 December 2011 15:17
By: cookiemonster
  create index
10.2.0.4
By: varunvir on Tue, 06 December 2011
13 3727 Wed, 07 December 2011 07:57
By: Michel Cadot
  performance problem
Oracle 9i
By: ajaykumarkona on Wed, 07 December 2011
3 2658 Wed, 07 December 2011 02:39
By: Michel Cadot
  How to improve the performance of export job(expdp)?
Oracle10gr2, Linux.
By: konkalasiva on Tue, 06 December 2011
1 3848 Tue, 06 December 2011 03:44
By: Michel Cadot
  How to reduce cost of my query?
sql developer
By: Naga_naga_naga on Sat, 03 December 2011
3 4738 Sat, 03 December 2011 01:16
By: flyboy
  urgent please modify this query frenz sloww performance
By: arivazhagancsegmailcom on Thu, 01 December 2011
12 5218 Fri, 02 December 2011 16:07
By: LNossov
  parallel_index
11g1, 11g2 LINUX
By: mjm22 on Wed, 23 November 2011
1 6658 Thu, 01 December 2011 14:05
By: LNossov
  I/O issue
11g r2 HP-UX
By: dba_7722 on Wed, 30 November 2011
4 7396 Thu, 01 December 2011 13:43
By: LNossov
  memory_max_target and 11g memory utilization - question
11.2.0.1.0
By: piotrtal on Wed, 30 November 2011
5 5918 Wed, 30 November 2011 13:27
By: BlackSwan
  WINDOW SORT
Oracle 11g
By: sachi09 on Wed, 30 November 2011
5 9579 Wed, 30 November 2011 04:37
By: Michel Cadot
  Data type conversion impact on performance
By: patni123 on Mon, 28 November 2011
8 7151 Tue, 29 November 2011 03:59
By: cookiemonster
  Query performance decreased between order by ASC/DESC
By: euphORIA on Fri, 25 November 2011
11 4266 Mon, 28 November 2011 11:59
By: Flyby
  SGA AND PGA PARAMETER SETTINGS
WINDOWS 2000 SERVER ORACLE 9I
By: mrdb on Sun, 27 November 2011
5 5775 Sun, 27 November 2011 02:49
By: John Watson
  Table space with different block size inside same database
Oracle 10g, 10.2.0.1.0 Linux
By: Rags123 on Fri, 25 November 2011
14 5086 Fri, 25 November 2011 16:55
By: BlackSwan
  Reports Tuning
Oracle Report builder 6i or later ..
By: ramoradba on Wed, 23 November 2011
1 3105 Thu, 24 November 2011 02:02
By: ramoradba
  MVIEW huge temp space
10.2.0.3 linux
By: dee_bee_eh on Wed, 23 November 2011
6 7309 Wed, 23 November 2011 09:43
By: dee_bee_eh
  Elapsed Time in Trace file output (2 Merged)
Oracle 11g R2 on Windows 7
By: orapratap on Wed, 16 November 2011
1 21256 Wed, 23 November 2011 05:29
By: dee_bee_eh
  Temp Tablespace running out of space (68 GB)
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Thu, 17 November 2011
5 9553 Wed, 23 November 2011 04:41
By: dee_bee_eh
icon3.gif At the end of the road of my sql tuning
oracle
By: tigerxu on Mon, 21 November 2011
1 3046 Mon, 21 November 2011 20:47
By: BlackSwan
  Definition between 2 metrics "Physical Reads"
10gR2
By: nikko on Mon, 21 November 2011
3 2895 Mon, 21 November 2011 06:22
By: John Watson
  Tuning in Hierarchical queries
Oracle 10.2.0.2.0
By: praveenkumarsr on Thu, 17 November 2011
4 3394 Fri, 18 November 2011 19:12
By: praveenkumarsr
  Need help for query tunning the below query
By: shefalik on Wed, 16 November 2011
5 3738 Thu, 17 November 2011 03:38
By: cookiemonster
  Slow running query -Explain plan attached-pls help!
ORacle,11g,windows server2003
By: aviana on Wed, 16 November 2011
2 2983 Wed, 16 November 2011 13:54
By: LKBrwn_DBA
  Simple inserts Slow (merged 6)
oracle 10g XP
By: zulfiqaralimemon on Tue, 18 October 2011
7 3751 Wed, 16 November 2011 07:05
By: Michel Cadot
  Shrinking index
Oracle 10.2.0.3,Windows server 2003 64 bit
By: eafaisal on Tue, 15 November 2011
7 4140 Wed, 16 November 2011 01:30
By: Michel Cadot
  index monitoring
oracle 10g
By: prashant_ora on Thu, 26 August 2010
23 8078 Fri, 11 November 2011 16:31
By: LNossov
  Merge statement tuning for 100M records in table ( 1 2)
By: sachi09 on Mon, 31 October 2011
49 12243 Tue, 08 November 2011 04:35
By: LNossov
  Need help (2 Merged)
By: supriyadba1 on Mon, 07 November 2011
14 4788 Tue, 08 November 2011 00:53
By: supriyadba1
  SQL tuning
11.2.0.2
By: singh09 on Sun, 06 November 2011
3 3458 Mon, 07 November 2011 01:17
By: LNossov
  Reducing Hard parses
Oracle 10g, 10.2.0.3.0, Linux
By: Rags123 on Wed, 02 November 2011
30 15978 Fri, 04 November 2011 05:00
By: LNossov
  Doubt about Tuning SQL
Oracle 11g R2
By: aucrun on Thu, 03 November 2011
8 3940 Thu, 03 November 2011 12:25
By: aucrun
  sql tunning help required
11.1.0.7
By: nut_shut on Mon, 12 September 2011
4 3007 Wed, 02 November 2011 13:12
By: Flyby
  Compare current row values with previous one until mismatch
Oracle 10g
By: asakchris on Wed, 02 November 2011
7 3757 Wed, 02 November 2011 05:25
By: Michel Cadot
  Parallelism in queries
By: manojbe09 on Thu, 20 October 2011
4 3079 Sun, 30 October 2011 23:55
By: manojbe09
  Bulk update performance issue
Oracle 11g, Windows XP
By: ninan on Sat, 01 October 2011
26 11410 Sat, 29 October 2011 19:54
By: Kevin Meade
  buffer busy wait
Linux 2.6.18-92.1.13.el5
By: dba_7722 on Tue, 25 October 2011
20 8898 Fri, 28 October 2011 16:12
By: LNossov
  Reading explain plan
11GR2 RAC on Windows
By: Kwisatz78 on Mon, 24 October 2011
4 3195 Fri, 28 October 2011 10:21
By: Vackar
  Query performance diff
Oracle 10.2.0.1.0 CentOS 5
By: Vackar on Tue, 25 October 2011
12 4011 Fri, 28 October 2011 06:41
By: cookiemonster
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: Thu Jun 05 13:19:52 CDT 2025