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

    Replies Views Last message
  Reg Awrrpt report in oracle database
oracle 10.2.0.2.0
By: nilesh_pawaskar on Thu, 21 June 2012
1 673 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 703 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 1481 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 708 Wed, 20 June 2012 02:16
By: Andrey_R
  "px send round-robin "
By: cutekido on Tue, 19 June 2012
1 793 Tue, 19 June 2012 17:08
By: BlackSwan
  Creation of Index
By: suryamz on Thu, 30 March 2006
4 972 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 544 Tue, 19 June 2012 02:01
By: Rektanocrit
  combination index issue
10.2.0.1
By: andy huang on Sat, 16 June 2012
4 789 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 465 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 1167 Thu, 14 June 2012 12:41
By: LNossov
  query for optimisation
oracle 10g
By: raja859 on Thu, 14 June 2012
4 475 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 584 Tue, 12 June 2012 13:40
By: LNossov
  about V$SQL ......
By: lonion on Fri, 08 June 2012
5 646 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 616 Fri, 08 June 2012 03:24
By: Michel Cadot
  Optimizing sql
By: ora_dev_2012 on Tue, 05 June 2012
3 604 Wed, 06 June 2012 06:13
By: cookiemonster
  Oracle documentation on details of AWR report
By: bobbydurrettdba on Mon, 04 June 2012
3 1293 Tue, 05 June 2012 14:47
By: bobbydurrettdba
  Optimize my Query
By: tarek_land on Tue, 05 June 2012
1 483 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 550 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 1403 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 649 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 774 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 7352 Fri, 25 May 2012 04:22
By: Jack14
  BULK COLLECT issue
10.2.0.1
By: andy huang on Tue, 22 May 2012
14 1283 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 1094 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 761 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 655 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 892 Tue, 22 May 2012 08:21
By: John Watson
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1044 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 1710 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 1022 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 12269 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 991 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 482 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 809 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 561 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 990 Tue, 08 May 2012 21:13
By: andy huang
  Performance issue in query
Oracle 10 G
By: rangan.s on Wed, 02 May 2012
3 890 Tue, 08 May 2012 09:52
By: LNossov
  Help required in analyzing AWR report
Oracle 10.2.0.3.0
By: orapratap on Mon, 07 May 2012
6 2265 Tue, 08 May 2012 08:08
By: John Watson
  cannot see a-rows while querying dbms_xplan.display_cursor
Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX
By: Andrey_R on Thu, 03 May 2012
15 2025 Mon, 07 May 2012 10:48
By: Andrey_R
  unexplained performance degradation of PL/SQL procedures
Oracle 10gr2, Solaris 10
By: apaju on Tue, 01 May 2012
12 1153 Mon, 07 May 2012 04:48
By: apaju
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 Jul 31 03:28:32 CDT 2014

Total time taken to generate the page: 0.09242 seconds