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

    Replies Views Last message
icon6.gif sticky: How to tune SQL or Identify Performance Problem and Bottleneck
By: Michel Cadot on Fri, 22 June 2007
6 58909 Thu, 22 August 2013 04:09
By: Michel Cadot
  SQL tuning advisor being retarted
By: aliyesami on Mon, 22 September 2014
6 759 Thu, 23 October 2014 05:08
By: michael_bialik
  Query in Loop causing performance issue
11i
By: nishantranjan00787 on Fri, 10 October 2014
3 555 Thu, 23 October 2014 04:26
By: Lalit Kumar B
Inactive Threads issue has been moved to Weblogic & Application Server by the moderator.
  Table creation with nologging clause is stopped in between
10g, 10.2.0.4, hp unix
By: ashishkumarmahanta80 on Wed, 15 October 2014
7 383 Thu, 16 October 2014 04:09
By: gazzag
  Materialized view refresh thrashing DBWR
In post
By: Roachcoach on Tue, 23 September 2014
4 657 Wed, 15 October 2014 04:38
By: Roachcoach
Temp tablespace size has been moved to Server Administration by the moderator.
  Need to tune package.
Oracle 11.2.0.3.0
By: swap19 on Sat, 11 October 2014
18 871 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 394 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 2600 Fri, 10 October 2014 09:18
By: Kevin Meade
  improve performance for the query
Oracle 11g
By: sumanh on Wed, 08 October 2014
2 509 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 332 Fri, 03 October 2014 09:06
By: cookiemonster
icon4.gif Access Remote Data Slow
By: oasisin2014 on Sun, 28 September 2014
22 1171 Tue, 30 September 2014 13:56
By: oasisinsky
  Private message
By: John Watson on Sun, 28 September 2014
3 294 Tue, 30 September 2014 06:18
By: pablolee
  Data PERFORMANCE ISSUES
LINUX 5.3 Oracle 11gr2
By: sakamboh on Sun, 28 September 2014
2 203 Sun, 28 September 2014 21:57
By: lzfhope
icon5.gif How to tune a slow query
By: oasisin2014 on Fri, 26 September 2014
4 351 Sat, 27 September 2014 11:22
By: Lalit Kumar B
  Db servers capacity
oracle
By: simplesanju on Tue, 23 September 2014
3 491 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 337 Fri, 19 September 2014 09:48
By: John Watson
  Query requires tuning
Oracle 11gr2, sun
By: AviatoR on Fri, 12 September 2014
13 1278 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 385 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 591 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 439 Thu, 11 September 2014 13:12
By: John Watson
  Materialized view
oracle 11gr2
By: guddu_12 on Wed, 03 September 2014
5 509 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 551 Sat, 06 September 2014 10:11
By: Lalit Kumar B
  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
11 667 Tue, 02 September 2014 02:56
By: John Watson
  Update non-token column on compressed table
Oracle EE 11.2.0.2
By: d_seng on Thu, 28 August 2014
2 514 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 438 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 511 Wed, 20 August 2014 06:15
By: ishika_20
  Regarding sql id
11.2.0.4
By: varunvir on Mon, 18 August 2014
5 647 Wed, 20 August 2014 02:46
By: cookiemonster
  oracle performance metrics
11g
By: andrewscharles89 on Mon, 18 August 2014
5 347 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 699 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 710 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 508 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 266 Tue, 12 August 2014 21:23
By: BlackSwan
  Parallel Threads Waiting
By: scottwmackey on Thu, 07 August 2014
8 778 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 651 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 466 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 2989 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 553 Wed, 30 July 2014 04:14
By: hitesh.bhatt
  Partitioning on a VARCHAR2 column
11g
By: mafoe on Mon, 28 July 2014
6 835 Tue, 29 July 2014 04:29
By: Roachcoach
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: Fri Oct 24 23:25:30 CDT 2014

Total time taken to generate the page: 0.12673 seconds