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 Profiles
Solaris 10, Oracle 10.2.0.4
By: suddhasatwa_bhaumik on Fri, 09 December 2011
0 2686 Fri, 09 December 2011 06:28
By: suddhasatwa_bhaumik
  Performance Across DB Links
Oracle 11g2, LINUX
By: mjm22 on Wed, 07 December 2011
1 3870 Wed, 07 December 2011 15:17
By: cookiemonster
  create index
10.2.0.4
By: varunvir on Tue, 06 December 2011
13 3315 Wed, 07 December 2011 07:57
By: Michel Cadot
  performance problem
Oracle 9i
By: ajaykumarkona on Wed, 07 December 2011
3 2413 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 3357 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 4515 Sat, 03 December 2011 01:16
By: flyboy
  urgent please modify this query frenz sloww performance
By: arivazhagancsegmailcom on Thu, 01 December 2011
12 4643 Fri, 02 December 2011 16:07
By: LNossov
  parallel_index
11g1, 11g2 LINUX
By: mjm22 on Wed, 23 November 2011
1 6502 Thu, 01 December 2011 14:05
By: LNossov
  I/O issue
11g r2 HP-UX
By: dba_7722 on Wed, 30 November 2011
4 7092 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 5006 Wed, 30 November 2011 13:27
By: BlackSwan
  WINDOW SORT
Oracle 11g
By: sachi09 on Wed, 30 November 2011
5 8552 Wed, 30 November 2011 04:37
By: Michel Cadot
  Data type conversion impact on performance
By: patni123 on Mon, 28 November 2011
8 5497 Tue, 29 November 2011 03:59
By: cookiemonster
  Query performance decreased between order by ASC/DESC
By: euphORIA on Fri, 25 November 2011
11 3860 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 5011 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 4529 Fri, 25 November 2011 16:55
By: BlackSwan
  Reports Tuning
Oracle Report builder 6i or later ..
By: ramoradba on Wed, 23 November 2011
1 2946 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 6969 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 21049 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 9201 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 2148 Mon, 21 November 2011 20:47
By: BlackSwan
  Definition between 2 metrics "Physical Reads"
10gR2
By: nikko on Mon, 21 November 2011
3 2630 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 3050 Fri, 18 November 2011 19:12
By: praveenkumarsr
  Need help for query tunning the below query
By: shefalik on Wed, 16 November 2011
5 2959 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 2694 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 3353 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 2876 Wed, 16 November 2011 01:30
By: Michel Cadot
  index monitoring
oracle 10g
By: prashant_ora on Thu, 26 August 2010
23 7370 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 10986 Tue, 08 November 2011 04:35
By: LNossov
  Need help (2 Merged)
By: supriyadba1 on Mon, 07 November 2011
14 4225 Tue, 08 November 2011 00:53
By: supriyadba1
  SQL tuning
11.2.0.2
By: singh09 on Sun, 06 November 2011
3 3278 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 15000 Fri, 04 November 2011 05:00
By: LNossov
  Doubt about Tuning SQL
Oracle 11g R2
By: aucrun on Thu, 03 November 2011
8 3508 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 2642 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 3399 Wed, 02 November 2011 05:25
By: Michel Cadot
  Parallelism in queries
By: manojbe09 on Thu, 20 October 2011
4 2415 Sun, 30 October 2011 23:55
By: manojbe09
  Bulk update performance issue
Oracle 11g, Windows XP
By: ninan on Sat, 01 October 2011
26 10686 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 8023 Fri, 28 October 2011 16:12
By: LNossov
  Reading explain plan
11GR2 RAC on Windows
By: Kwisatz78 on Mon, 24 October 2011
4 2887 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 3654 Fri, 28 October 2011 06:41
By: cookiemonster
  Tuning my first query
11GR2 RAC on Windows
By: Kwisatz78 on Wed, 26 October 2011
10 4025 Thu, 27 October 2011 04:15
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: Fri Sep 27 10:56:49 CDT 2024