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

    Replies Views Last message
  improve performance using partitioning
oracle 11g
By: tarundas2016 on Mon, 22 August 2016
3 534 Tue, 23 August 2016 02:39
By: Roachcoach
  slow running sql
10g
By: arifmd1705 on Mon, 08 August 2016
16 1144 Sat, 13 August 2016 23:22
By: arifmd1705
  server session exceed
By: rameshrk0206@gmail.com on Mon, 08 August 2016
1 372 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 636 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 1270 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 518 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 718 Thu, 28 July 2016 02:24
By: pablolee
  Compare spatial and attributive query
Oracle Locator 11g
By: moehre on Tue, 05 July 2016
11 1404 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 629 Tue, 28 June 2016 23:35
By: javed.khan
  Performance worse for given workflow query
11i
By: nishant87 on Wed, 22 June 2016
16 734 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 707 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 567 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 575 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 1943 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 639 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 720 Tue, 17 May 2016 03:20
By: Michel Cadot
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
17 56944 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 1470 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 529 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 6806 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 841 Fri, 15 April 2016 11:15
By: John Watson
  ASH data to identify CPU 100%
By: orausern on Fri, 15 April 2016
4 634 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 624 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 857 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 847 Wed, 06 April 2016 08:12
By: quirks
  Performance tuning
Oracle 11g
By: lappi on Wed, 30 March 2016
7 958 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 529 Tue, 29 March 2016 07:44
By: John Watson
  dynamic sql
oracle 11.2.0.3
By: pointers on Sat, 09 January 2016
6 1235 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 2653 Tue, 22 March 2016 09:22
By: michael_bialik
  Long running Query
Windows, Oracle 11g
By: narendra_bagur on Fri, 11 March 2016
12 1313 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 959 Sun, 20 March 2016 20:24
By: juniordbanewbie
  Tablespace and Partition
Oracle 12C
By: deepakdot on Thu, 17 March 2016
2 570 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 934 Mon, 14 March 2016 06:56
By: John Watson
  Query Optimization
Oracle SQL Devloper
By: Ranjeet29590 on Fri, 11 March 2016
4 1037 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 1047 Wed, 02 March 2016 03:17
By: Michel Cadot
  Select with Union Performance issue
Oracle 11g
By: emyk on Tue, 01 March 2016
3 799 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 2751 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 1346 Wed, 10 February 2016 00:30
By: Kevin Meade
  Oracle index creation
Oracle 10g
By: donep on Mon, 18 January 2016
13 9797 Wed, 10 February 2016 00:26
By: Kevin Meade
  Please help for Improving Query Performance
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: msol25 on Tue, 15 December 2015
31 1570 Wed, 03 February 2016 20:57
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: Tue Dec 12 10:48:59 CST 2017

Total time taken to generate the page: 0.03739 seconds