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

    Replies Views Last message
  How to Optimise this query
Oracle 11G
By: tarundas2016 on Mon, 22 August 2016
3 621 Thu, 01 September 2016 04:10
By: Kevin Meade
  SQL Query - Just too big
11g
By: nathan59 on Thu, 01 September 2016
16 924 Thu, 01 September 2016 03:50
By: Kevin Meade
  Driving site hint on a single remote table
OEL 6.5,Oracle 10g
By: swas_recall on Thu, 01 September 2016
7 649 Thu, 01 September 2016 03:35
By: Michel Cadot
  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 1101 Fri, 26 August 2016 01:00
By: Michel Cadot
  improve performance using partitioning
oracle 11g
By: tarundas2016 on Mon, 22 August 2016
3 572 Tue, 23 August 2016 02:39
By: Roachcoach
  slow running sql
10g
By: arifmd1705 on Mon, 08 August 2016
16 1194 Sat, 13 August 2016 23:22
By: arifmd1705
  server session exceed
By: rameshrk0206@gmail.com on Mon, 08 August 2016
1 399 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 665 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 1313 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 560 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 758 Thu, 28 July 2016 02:24
By: pablolee
  Compare spatial and attributive query
Oracle Locator 11g
By: moehre on Tue, 05 July 2016
11 1455 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 664 Tue, 28 June 2016 23:35
By: javed.khan
  Performance worse for given workflow query
11i
By: nishant87 on Wed, 22 June 2016
16 790 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 744 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 599 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 599 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 2202 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 674 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 765 Tue, 17 May 2016 03:20
By: Michel Cadot
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
17 59766 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 1613 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 566 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 6906 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 892 Fri, 15 April 2016 11:15
By: John Watson
  ASH data to identify CPU 100%
By: orausern on Fri, 15 April 2016
4 674 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 655 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 907 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 937 Wed, 06 April 2016 08:12
By: quirks
  Performance tuning
Oracle 11g
By: lappi on Wed, 30 March 2016
7 1015 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 559 Tue, 29 March 2016 07:44
By: John Watson
  dynamic sql
oracle 11.2.0.3
By: pointers on Sat, 09 January 2016
6 1274 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 2713 Tue, 22 March 2016 09:22
By: michael_bialik
  Long running Query
Windows, Oracle 11g
By: narendra_bagur on Fri, 11 March 2016
12 1363 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 1010 Sun, 20 March 2016 20:24
By: juniordbanewbie
  Tablespace and Partition
Oracle 12C
By: deepakdot on Thu, 17 March 2016
2 595 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 993 Mon, 14 March 2016 06:56
By: John Watson
  Query Optimization
Oracle SQL Devloper
By: Ranjeet29590 on Fri, 11 March 2016
4 1071 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 1120 Wed, 02 March 2016 03:17
By: Michel Cadot
  Select with Union Performance issue
Oracle 11g
By: emyk on Tue, 01 March 2016
3 842 Wed, 02 March 2016 02:59
By: cookiemonster
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 18 18:30:16 CST 2018

Total time taken to generate the page: 0.01643 seconds