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

    Replies Views Last message
  Tuning Multiple Not Exists
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: ricky_s on Mon, 22 August 2016
10 5056 Fri, 26 August 2016 01:00
By: Michel Cadot
  improve performance using partitioning
oracle 11g
By: tarundas2016 on Mon, 22 August 2016
3 2384 Tue, 23 August 2016 02:39
By: Roachcoach
  slow running sql
10g
By: arifmd1705 on Mon, 08 August 2016
16 4852 Sat, 13 August 2016 23:22
By: arifmd1705
  server session exceed
By: rameshrk0206@gmail.com on Mon, 08 August 2016
1 1897 Mon, 08 August 2016 01:30
By: Michel Cadot
  Data related to DB Metrics for a period
Oracle 11.2.0.4 on Linux
By: orausern on Thu, 04 August 2016
5 2455 Thu, 04 August 2016 03:52
By: John Watson
  Why rownum is not used in the query
By: samiran_cts on Tue, 02 August 2016
13 5260 Wed, 03 August 2016 08:14
By: cookiemonster
  Approach for Oracle Profiles to tune queries
Oracle 11.2.0.4 on LInux
By: orausern on Tue, 02 August 2016
4 2668 Tue, 02 August 2016 04:19
By: orausern
  consecutive executions
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: bibhuti037 on Wed, 27 July 2016
7 2853 Thu, 28 July 2016 02:24
By: pablolee
  Compare spatial and attributive query
Oracle Locator 11g
By: moehre on Tue, 05 July 2016
11 4171 Wed, 13 July 2016 03:55
By: Barbara Boehmer
  Whast is connect$_by$_pump$ in explain plan
Oracle Database 11g Release 11.2.0.3.0 - 64bit
By: javed.khan on Tue, 28 June 2016
1 2683 Tue, 28 June 2016 23:35
By: javed.khan
  Performance worse for given workflow query
11i
By: nishant87 on Wed, 22 June 2016
16 3967 Wed, 22 June 2016 09:48
By: John Watson
  How to make sure no archivelog being generated for a particular table
11.2.0.2 SE, windows 2008 r2
By: juniordbanewbie on Tue, 14 June 2016
10 2967 Tue, 14 June 2016 09:37
By: Michel Cadot
  Is there a way to find out a killed session associated sql
11.2.0.2,SE windows 2008 r2
By: juniordbanewbie on Tue, 14 June 2016
6 2765 Tue, 14 June 2016 06:11
By: juniordbanewbie
  Performance degrade after migration from 11g exadata to 12c
12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: knw15pwr on Tue, 07 June 2016
2 2320 Wed, 08 June 2016 14:42
By: knw15pwr
  LEFT OUTER JOIN of Large Tables - Performance issue
ORACLE, 12.1.0.2.0, WINDOWS 10
By: anil_mk on Thu, 28 April 2016
8 9620 Tue, 07 June 2016 08:15
By: Kevin Meade
  count(*) anomaly
DB 12.1.0.2, Windows 10
By: John Watson on Sat, 28 May 2016
5 2711 Sat, 28 May 2016 12:24
By: John Watson
  performance issue with oracle AQ while dequeueing the table
11.2.0.3 , 3 node-RAC, solaris 11
By: pavanintouch on Tue, 17 May 2016
1 3089 Tue, 17 May 2016 03:20
By: Michel Cadot
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
17 77083 Thu, 12 May 2016 17:38
By: valdba
  SGA_MAX_SIZE and SGA_TARGET
Unix, ORacle 12C
By: ninan on Mon, 02 May 2016
16 6251 Thu, 05 May 2016 11:09
By: Michel Cadot
  Cluster table access IO is unexpected
11.2.0.4
By: Roachcoach on Thu, 28 April 2016
3 2289 Fri, 29 April 2016 02:32
By: Roachcoach
  Performance Issue after upgrade to 11.2.0.4
Oracle Database, 11.2.0.4, RHEL 6.7 x64
By: sadiq106 on Fri, 15 April 2016
7 9788 Sun, 17 April 2016 04:13
By: John Watson
  What Is The Correct Formula For Buffer Cache Hit Ratio
11.2.0.4 SE, Redhat 7.1
By: juniordbanewbie on Fri, 15 April 2016
6 3221 Fri, 15 April 2016 11:15
By: John Watson
  ASH data to identify CPU 100%
By: orausern on Fri, 15 April 2016
4 2586 Fri, 15 April 2016 05:46
By: orausern
  Taking more time to Drop interval Partitions
Oracle Enterprise,11.2.0.4,Solaris
By: eswararaodba@gmail.com on Sun, 10 April 2016
2 2318 Sun, 10 April 2016 08:04
By: John Watson
  How to calculate Index creation time
Oracle 11gr2 Linux
By: hitesh.bhatt on Wed, 06 April 2016
11 3733 Sat, 09 April 2016 13:22
By: LNossov
  stale (local) index statistics on partitioned table
Oracle 12c
By: quirks on Wed, 06 April 2016
6 4509 Wed, 06 April 2016 08:12
By: quirks
  Performance tuning
Oracle 11g
By: lappi on Wed, 30 March 2016
7 3088 Thu, 31 March 2016 04:20
By: pablolee
  Clustering Factor for LOB Index_Type is NULL
Oracle 11gr2 RHEL
By: hitesh.bhatt on Tue, 29 March 2016
3 2243 Tue, 29 March 2016 07:44
By: John Watson
  dynamic sql
oracle 11.2.0.3
By: pointers on Sat, 09 January 2016
6 3289 Tue, 22 March 2016 09:31
By: BlackSwan
icon12.gif improve sql performance (long sql here)
11g
By: marzbuzz on Thu, 10 March 2016
27 7866 Tue, 22 March 2016 09:22
By: michael_bialik
  Long running Query
Windows, Oracle 11g
By: narendra_bagur on Fri, 11 March 2016
12 4834 Tue, 22 March 2016 03:45
By: Michel Cadot
  Why din table fetch continued row increase after fetching every columns
12.1.0.2.0 SLES SP3
By: juniordbanewbie on Fri, 18 March 2016
6 3390 Sun, 20 March 2016 20:24
By: juniordbanewbie
  Tablespace and Partition
Oracle 12C
By: deepakdot on Thu, 17 March 2016
2 2331 Thu, 17 March 2016 04:56
By: deepakdot
  How to deal with 'Free buffer waits' event
Oracle 11g R2 , Linux 64bit
By: kangfei on Sun, 13 March 2016
7 3814 Mon, 14 March 2016 06:56
By: John Watson
  Query Optimization
Oracle SQL Devloper
By: Ranjeet29590 on Fri, 11 March 2016
4 2910 Sun, 13 March 2016 11:15
By: garan
  Size of SYSAUX is getting bigger
Oracle 10g R2 10.2.0.4
By: snehalgandhi on Wed, 02 March 2016
9 4677 Wed, 02 March 2016 03:17
By: Michel Cadot
  Select with Union Performance issue
Oracle 11g
By: emyk on Tue, 01 March 2016
3 2707 Wed, 02 March 2016 02:59
By: cookiemonster
  Performance issue enq: TX index contention
Linux, Oracle 11g RAC
By: ninan on Tue, 23 February 2016
22 11029 Tue, 23 February 2016 10:03
By: John Watson
  Please help for Improving the Explain plan
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 08 December 2015
8 3481 Wed, 10 February 2016 00:30
By: Kevin Meade
  Oracle index creation
Oracle 10g
By: donep on Mon, 18 January 2016
13 13276 Wed, 10 February 2016 00:26
By: Kevin Meade
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: Sun Feb 28 01:21:19 CST 2021