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

    Replies Views Last message
  Please help me to understand why the query works longer of server_A than on server_B
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
By: ecivgamer on Wed, 26 November 2014
10 1862 Thu, 27 November 2014 06:22
By: ecivgamer
  A question about execution plan
Oracle 11.2.0.4. on Linux
By: orausern on Tue, 25 November 2014
2 1009 Tue, 25 November 2014 12:52
By: orausern
  Index vs Full table scan on sysdate
11.2.0.3,Linux X86_64
By: preet_kumar on Wed, 12 November 2014
7 1399 Tue, 25 November 2014 08:38
By: Andrey_R
  Decide on Partitioning Column/Purge Approach
Oracle 11g Release 2
By: azeem87 on Thu, 13 November 2014
9 1632 Fri, 14 November 2014 08:33
By: cookiemonster
  Logging operation takes longer but no wait events
Oracle 11.2.0.4 EE, Linux 64 bit
By: d_seng on Mon, 01 September 2014
15 3095 Fri, 14 November 2014 05:54
By: d_seng
icon5.gif Cursor: Pin S Wait on X
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
By: ecivgamer on Thu, 13 November 2014
4 2230 Fri, 14 November 2014 03:44
By: Michel Cadot
  PGA_AGREGATE_TARGET parameter
Oracle11g 11.2.0.3
By: shrinika on Mon, 10 November 2014
4 1441 Tue, 11 November 2014 12:35
By: Michel Cadot
  Plan missing from cursor cache
Oracle 12.1 ,OEL 6
By: gkrishn on Sun, 09 November 2014
2 1178 Sun, 09 November 2014 03:10
By: gkrishn
  Delete taking long due to index maintenance?
Oracle 11.2.0.3 / CentOS
By: ThomasG on Thu, 30 October 2014
14 3043 Wed, 05 November 2014 02:35
By: ThomasG
  Query in Loop causing performance issue
11i
By: nishantranjan00787 on Fri, 10 October 2014
12 2910 Mon, 03 November 2014 00:48
By: michael_bialik
  SQL tuning advisor being retarted
By: aliyesami on Mon, 22 September 2014
6 1962 Thu, 23 October 2014 05:08
By: michael_bialik
  Table creation with nologging clause is stopped in between
10g, 10.2.0.4, hp unix
By: ashishkumarmahanta80 on Wed, 15 October 2014
7 1361 Thu, 16 October 2014 04:09
By: gazzag
  Materialized view refresh thrashing DBWR
In post
By: Roachcoach on Tue, 23 September 2014
4 1984 Wed, 15 October 2014 04:38
By: Roachcoach
  Need to tune package.
Oracle 11.2.0.3.0
By: swap19 on Sat, 11 October 2014
18 2837 Mon, 13 October 2014 01:49
By: John Watson
  Default value of SEND_BUF_SIZE and RECV_BUF_SIZE for IBM Aix 7
Aix 7
By: morad_dba on Sun, 12 October 2014
1 2449 Sun, 12 October 2014 09:31
By: BlackSwan
  Query chooses bitmap index and runs slower
11.2.0.2/11.2.0.4 Enterprise, RHL
By: d_seng on Wed, 01 October 2014
27 6560 Fri, 10 October 2014 09:18
By: Kevin Meade
  improve performance for the query
Oracle 11g
By: sumanh on Wed, 08 October 2014
2 1284 Wed, 08 October 2014 02:12
By: flyboy
icon10.gif code taking long amount of time to execute
ORACLE 11G
By: manoj12 on Fri, 03 October 2014
2 1047 Fri, 03 October 2014 09:06
By: cookiemonster
icon4.gif Access Remote Data Slow
By: oasisin2014 on Sun, 28 September 2014
22 3117 Tue, 30 September 2014 13:56
By: oasisinsky
  Private message
By: John Watson on Sun, 28 September 2014
3 1047 Tue, 30 September 2014 06:18
By: pablolee
  Data PERFORMANCE ISSUES
LINUX 5.3 Oracle 11gr2
By: sakamboh on Sun, 28 September 2014
2 839 Sun, 28 September 2014 21:57
By: lzfhope
icon5.gif How to tune a slow query
By: oasisin2014 on Fri, 26 September 2014
4 1153 Sat, 27 September 2014 11:22
By: Lalit Kumar B
  Db servers capacity
oracle
By: simplesanju on Tue, 23 September 2014
3 1142 Wed, 24 September 2014 00:47
By: simplesanju
  Is there a way to monitor historical locks in Standard Edition
11.2.0.3 SE, 11.2.0.3 EE,
By: kytemanaic on Fri, 19 September 2014
1 1676 Fri, 19 September 2014 09:48
By: John Watson
  Query requires tuning
Oracle 11gr2, sun
By: AviatoR on Fri, 12 September 2014
13 2828 Fri, 19 September 2014 03:01
By: John Watson
  sql_id of a sql not the same in different databases
Oracle 11.2.0.4 on Linux.
By: orausern on Wed, 17 September 2014
7 1405 Wed, 17 September 2014 06:21
By: orausern
  High insertion on the database | Tuning parameters
Oracle 10g, Linux 64
By: abhoite on Tue, 26 August 2014
9 1739 Tue, 16 September 2014 23:01
By: trantuananh24hg
  Auto stats job window details
Oracle 11.2.0.4 on Enterprise linux 6
By: suresh.wst on Thu, 11 September 2014
8 1866 Thu, 11 September 2014 13:12
By: John Watson
  Materialized view
oracle 11gr2
By: guddu_12 on Wed, 03 September 2014
5 1303 Sun, 07 September 2014 00:27
By: Kevin Meade
  dbms_addm.real_time_addm_report
DB 12.x
By: John Watson on Fri, 05 September 2014
8 2738 Sat, 06 September 2014 10:11
By: Lalit Kumar B
  Update non-token column on compressed table
Oracle EE 11.2.0.2
By: d_seng on Thu, 28 August 2014
2 1563 Sun, 31 August 2014 05:18
By: d_seng
  sql query performance guide
Oracle 11.2.4.0 , SunOS
By: mc1825263 on Fri, 22 August 2014
2 1100 Fri, 22 August 2014 01:00
By: mc1825263
  explain plan details vary between display & display_cursor
11g, 11.2.0.3, solaris10
By: ishika_20 on Wed, 20 August 2014
6 1372 Wed, 20 August 2014 06:15
By: ishika_20
  Regarding sql id
11.2.0.4
By: varunvir on Mon, 18 August 2014
5 1432 Wed, 20 August 2014 02:46
By: cookiemonster
  oracle performance metrics
11g
By: andrewscharles89 on Mon, 18 August 2014
5 1330 Mon, 18 August 2014 10:07
By: Lalit Kumar B
  view slowness..
11.2.0.2, WIndows 2008 R2
By: sant_new1 on Thu, 14 August 2014
4 1395 Thu, 14 August 2014 15:52
By: BlackSwan
  cache issue
11.2.0.2, WIndows 2008 R2
By: sant_new1 on Wed, 06 August 2014
12 2891 Thu, 14 August 2014 09:53
By: sant_new1
  Reading byte data from BLOB vs File System
By: mafoe on Wed, 13 August 2014
5 1549 Wed, 13 August 2014 08:16
By: Michel Cadot
  How to calculate ROI on performance gain
Oracle 11gr2, sun
By: AviatoR on Tue, 12 August 2014
3 932 Tue, 12 August 2014 21:23
By: BlackSwan
  Parallel Threads Waiting
By: scottwmackey on Thu, 07 August 2014
8 2047 Sat, 09 August 2014 12:20
By: scottwmackey
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 18 09:34:43 CDT 2018