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

    Replies Views Last message
  performance improvement of clob data
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Tue, 26 June 2012
1 729 Tue, 26 June 2012 07:04
By: Michel Cadot
  SGA related queries
By: charuamit on Mon, 25 June 2012
1 736 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 879 Fri, 22 June 2012 20:15
By: BlackSwan
  SQL Tuning Help
oracle 11g
By: thalladas on Thu, 21 June 2012
11 2742 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 709 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 787 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 1643 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 768 Wed, 20 June 2012 02:16
By: Andrey_R
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 895 Tue, 19 June 2012 17:08
By: BlackSwan
  Creation of Index
By: suryamz on Thu, 30 March 2006
4 1063 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 583 Tue, 19 June 2012 02:01
By: Rektanocrit
  combination index issue
10.2.0.1
By: andy huang on Sat, 16 June 2012
4 848 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 499 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 1260 Thu, 14 June 2012 12:41
By: LNossov
  query for optimisation
oracle 10g
By: raja859 on Thu, 14 June 2012
4 505 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 645 Tue, 12 June 2012 13:40
By: LNossov
  about V$SQL ......
By: lonion on Fri, 08 June 2012
5 700 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 687 Fri, 08 June 2012 03:24
By: Michel Cadot
  Optimizing sql
By: ora_dev_2012 on Tue, 05 June 2012
3 648 Wed, 06 June 2012 06:13
By: cookiemonster
  Oracle documentation on details of AWR report
By: bobbydurrettdba on Mon, 04 June 2012
3 1400 Tue, 05 June 2012 14:47
By: bobbydurrettdba
  Optimize my Query
By: tarek_land on Tue, 05 June 2012
1 518 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 600 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 1559 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 679 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 837 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 8586 Fri, 25 May 2012 04:22
By: Jack14
  BULK COLLECT issue
10.2.0.1
By: andy huang on Tue, 22 May 2012
14 1442 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 1210 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 822 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 694 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 960 Tue, 22 May 2012 08:21
By: John Watson
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1087 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 1894 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 1127 Fri, 11 May 2012 11:34
By: Kevin Meade
  filesystemio_options=SETALL is slower than ASYNCH, why?
11gr2 hp redhat
By: Kevin Meade on Sat, 28 January 2012
7 13229 Fri, 11 May 2012 10:27
By: Kevin Meade
  Query hang
oracle 10g r2,windows 2003 server
By: zeeshan047 on Thu, 10 May 2012
5 1061 Thu, 10 May 2012 08:57
By: Michel Cadot
  Help to alternate or rewrite the query (5 threads merged by bb)
oracle10.2.0.2,Unix
By: krajasekhar.v on Wed, 09 May 2012
2 529 Thu, 10 May 2012 03:07
By: cookiemonster
icon9.gif Slow ─░nsert Fast Select problem
Oracle 10.2.0.4 Enterprise Edition Operation sys Linux
By: fabi88 on Thu, 10 May 2012
1 873 Thu, 10 May 2012 02:14
By: Michel Cadot
  Expplain plan output
10.1.0.1
By: guddu_12 on Wed, 09 May 2012
6 645 Wed, 09 May 2012 07:29
By: John Watson
  how to set the sql_profile
10.2.0.1
By: andy huang on Tue, 08 May 2012
2 1081 Tue, 08 May 2012 21:13
By: andy huang
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 Nov 28 12:28:41 CST 2014

Total time taken to generate the page: 0.14147 seconds