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

    Replies Views Last message
  how to reduce dml locks?
oracle 11.2.0.1.0,windows server 2008 R2
By: vijenderkdba on Thu, 24 May 2012
6 1368 Thu, 28 June 2012 23:22
By: Michel Cadot
  Tuning Queries
Oracle 10.1.0.2
By: arif_md2009 on Wed, 16 May 2012
13 999 Thu, 28 June 2012 15:44
By: alan.kendall@nfl.com
  redo size
Oracle version 11.2.0.2.0, OS AIX basedSystems(64 bit)
By: ashishrnv on Mon, 18 June 2012
18 3203 Thu, 28 June 2012 14:29
By: BlackSwan
  Value for sga_target
Oracle 10.2.0.4.0 on AIX 5.3
By: raj9999 on Fri, 15 June 2012
8 1970 Wed, 27 June 2012 23:15
By: Michel Cadot
  a table deleted or updated frequency issue
By: andy huang on Thu, 14 June 2012
8 701 Wed, 27 June 2012 19:09
By: alan.kendall@nfl.com
  Outer join causes much slower performance
By: projecttoday on Tue, 26 June 2012
3 696 Wed, 27 June 2012 10:00
By: BlackSwan
  performance improvement of clob data
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Tue, 26 June 2012
1 746 Tue, 26 June 2012 07:04
By: Michel Cadot
  SGA related queries
By: charuamit on Mon, 25 June 2012
1 747 Mon, 25 June 2012 05:12
By: Michel Cadot
  what's the relationship between the number of blocks and consistent gets ?
By: lonion on Wed, 20 June 2012
4 899 Fri, 22 June 2012 20:15
By: BlackSwan
  SQL Tuning Help
oracle 11g
By: thalladas on Thu, 21 June 2012
11 2778 Fri, 22 June 2012 08:52
By: thalladas
  Reg Awrrpt report in oracle database
oracle 10.2.0.2.0
By: nilesh_pawaskar on Thu, 21 June 2012
1 718 Thu, 21 June 2012 07:04
By: Michel Cadot
  How to determine the system memory usage by oracle processes
Solaris 10
By: getzeeshan on Wed, 20 June 2012
6 801 Wed, 20 June 2012 15:26
By: getzeeshan
  Oracle (HP-UX) connection very slow from Windows client
Oracle 9.2.0.7 installed on HP-UX
By: C4poster on Mon, 18 June 2012
13 1673 Wed, 20 June 2012 11:19
By: bobbydurrettdba
  How can i trace a different from current session with LEVEL 4?
Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX
By: Andrey_R on Wed, 13 June 2012
8 780 Wed, 20 June 2012 02:16
By: Andrey_R
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 904 Tue, 19 June 2012 17:08
By: BlackSwan
  Creation of Index
By: suryamz on Thu, 30 March 2006
4 1080 Tue, 19 June 2012 11:27
By: Jack14
  PL/SQL Block (LOOP) Comparison
Oracle 10gR2 10.2.0.5, AIX 6.1
By: Rektanocrit on Tue, 19 June 2012
4 596 Tue, 19 June 2012 02:01
By: Rektanocrit
  combination index issue
10.2.0.1
By: andy huang on Sat, 16 June 2012
4 862 Mon, 18 June 2012 22:36
By: andy huang
  Passing record to a variable - Performance Issue
Oracle 10gR2 10.2.0.5 Server:AIX Client:Windows
By: Rektanocrit on Fri, 15 June 2012
3 508 Fri, 15 June 2012 03:34
By: Michel Cadot
  how to find the SQL statement which have many hard parse
By: lonion on Thu, 31 May 2012
11 1279 Thu, 14 June 2012 12:41
By: LNossov
  query for optimisation
oracle 10g
By: raja859 on Thu, 14 June 2012
4 518 Thu, 14 June 2012 10:11
By: flyboy
  Performace issue in transaction system
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Wed, 06 June 2012
6 662 Tue, 12 June 2012 13:40
By: LNossov
  about V$SQL ......
By: lonion on Fri, 08 June 2012
5 718 Fri, 08 June 2012 20:51
By: BlackSwan
  how to reduce the clustering_factor's value?
10g,linux
By: lonion on Thu, 07 June 2012
10 701 Fri, 08 June 2012 03:24
By: Michel Cadot
  Optimizing sql
By: ora_dev_2012 on Tue, 05 June 2012
3 661 Wed, 06 June 2012 06:13
By: cookiemonster
  Oracle documentation on details of AWR report
By: bobbydurrettdba on Mon, 04 June 2012
3 1425 Tue, 05 June 2012 14:47
By: bobbydurrettdba
  Optimize my Query
By: tarek_land on Tue, 05 June 2012
1 534 Tue, 05 June 2012 13:06
By: BlackSwan
  block size
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Fri, 01 June 2012
7 621 Fri, 01 June 2012 09:56
By: guddu_12
  Why delete a where rowid=:1 go to index?
oracle 10g 10203
By: zengmuansha on Fri, 01 June 2012
12 1590 Fri, 01 June 2012 07:47
By: Michel Cadot
  Query optimize
oracle, 10.2.0.2, AIX5.3
By: soft_doctor on Fri, 01 June 2012
2 693 Fri, 01 June 2012 06:15
By: Michel Cadot
  Verify statspack
Oracle 9.2.0.8.0,windows
By: Jack14 on Tue, 29 May 2012
5 850 Tue, 29 May 2012 02:47
By: Michel Cadot
  Privilege to run explain plan
Oracle 11.2.0.1.0, Windows
By: Jack14 on Thu, 24 May 2012
9 8812 Fri, 25 May 2012 04:22
By: Jack14
  BULK COLLECT issue
10.2.0.1
By: andy huang on Tue, 22 May 2012
14 1471 Wed, 23 May 2012 04:42
By: Michel Cadot
  Index skip scan
oracle,11.2.0.2,aix6.1
By: chandusatyam on Sat, 19 May 2012
8 1233 Tue, 22 May 2012 16:30
By: rleishman
  Tune data coming from legacy system into Oracle DB
Oracle 11gR1
By: vivekgupta15 on Tue, 22 May 2012
6 834 Tue, 22 May 2012 14:03
By: vivekgupta15
  Application Slow in EE but fast in XE (2 Merged)
Oracle 10g, Windows 2003
By: syed.dastagir on Tue, 22 May 2012
1 705 Tue, 22 May 2012 09:41
By: BlackSwan
  Query not hitting index on date column
Oracle 10G
By: priyankt on Fri, 18 May 2012
6 972 Tue, 22 May 2012 08:21
By: John Watson
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1104 Fri, 18 May 2012 03:46
By: priyankt
  query slow in application, fast on SQL*Plus executing
Oracle Database 10g(RAC) Enterprise Edition Release 10.2.0.4.0 - 64bit
By: Andrey_R on Mon, 14 May 2012
6 1937 Tue, 15 May 2012 06:08
By: LNossov
  PLSQL taking long time
11.2.0.2.5
By: getzeeshan on Thu, 10 May 2012
5 1147 Fri, 11 May 2012 11:34
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: Wed Dec 17 22:23:03 CST 2014

Total time taken to generate the page: 0.14681 seconds