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

    Replies Views Last message
  Oracle 10g showing problem with index (2 Merged)
10g
By: avaquestions on Mon, 02 July 2012
22 2708 Wed, 11 July 2012 10:11
By: avaquestions
  Slow db performance on Oracle 11.2.0.3
Oracle 11.2.0..3, Linux
By: u570744 on Sat, 30 June 2012
6 11664 Mon, 02 July 2012 11:28
By: LNossov
  SGA related queries
Oracle 10.1.0.2.0
By: charuamit on Sat, 30 June 2012
4 1269 Sat, 30 June 2012 01:50
By: charuamit
  Need help with Queries ( 1 2 3)
By: supiash on Sat, 19 May 2012
105 3344 Tue, 14 August 2012 15:20
By: Barbara Boehmer
  Outer join causes much slower performance
By: projecttoday on Tue, 26 June 2012
3 979 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 1142 Tue, 26 June 2012 07:04
By: Michel Cadot
  SGA related queries
By: charuamit on Mon, 25 June 2012
1 1076 Mon, 25 June 2012 05:12
By: Michel Cadot
  SQL Tuning Help
oracle 11g
By: thalladas on Thu, 21 June 2012
11 6304 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 1143 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 1249 Wed, 20 June 2012 15:26
By: getzeeshan
  what's the relationship between the number of blocks and consistent gets ?
By: lonion on Wed, 20 June 2012
4 1793 Fri, 22 June 2012 20:15
By: BlackSwan
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 1611 Tue, 19 June 2012 17:08
By: BlackSwan
  PL/SQL Block (LOOP) Comparison
Oracle 10gR2 10.2.0.5, AIX 6.1
By: Rektanocrit on Tue, 19 June 2012
4 812 Tue, 19 June 2012 02:01
By: Rektanocrit
  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 2580 Wed, 20 June 2012 11:19
By: bobbydurrettdba
  combination index issue
10.2.0.1
By: andy huang on Sat, 16 June 2012
4 1274 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 684 Fri, 15 June 2012 03:34
By: Michel Cadot
  Force Index Unique Scan
Oracle 10g 10.2.0.4 HP-UX
By: manubatham20 on Thu, 14 June 2012
19 7544 Sun, 08 July 2012 20:32
By: rleishman
  Performance issue
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 ,Windows XP
By: a_oracle on Thu, 14 June 2012
6 1019 Fri, 29 June 2012 02:22
By: John Watson
  query for optimisation
oracle 10g
By: raja859 on Thu, 14 June 2012
4 892 Thu, 14 June 2012 10:11
By: flyboy
  a table deleted or updated frequency issue
By: andy huang on Thu, 14 June 2012
8 1279 Wed, 27 June 2012 19:09
By: alan.kendall@nfl.com
  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 1166 Wed, 20 June 2012 02:16
By: Andrey_R
  redo size
Oracle version 11.2.0.2.0, OS AIX basedSystems(64 bit)
By: ashishrnv on Mon, 18 June 2012
18 4723 Thu, 28 June 2012 14:29
By: BlackSwan
  about V$SQL ......
By: lonion on Fri, 08 June 2012
5 1035 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 1190 Fri, 08 June 2012 03:24
By: Michel Cadot
  Performace issue in transaction system
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Wed, 06 June 2012
6 1013 Tue, 12 June 2012 13:40
By: LNossov
  Optimizing sql
By: ora_dev_2012 on Tue, 05 June 2012
3 933 Wed, 06 June 2012 06:13
By: cookiemonster
  Optimize my Query
By: tarek_land on Tue, 05 June 2012
1 818 Tue, 05 June 2012 13:06
By: BlackSwan
  Oracle documentation on details of AWR report
By: bobbydurrettdba on Mon, 04 June 2012
3 2069 Tue, 05 June 2012 14:47
By: bobbydurrettdba
  block size
oracle 10.2.0.5 solaris 64 bit
By: guddu_12 on Fri, 01 June 2012
7 1033 Fri, 01 June 2012 09:56
By: guddu_12
  Query optimize
oracle, 10.2.0.2, AIX5.3
By: soft_doctor on Fri, 01 June 2012
2 911 Fri, 01 June 2012 06:15
By: Michel Cadot
  Why delete a where rowid=:1 go to index?
oracle 10g 10203
By: zengmuansha on Fri, 01 June 2012
12 2439 Fri, 01 June 2012 07:47
By: Michel Cadot
  how to find the SQL statement which have many hard parse
By: lonion on Thu, 31 May 2012
11 2607 Thu, 14 June 2012 12:41
By: LNossov
icon5.gif Response very slow
oracle database 10g
By: hielh on Thu, 31 May 2012
8 3052 Fri, 13 July 2012 19:44
By: alan.kendall@nfl.com
  Verify statspack
Oracle 9.2.0.8.0,windows
By: Jack14 on Tue, 29 May 2012
5 1165 Tue, 29 May 2012 02:47
By: Michel Cadot
  how to reduce dml locks?
oracle 11.2.0.1.0,windows server 2008 R2
By: vijenderkdba on Thu, 24 May 2012
6 2223 Thu, 28 June 2012 23:22
By: Michel Cadot
  Privilege to run explain plan
Oracle 11.2.0.1.0, Windows
By: Jack14 on Thu, 24 May 2012
9 19127 Fri, 25 May 2012 04:22
By: Jack14
  inbound connection timed out (ORA-3136)
ORACLE DB 10g(64 bit) R2
By: p.anshuman1 on Thu, 24 May 2012
4 7518 Mon, 17 September 2012 13:09
By: Michel Cadot
  BULK COLLECT issue
10.2.0.1
By: andy huang on Tue, 22 May 2012
14 2631 Wed, 23 May 2012 04:42
By: Michel Cadot
  Application Slow in EE but fast in XE (2 Merged)
Oracle 10g, Windows 2003
By: syed.dastagir on Tue, 22 May 2012
1 966 Tue, 22 May 2012 09:41
By: BlackSwan
  Tune data coming from legacy system into Oracle DB
Oracle 11gR1
By: vivekgupta15 on Tue, 22 May 2012
6 1186 Tue, 22 May 2012 14:03
By: vivekgupta15
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: Sat Aug 19 19:38:13 CDT 2017

Total time taken to generate the page: 0.22041 seconds