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

    Replies Views Last message
  Table creation with nologging clause is stopped in between
10g, 10.2.0.4, hp unix
By: ashishkumarmahanta80 on Wed, 15 October 2014
7 4515 Thu, 16 October 2014 04:09
By: gazzag
  Materialized view refresh thrashing DBWR
In post
By: Roachcoach on Tue, 23 September 2014
4 4544 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 8237 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 5335 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 13902 Fri, 10 October 2014 09:18
By: Kevin Meade
  improve performance for the query
Oracle 11g
By: sumanh on Wed, 08 October 2014
2 3469 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 3140 Fri, 03 October 2014 09:06
By: cookiemonster
icon4.gif Access Remote Data Slow
By: oasisin2014 on Sun, 28 September 2014
22 7980 Tue, 30 September 2014 13:56
By: oasisinsky
  Private message
By: John Watson on Sun, 28 September 2014
3 3413 Tue, 30 September 2014 06:18
By: pablolee
  Data PERFORMANCE ISSUES
LINUX 5.3 Oracle 11gr2
By: sakamboh on Sun, 28 September 2014
2 3110 Sun, 28 September 2014 21:57
By: lzfhope
icon5.gif How to tune a slow query
By: oasisin2014 on Fri, 26 September 2014
4 3873 Sat, 27 September 2014 11:22
By: Lalit Kumar B
  Db servers capacity
oracle
By: simplesanju on Tue, 23 September 2014
3 3560 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 5108 Fri, 19 September 2014 09:48
By: John Watson
  Query requires tuning
Oracle 11gr2, sun
By: AviatoR on Fri, 12 September 2014
13 6633 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 4894 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 4245 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 5520 Thu, 11 September 2014 13:12
By: John Watson
  Materialized view
oracle 11gr2
By: guddu_12 on Wed, 03 September 2014
5 3650 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 6072 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 4109 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 3505 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 3606 Wed, 20 August 2014 06:15
By: ishika_20
  Regarding sql id
11.2.0.4
By: varunvir on Mon, 18 August 2014
5 3437 Wed, 20 August 2014 02:46
By: cookiemonster
  oracle performance metrics
11g
By: andrewscharles89 on Mon, 18 August 2014
5 4437 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 3591 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 7580 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 4431 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 3129 Tue, 12 August 2014 21:23
By: BlackSwan
  Parallel Threads Waiting
By: scottwmackey on Thu, 07 August 2014
8 6159 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 4211 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 5848 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 13939 Thu, 31 July 2014 05:50
By: John Watson
  After Table analyze, the number of blocks goes Down
Oracle 11gR2
By: hitesh.bhatt on Thu, 24 July 2014
7 3965 Wed, 30 July 2014 04:14
By: hitesh.bhatt
  Partitioning on a VARCHAR2 column
11g
By: mafoe on Mon, 28 July 2014
6 5273 Tue, 29 July 2014 04:29
By: Roachcoach
  Performance issue
10.2.0.5.0
By: ramanaapps on Fri, 25 July 2014
16 8408 Sat, 26 July 2014 08:55
By: Kevin Meade
  A question about SPM
11.2.0.4 on Linux
By: orausern on Thu, 24 July 2014
2 3288 Thu, 24 July 2014 12:48
By: orausern
  performance lag of the quey
11g
By: andrewscharles89 on Tue, 01 July 2014
17 6623 Thu, 24 July 2014 11:36
By: LNossov
  Performance Tuning
11g
By: andrewscharles89 on Thu, 10 July 2014
11 5515 Tue, 22 July 2014 08:20
By: michael_bialik
  How to revert the work done by accept_sql_profile procedure & Issues to watch out with SPM (merged)
Oracle 11.2.0.4 on Linux
By: orausern on Mon, 14 July 2014
20 10821 Wed, 16 July 2014 11:16
By: orausern
  Oracle 11g on VMWARE
Oracle 11g, Windows Server 2008
By: josephmaan on Wed, 16 July 2014
3 3345 Wed, 16 July 2014 07:18
By: Michel Cadot
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 Nov 26 22:18:12 CST 2022