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 2987 Fri, 03 October 2014 09:06
By: cookiemonster
icon4.gif Access Remote Data Slow
By: oasisin2014 on Sun, 28 September 2014
22 7741 Tue, 30 September 2014 13:56
By: oasisinsky
  Private message
By: John Watson on Sun, 28 September 2014
3 3104 Tue, 30 September 2014 06:18
By: pablolee
  Data PERFORMANCE ISSUES
LINUX 5.3 Oracle 11gr2
By: sakamboh on Sun, 28 September 2014
2 2892 Sun, 28 September 2014 21:57
By: lzfhope
icon5.gif How to tune a slow query
By: oasisin2014 on Fri, 26 September 2014
4 3636 Sat, 27 September 2014 11:22
By: Lalit Kumar B
  Db servers capacity
oracle
By: simplesanju on Tue, 23 September 2014
3 3356 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 4859 Fri, 19 September 2014 09:48
By: John Watson
  Query requires tuning
Oracle 11gr2, sun
By: AviatoR on Fri, 12 September 2014
13 6282 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 4637 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 4086 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 5306 Thu, 11 September 2014 13:12
By: John Watson
  Materialized view
oracle 11gr2
By: guddu_12 on Wed, 03 September 2014
5 3498 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 5850 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 3969 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 3371 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 3423 Wed, 20 August 2014 06:15
By: ishika_20
  Regarding sql id
11.2.0.4
By: varunvir on Mon, 18 August 2014
5 3294 Wed, 20 August 2014 02:46
By: cookiemonster
  oracle performance metrics
11g
By: andrewscharles89 on Mon, 18 August 2014
5 4286 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 3470 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 7340 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 4156 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 2935 Tue, 12 August 2014 21:23
By: BlackSwan
  Parallel Threads Waiting
By: scottwmackey on Thu, 07 August 2014
8 5612 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 3912 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 5643 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 13571 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 3644 Wed, 30 July 2014 04:14
By: hitesh.bhatt
  Partitioning on a VARCHAR2 column
11g
By: mafoe on Mon, 28 July 2014
6 4771 Tue, 29 July 2014 04:29
By: Roachcoach
  Performance issue
10.2.0.5.0
By: ramanaapps on Fri, 25 July 2014
16 7731 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 3130 Thu, 24 July 2014 12:48
By: orausern
  performance lag of the quey
11g
By: andrewscharles89 on Tue, 01 July 2014
17 6467 Thu, 24 July 2014 11:36
By: LNossov
  Performance Tuning
11g
By: andrewscharles89 on Thu, 10 July 2014
11 5337 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 10531 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 3178 Wed, 16 July 2014 07:18
By: Michel Cadot
  Query Performance
Oracle 11g
By: rohan10k on Tue, 17 June 2014
3 3531 Sat, 12 July 2014 02:09
By: Kevin Meade
  How about performance using index on the column which is using in WHERE and SET clause.
Oracle 11g
By: ramya_162 on Wed, 18 June 2014
3 4247 Sat, 12 July 2014 02:03
By: Kevin Meade
  AWR and ASH report analyze
Oracle 10g,11g,Linux
By: Database admin on Mon, 07 July 2014
13 5690 Mon, 07 July 2014 10:46
By: Lalit Kumar B
  Shameless plug
By: rleishman on Sat, 05 July 2014
5 5317 Sun, 06 July 2014 07:48
By: rleishman
  I/O calibration
By: John Watson on Wed, 02 July 2014
9 4568 Fri, 04 July 2014 06:34
By: Roachcoach
  Table Shrink Space and Performance
11g Standard Edition,Linux x86_64
By: preet_kumar on Mon, 16 June 2014
11 5293 Tue, 01 July 2014 08:10
By: martens_b2014
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 May 20 06:23:04 CDT 2022