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 652 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 1200 Fri, 09 December 2011 06:28
By: suddhasatwa_bhaumik
  Performance Across DB Links
Oracle 11g2, LINUX
By: mjm22 on Wed, 07 December 2011
1 1160 Wed, 07 December 2011 15:17
By: cookiemonster
  create index
10.2.0.4
By: varunvir on Tue, 06 December 2011
13 555 Wed, 07 December 2011 07:57
By: Michel Cadot
  performance problem
Oracle 9i
By: ajaykumarkona on Wed, 07 December 2011
3 431 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 1368 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 1325 Sat, 03 December 2011 01:16
By: flyboy
  urgent please modify this query frenz sloww performance
By: arivazhagancsegmailcom on Thu, 01 December 2011
12 832 Fri, 02 December 2011 16:07
By: LNossov
  parallel_index
11g1, 11g2 LINUX
By: mjm22 on Wed, 23 November 2011
1 2214 Thu, 01 December 2011 14:05
By: LNossov
  I/O issue
11g r2 HP-UX
By: dba_7722 on Wed, 30 November 2011
4 2733 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 1785 Wed, 30 November 2011 13:27
By: BlackSwan
  WINDOW SORT
Oracle 11g
By: sachi09 on Wed, 30 November 2011
5 2031 Wed, 30 November 2011 04:37
By: Michel Cadot
  Data type conversion impact on performance
By: patni123 on Mon, 28 November 2011
8 1273 Tue, 29 November 2011 03:59
By: cookiemonster
  Query performance decreased between order by ASC/DESC
By: euphORIA on Fri, 25 November 2011
11 1095 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 1509 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 873 Fri, 25 November 2011 16:55
By: BlackSwan
  Reports Tuning
Oracle Report builder 6i or later ..
By: ramoradba on Wed, 23 November 2011
1 796 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 1000 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 17763 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 4030 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 532 Mon, 21 November 2011 20:47
By: BlackSwan
  Definition between 2 metrics "Physical Reads"
10gR2
By: nikko on Mon, 21 November 2011
3 697 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 996 Fri, 18 November 2011 19:12
By: praveenkumarsr
  Need help for query tunning the below query
By: shefalik on Wed, 16 November 2011
5 736 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 797 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 1419 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 548 Wed, 16 November 2011 01:30
By: Michel Cadot
  index monitoring
oracle 10g
By: prashant_ora on Thu, 26 August 2010
23 2643 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 1924 Tue, 08 November 2011 04:35
By: LNossov
  Need help (2 Merged)
By: supriyadba1 on Mon, 07 November 2011
14 888 Tue, 08 November 2011 00:53
By: supriyadba1
  SQL tuning
11.2.0.2
By: singh09 on Sun, 06 November 2011
3 716 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 3541 Fri, 04 November 2011 05:00
By: LNossov
  Doubt about Tuning SQL
Oracle 11g R2
By: aucrun on Thu, 03 November 2011
8 745 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 613 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 585 Wed, 02 November 2011 05:25
By: Michel Cadot
  Parallelism in queries
By: manojbe09 on Thu, 20 October 2011
4 508 Sun, 30 October 2011 23:55
By: manojbe09
  Bulk update performance issue
Oracle 11g, Windows XP
By: ninan on Sat, 01 October 2011
26 3956 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 1728 Fri, 28 October 2011 16:12
By: LNossov
  Reading explain plan
11GR2 RAC on Windows
By: Kwisatz78 on Mon, 24 October 2011
4 601 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 502 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 Apr 24 09:57:41 CDT 2014

Total time taken to generate the page: 0.09469 seconds