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

    Replies Views Last message
  MR (Metadata Repository) SQL caused poor performance
Oracle Portal 10g, OID, IAS, Windows x86_64
By: trantuananh24hg on Wed, 14 September 2016
5 510 Thu, 15 September 2016 22:54
By: trantuananh24hg
  Improve query execution times
oracle 12c
By: gorants on Thu, 01 September 2016
4 604 Sat, 03 September 2016 02:13
By: John Watson
  Commit interval
Oracle 11g, Unix
By: ninan on Sat, 20 August 2016
11 1048 Thu, 01 September 2016 04:58
By: John Watson
  How to Optimise this query
Oracle 11G
By: tarundas2016 on Mon, 22 August 2016
3 415 Thu, 01 September 2016 04:10
By: Kevin Meade
  SQL Query - Just too big
11g
By: nathan59 on Thu, 01 September 2016
16 511 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 344 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 760 Fri, 26 August 2016 01:00
By: Michel Cadot
  improve performance using partitioning
oracle 11g
By: tarundas2016 on Mon, 22 August 2016
3 383 Tue, 23 August 2016 02:39
By: Roachcoach
  slow running sql
10g
By: arifmd1705 on Mon, 08 August 2016
16 901 Sat, 13 August 2016 23:22
By: arifmd1705
  server session exceed
By: rameshrk0206@gmail.com on Mon, 08 August 2016
1 283 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 502 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 1063 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 377 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 545 Thu, 28 July 2016 02:24
By: pablolee
  Compare spatial and attributive query
Oracle Locator 11g
By: moehre on Tue, 05 July 2016
11 1165 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 512 Tue, 28 June 2016 23:35
By: javed.khan
  Performance worse for given workflow query
11i
By: nishant87 on Wed, 22 June 2016
16 583 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 516 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 422 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 426 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 902 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 479 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 491 Tue, 17 May 2016 03:20
By: Michel Cadot
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
17 49666 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 985 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 409 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 6387 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 598 Fri, 15 April 2016 11:15
By: John Watson
  ASH data to identify CPU 100%
By: orausern on Fri, 15 April 2016
4 460 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 495 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 660 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 560 Wed, 06 April 2016 08:12
By: quirks
  Performance tuning
Oracle 11g
By: lappi on Wed, 30 March 2016
7 746 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 410 Tue, 29 March 2016 07:44
By: John Watson
  dynamic sql
oracle 11.2.0.3
By: pointers on Sat, 09 January 2016
6 1057 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 2352 Tue, 22 March 2016 09:22
By: michael_bialik
  Long running Query
Windows, Oracle 11g
By: narendra_bagur on Fri, 11 March 2016
12 1117 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 713 Sun, 20 March 2016 20:24
By: juniordbanewbie
  Tablespace and Partition
Oracle 12C
By: deepakdot on Thu, 17 March 2016
2 477 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 715 Mon, 14 March 2016 06:56
By: John Watson
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: Tue Feb 21 10:32:01 CST 2017

Total time taken to generate the page: 0.05920 seconds