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

    Replies Views Last message
  Tune data coming from legacy system into Oracle DB
Oracle 11gR1
By: vivekgupta15 on Tue, 22 May 2012
6 883 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 736 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 1026 Tue, 22 May 2012 08:21
By: John Watson
  Problem in Update
ORACLE 10g
By: priyankt on Fri, 11 May 2012
7 1150 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 2154 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 1247 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 14218 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 1142 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 624 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 940 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 716 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 1173 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 1050 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 2956 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 2705 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 1450 Mon, 07 May 2012 04:48
By: apaju
  Parallel index with Non-partitioned Noparallel table
Oracle 10.2.0.4
By: orapratap on Mon, 30 April 2012
5 1456 Sat, 05 May 2012 20:31
By: rleishman
  How we can find %age completion of query when is in running status
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
By: msol25 on Wed, 02 May 2012
35 1597 Sat, 05 May 2012 06:38
By: martijn
  How we can check count for each partition
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit
By: msol25 on Wed, 02 May 2012
12 2793 Wed, 02 May 2012 22:22
By: BlackSwan
  Achieve same execution plan
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
By: manubatham20 on Mon, 30 April 2012
9 1002 Wed, 02 May 2012 09:46
By: LNossov
  How to change the execution order
Oracle,11g,AIX
By: vattigunta on Wed, 02 May 2012
3 1291 Wed, 02 May 2012 08:30
By: cookiemonster
  Gather statistics on SYS objects
Oracle 11.2.0.2.0. Sun OS
By: Jack14 on Wed, 07 March 2012
4 1436 Sun, 29 April 2012 11:15
By: Jack14
  Query Running for a long time in Second Schema
Oracle 11G
By: gan.chowdary on Fri, 27 April 2012
2 728 Sat, 28 April 2012 19:14
By: rleishman
  Stale statistics for table
Oracle 11g,Linux
By: pokhraj_d on Fri, 27 April 2012
3 10890 Fri, 27 April 2012 22:51
By: BlackSwan
  OWB Cube load SQL tuning
119, exadata
By: onlinedev on Fri, 27 April 2012
1 847 Fri, 27 April 2012 13:28
By: BlackSwan
  Lot of time being taken to delete the data from a table
Oracle 10G
By: harsh shah on Fri, 27 April 2012
26 1083 Fri, 27 April 2012 07:25
By: John Watson
  Locking of two sessions
Oracle, 10g,Windows
By: manjumagesh on Fri, 27 April 2012
3 813 Fri, 27 April 2012 07:24
By: cookiemonster
  Tablespace full warning
11g
By: najeeb7 on Thu, 26 April 2012
4 1192 Thu, 26 April 2012 07:36
By: BlackSwan
  Querying GTT in Parallel Mode
Oracle 10.2.0.2
By: orapratap on Tue, 24 April 2012
3 2388 Thu, 26 April 2012 00:43
By: orapratap
  Tuneup the SQL
Oracle 11.2.0.1.0 OS RH Linux 5.1
By: javed.khan on Mon, 23 April 2012
7 1488 Wed, 25 April 2012 22:49
By: Kevin Meade
  Troublesome trigger
By: rishwinger on Mon, 23 April 2012
3 718 Wed, 25 April 2012 22:41
By: Kevin Meade
  Query on the performance of JOIN on indexed columns
Oracle 10.2.0.4
By: orapratap on Fri, 23 March 2012
4 1351 Wed, 25 April 2012 22:15
By: zengmuansha
  How to Tune Long running queries?
Oracle 10.2.0.4
By: orapratap on Wed, 11 April 2012
16 4209 Wed, 25 April 2012 07:41
By: bobbydurrettdba
icon7.gif how do oracle filter data?
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: zengmuansha on Sun, 22 April 2012
7 1062 Sun, 22 April 2012 22:31
By: BlackSwan
  Oracle Apps/Software installed in a dB Server
Oracle 11g, 11.2.0.2.0, AIX
By: reym21 on Thu, 22 March 2012
6 1363 Tue, 17 April 2012 01:59
By: John Watson
  query with high cpu usage
10.2.0.2
By: varunvir on Tue, 13 January 2009
14 4174 Mon, 16 April 2012 03:48
By: cookiemonster
  DB performance keys
By: Amine on Sat, 17 March 2012
8 1438 Mon, 16 April 2012 00:01
By: Kevin Meade
  ADDM report
Oracle 10.2.0.4.0,SunOS
By: Jack14 on Wed, 11 April 2012
10 2947 Sun, 15 April 2012 12:01
By: Jack14
  loop questions
Oracle 10.2.0.4.0 , AIX 5.3 64bit
By: snowball on Wed, 28 March 2012
3 847 Sun, 15 April 2012 01:35
By: Kevin Meade
  database statistics
By: priteshranjan.preet on Thu, 05 April 2012
2 944 Fri, 13 April 2012 08:14
By: priteshranjan.preet
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 Apr 25 06:18:22 CDT 2015

Total time taken to generate the page: 0.08559 seconds