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 976 Tue, 26 June 2012 07:04
By: Michel Cadot
  SGA related queries
By: charuamit on Mon, 25 June 2012
1 957 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 1359 Fri, 22 June 2012 20:15
By: BlackSwan
  SQL Tuning Help
oracle 11g
By: thalladas on Thu, 21 June 2012
11 5331 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 970 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 1092 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 2243 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 1021 Wed, 20 June 2012 02:16
By: Andrey_R
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 1431 Tue, 19 June 2012 17:08
By: BlackSwan
  Creation of Index
By: suryamz on Thu, 30 March 2006
4 1379 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 738 Tue, 19 June 2012 02:01
By: Rektanocrit
  combination index issue
10.2.0.1
By: andy huang on Sat, 16 June 2012
4 1139 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 629 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 1954 Thu, 14 June 2012 12:41
By: LNossov
  query for optimisation
oracle 10g
By: raja859 on Thu, 14 June 2012
4 693 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 893 Tue, 12 June 2012 13:40
By: LNossov
  about V$SQL ......
By: lonion on Fri, 08 June 2012
5 904 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 992 Fri, 08 June 2012 03:24
By: Michel Cadot
  Optimizing sql
By: ora_dev_2012 on Tue, 05 June 2012
3 847 Wed, 06 June 2012 06:13
By: cookiemonster
  Oracle documentation on details of AWR report
By: bobbydurrettdba on Mon, 04 June 2012
3 1821 Tue, 05 June 2012 14:47
By: bobbydurrettdba
  Optimize my Query
By: tarek_land on Tue, 05 June 2012
1 695 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 868 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 2165 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 851 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 1091 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 15147 Fri, 25 May 2012 04:22
By: Jack14
  BULK COLLECT issue
10.2.0.1
By: andy huang on Tue, 22 May 2012
14 2184 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 1725 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 1079 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 883 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 1259 Tue, 22 May 2012 08:21
By: John Watson
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1341 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 3053 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 1553 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 16736 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 1331 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 844 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 1113 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 990 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 1413 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: Thu Jun 30 12:42:34 CDT 2016

Total time taken to generate the page: 0.10302 seconds