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

    Replies Views Last message
  Decide on Partitioning Column/Purge Approach
Oracle 11g Release 2
By: azeem87 on Thu, 13 November 2014
9 5875 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 8877 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 6646 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 4809 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 4552 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 10073 Wed, 05 November 2014 02:35
By: ThomasG
  Query in Loop causing performance issue
11i
By: nishantranjan00787 on Fri, 10 October 2014
12 8539 Mon, 03 November 2014 00:48
By: michael_bialik
  SQL tuning advisor being retarted
By: aliyesami on Mon, 22 September 2014
6 5928 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 5531 Thu, 16 October 2014 04:09
By: gazzag
  Materialized view refresh thrashing DBWR
In post
By: Roachcoach on Tue, 23 September 2014
4 5488 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 9634 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 6496 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 15686 Fri, 10 October 2014 09:18
By: Kevin Meade
  improve performance for the query
Oracle 11g
By: sumanh on Wed, 08 October 2014
2 4542 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 4000 Fri, 03 October 2014 09:06
By: cookiemonster
icon4.gif Access Remote Data Slow
By: oasisin2014 on Sun, 28 September 2014
22 9140 Tue, 30 September 2014 13:56
By: oasisinsky
  Private message
By: John Watson on Sun, 28 September 2014
3 4479 Tue, 30 September 2014 06:18
By: pablolee
  Data PERFORMANCE ISSUES
LINUX 5.3 Oracle 11gr2
By: sakamboh on Sun, 28 September 2014
2 4072 Sun, 28 September 2014 21:57
By: lzfhope
icon5.gif How to tune a slow query
By: oasisin2014 on Fri, 26 September 2014
4 4834 Sat, 27 September 2014 11:22
By: Lalit Kumar B
  Db servers capacity
oracle
By: simplesanju on Tue, 23 September 2014
3 4446 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 6308 Fri, 19 September 2014 09:48
By: John Watson
  Query requires tuning
Oracle 11gr2, sun
By: AviatoR on Fri, 12 September 2014
13 7819 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 6224 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 5196 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 6481 Thu, 11 September 2014 13:12
By: John Watson
  Materialized view
oracle 11gr2
By: guddu_12 on Wed, 03 September 2014
5 4529 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 7049 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 4986 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 4346 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 4402 Wed, 20 August 2014 06:15
By: ishika_20
  Regarding sql id
11.2.0.4
By: varunvir on Mon, 18 August 2014
5 4284 Wed, 20 August 2014 02:46
By: cookiemonster
  oracle performance metrics
11g
By: andrewscharles89 on Mon, 18 August 2014
5 5295 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 4430 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 8690 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 5562 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 4012 Tue, 12 August 2014 21:23
By: BlackSwan
  Parallel Threads Waiting
By: scottwmackey on Thu, 07 August 2014
8 7577 Sat, 09 August 2014 12:20
By: scottwmackey
  Queries "break" after automatic statistic gathering.
11.2.0.3 / CentOS Linux
By: ThomasG on Fri, 01 August 2014
4 5297 Fri, 01 August 2014 13:34
By: Lalit Kumar B
  gather table stats
11.2.0.3, sun sol 10
By: AviatoR on Wed, 30 July 2014
8 6780 Thu, 31 July 2014 19:31
By: BlackSwan
  How to remove left join and ON JOIN from query and use better things in place of that
11i ( 1 2)
By: nishantranjan00787 on Mon, 21 July 2014
51 16352 Thu, 31 July 2014 05:50
By: John Watson
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 Mar 28 18:26:56 CDT 2024