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

    Replies Views Last message
icon10.gif code taking long amount of time to execute
ORACLE 11G
By: manoj12 on Fri, 03 October 2014
2 789 Fri, 03 October 2014 09:06
By: cookiemonster
  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 4819 Fri, 10 October 2014 09:18
By: Kevin Meade
  Data PERFORMANCE ISSUES
LINUX 5.3 Oracle 11gr2
By: sakamboh on Sun, 28 September 2014
2 595 Sun, 28 September 2014 21:57
By: lzfhope
  Private message
By: John Watson on Sun, 28 September 2014
3 801 Tue, 30 September 2014 06:18
By: pablolee
icon5.gif How to tune a slow query
By: oasisin2014 on Fri, 26 September 2014
4 806 Sat, 27 September 2014 11:22
By: Lalit Kumar B
  Db servers capacity
oracle
By: simplesanju on Tue, 23 September 2014
3 828 Wed, 24 September 2014 00:47
By: simplesanju
  Materialized view refresh thrashing DBWR
In post
By: Roachcoach on Tue, 23 September 2014
4 1554 Wed, 15 October 2014 04:38
By: Roachcoach
  SQL tuning advisor being retarted
By: aliyesami on Mon, 22 September 2014
6 1481 Thu, 23 October 2014 05:08
By: michael_bialik
  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 1176 Fri, 19 September 2014 09:48
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 947 Wed, 17 September 2014 06:21
By: orausern
  Query requires tuning
Oracle 11gr2, sun
By: AviatoR on Fri, 12 September 2014
13 2185 Fri, 19 September 2014 03:01
By: John Watson
  Auto stats job window details
Oracle 11.2.0.4 on Enterprise linux 6
By: suresh.wst on Thu, 11 September 2014
8 1187 Thu, 11 September 2014 13:12
By: John Watson
  dbms_addm.real_time_addm_report
DB 12.x
By: John Watson on Fri, 05 September 2014
8 1973 Sat, 06 September 2014 10:11
By: Lalit Kumar B
  Materialized view
oracle 11gr2
By: guddu_12 on Wed, 03 September 2014
5 953 Sun, 07 September 2014 00:27
By: Kevin Meade
  Update non-token column on compressed table
Oracle EE 11.2.0.2
By: d_seng on Thu, 28 August 2014
2 1197 Sun, 31 August 2014 05:18
By: d_seng
  High insertion on the database | Tuning parameters
Oracle 10g, Linux 64
By: abhoite on Tue, 26 August 2014
9 1295 Tue, 16 September 2014 23:01
By: trantuananh24hg
  sql query performance guide
Oracle 11.2.4.0 , SunOS
By: mc1825263 on Fri, 22 August 2014
2 815 Fri, 22 August 2014 01:00
By: mc1825263
  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 1961 Fri, 14 November 2014 05:54
By: d_seng
  explain plan details vary between display & display_cursor
11g, 11.2.0.3, solaris10
By: ishika_20 on Wed, 20 August 2014
6 998 Wed, 20 August 2014 06:15
By: ishika_20
  Regarding sql id
11.2.0.4
By: varunvir on Mon, 18 August 2014
5 1123 Wed, 20 August 2014 02:46
By: cookiemonster
  oracle performance metrics
11g
By: andrewscharles89 on Mon, 18 August 2014
5 845 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 1081 Thu, 14 August 2014 15:52
By: BlackSwan
  Reading byte data from BLOB vs File System
By: mafoe on Wed, 13 August 2014
5 1097 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 645 Tue, 12 August 2014 21:23
By: BlackSwan
  Parallel Threads Waiting
By: scottwmackey on Thu, 07 August 2014
8 1491 Sat, 09 August 2014 12:20
By: scottwmackey
  cache issue
11.2.0.2, WIndows 2008 R2
By: sant_new1 on Wed, 06 August 2014
12 1658 Thu, 14 August 2014 09:53
By: sant_new1
  Queries "break" after automatic statistic gathering.
11.2.0.3 / CentOS Linux
By: ThomasG on Fri, 01 August 2014
4 1275 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 1403 Thu, 31 July 2014 19:31
By: BlackSwan
icon4.gif Access Remote Data Slow
By: oasisin2014 on Sun, 28 September 2014
22 1949 Tue, 30 September 2014 13:56
By: oasisinsky
  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 4423 Thu, 31 July 2014 05:50
By: John Watson
  Partitioning on a VARCHAR2 column
11g
By: mafoe on Mon, 28 July 2014
6 1422 Tue, 29 July 2014 04:29
By: Roachcoach
  Performance issue
10.2.0.5.0
By: ramanaapps on Fri, 25 July 2014
16 1831 Sat, 26 July 2014 08:55
By: Kevin Meade
  After Table analyze, the number of blocks goes Down
Oracle 11gR2
By: hitesh.bhatt on Thu, 24 July 2014
7 995 Wed, 30 July 2014 04:14
By: hitesh.bhatt
  A question about SPM
11.2.0.4 on Linux
By: orausern on Thu, 24 July 2014
2 784 Thu, 24 July 2014 12:48
By: orausern
  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 2307 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 811 Wed, 16 July 2014 07:18
By: Michel Cadot
  Performance Tuning
11g
By: andrewscharles89 on Thu, 10 July 2014
11 1383 Tue, 22 July 2014 08:20
By: michael_bialik
  AWR and ASH report analyze
Oracle 10g,11g,Linux
By: Database admin on Mon, 07 July 2014
13 1419 Mon, 07 July 2014 10:46
By: Lalit Kumar B
  I/O calibration
By: John Watson on Wed, 02 July 2014
9 1338 Fri, 04 July 2014 06:34
By: Roachcoach
  Shameless plug
By: rleishman on Sat, 05 July 2014
5 1424 Sun, 06 July 2014 07:48
By: rleishman
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 19 06:29:46 CDT 2017

Total time taken to generate the page: 0.05091 seconds