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

    Replies Views Last message
  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 622 Tue, 28 June 2016 23:35
By: javed.khan
  Performance worse for given workflow query
11i
By: nishant87 on Wed, 22 June 2016
16 727 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 689 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 557 Tue, 14 June 2016 06:11
By: juniordbanewbie
  TOP_LEVEL_SQL_ID
Oracle 11.2.0.4, Windows 2008 Server
By: jesuisantony on Tue, 07 June 2016
8 1484 Fri, 27 January 2017 12:07
By: jesuisantony
  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 561 Wed, 08 June 2016 14:42
By: knw15pwr
  ora-01555 snapshot too old. Query executed 4000s
10g, 10.2.0.5, hp-unix
By: ashishkumarmahanta80 on Tue, 07 June 2016
4 932 Fri, 20 January 2017 10:58
By: Michel Cadot
  count(*) anomaly
DB 12.1.0.2, Windows 10
By: John Watson on Sat, 28 May 2016
5 621 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 697 Tue, 17 May 2016 03:20
By: Michel Cadot
  BULK INSERT PERFORMANCE ON PROD
Oracle 12c, RHEL 6
By: jesuisantony on Sat, 14 May 2016
7 1228 Mon, 30 January 2017 13:00
By: forums.sqltop
  SGA_MAX_SIZE and SGA_TARGET
Unix, ORacle 12C
By: ninan on Mon, 02 May 2016
16 1429 Thu, 05 May 2016 11:09
By: Michel Cadot
  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 1862 Tue, 07 June 2016 08:15
By: Kevin Meade
  Cluster table access IO is unexpected
11.2.0.4
By: Roachcoach on Thu, 28 April 2016
3 519 Fri, 29 April 2016 02:32
By: Roachcoach
  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 823 Fri, 15 April 2016 11:15
By: John Watson
  ASH data to identify CPU 100%
By: orausern on Fri, 15 April 2016
4 625 Fri, 15 April 2016 05:46
By: orausern
  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 6776 Sun, 17 April 2016 04:13
By: John Watson
  Taking more time to Drop interval Partitions
Oracle Enterprise,11.2.0.4,Solaris
By: eswararaodba@gmail.com on Sun, 10 April 2016
2 608 Sun, 10 April 2016 08:04
By: John Watson
  stale (local) index statistics on partitioned table
Oracle 12c
By: quirks on Wed, 06 April 2016
6 818 Wed, 06 April 2016 08:12
By: quirks
  How to calculate Index creation time
Oracle 11gr2 Linux
By: hitesh.bhatt on Wed, 06 April 2016
11 844 Sat, 09 April 2016 13:22
By: LNossov
  Performance tuning
Oracle 11g
By: lappi on Wed, 30 March 2016
7 943 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 520 Tue, 29 March 2016 07:44
By: John Watson
  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 940 Sun, 20 March 2016 20:24
By: juniordbanewbie
  Tablespace and Partition
Oracle 12C
By: deepakdot on Thu, 17 March 2016
2 560 Thu, 17 March 2016 04:56
By: deepakdot
  Long running Query
Windows, Oracle 11g
By: narendra_bagur on Fri, 11 March 2016
12 1300 Tue, 22 March 2016 03:45
By: Michel Cadot
  Query Optimization
Oracle SQL Devloper
By: Ranjeet29590 on Fri, 11 March 2016
4 1019 Sun, 13 March 2016 11:15
By: garan
icon12.gif improve sql performance (long sql here)
11g
By: marzbuzz on Thu, 10 March 2016
27 2638 Tue, 22 March 2016 09:22
By: michael_bialik
  How to deal with 'Free buffer waits' event
Oracle 11g R2 , Linux 64bit
By: kangfei on Sun, 13 March 2016
7 911 Mon, 14 March 2016 06:56
By: John Watson
  Size of SYSAUX is getting bigger
Oracle 10g R2 10.2.0.4
By: snehalgandhi on Wed, 02 March 2016
9 1023 Wed, 02 March 2016 03:17
By: Michel Cadot
  Select with Union Performance issue
Oracle 11g
By: emyk on Tue, 01 March 2016
3 787 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 2650 Tue, 23 February 2016 10:03
By: John Watson
  Tune query for Sum function
By: rohit_shinez on Wed, 03 February 2016
7 672 Wed, 03 February 2016 19:48
By: Kevin Meade
  Oracle SQL performance analysis
oracle 12c
By: gorants on Sun, 31 January 2016
2 802 Wed, 03 February 2016 20:04
By: Kevin Meade
  Wich index is used. Confusion in SQL-trace
Oracle 12.1.0.2.0
By: mats-larsson@iname.com on Mon, 25 January 2016
3 617 Mon, 25 January 2016 10:59
By: mats-larsson@iname.com
  Application slow down
Database 11.2.0.3.0
By: samiyabulushi on Sun, 24 January 2016
2 1264 Sun, 24 January 2016 03:10
By: samiyabulushi
  Oracle ROWID RANGE SCAN
AIX 6
By: sinida1984 on Wed, 20 January 2016
9 1522 Wed, 03 February 2016 20:14
By: Kevin Meade
  Oracle index creation
Oracle 10g
By: donep on Mon, 18 January 2016
13 9786 Wed, 10 February 2016 00:26
By: Kevin Meade
  Understanding oracle sql explain plan
12c
By: gorants on Mon, 18 January 2016
1 575 Mon, 18 January 2016 14:02
By: Michel Cadot
  Sql Query Tuning
11.2
By: mnraju999 on Mon, 11 January 2016
4 1150 Wed, 03 February 2016 20:23
By: Kevin Meade
  Parallel Server for Dummies Checklist
By: WolfBrother on Wed, 06 January 2016
2 575 Thu, 07 January 2016 01:08
By: John Watson
  dynamic sql
oracle 11.2.0.3
By: pointers on Sat, 09 January 2016
6 1224 Tue, 22 March 2016 09:31
By: BlackSwan
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 Nov 21 14:55:01 CST 2017

Total time taken to generate the page: 0.03166 seconds