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

    Replies Views Last message
  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 1999 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 8186 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 2415 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 2537 Tue, 17 May 2016 03:20
By: Michel Cadot
  ORA-03137
11.1.0.6.0
By: AlinaC on Tue, 11 May 2010
17 74267 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 5716 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 1979 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 9316 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 2942 Fri, 15 April 2016 11:15
By: John Watson
  ASH data to identify CPU 100%
By: orausern on Fri, 15 April 2016
4 2222 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 1917 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 3353 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 3833 Wed, 06 April 2016 08:12
By: quirks
  Performance tuning
Oracle 11g
By: lappi on Wed, 30 March 2016
7 2816 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 1872 Tue, 29 March 2016 07:44
By: John Watson
  dynamic sql
oracle 11.2.0.3
By: pointers on Sat, 09 January 2016
6 2956 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 7522 Tue, 22 March 2016 09:22
By: michael_bialik
  Long running Query
Windows, Oracle 11g
By: narendra_bagur on Fri, 11 March 2016
12 4464 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 2940 Sun, 20 March 2016 20:24
By: juniordbanewbie
  Tablespace and Partition
Oracle 12C
By: deepakdot on Thu, 17 March 2016
2 1961 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 3261 Mon, 14 March 2016 06:56
By: John Watson
  Query Optimization
Oracle SQL Devloper
By: Ranjeet29590 on Fri, 11 March 2016
4 2516 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 4071 Wed, 02 March 2016 03:17
By: Michel Cadot
  Select with Union Performance issue
Oracle 11g
By: emyk on Tue, 01 March 2016
3 2268 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 10228 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 3173 Wed, 10 February 2016 00:30
By: Kevin Meade
  Oracle index creation
Oracle 10g
By: donep on Mon, 18 January 2016
13 12689 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 5900 Wed, 03 February 2016 20:57
By: Kevin Meade
  Sql Query Tuning
11.2
By: mnraju999 on Mon, 11 January 2016
4 3385 Wed, 03 February 2016 20:23
By: Kevin Meade
  Oracle ROWID RANGE SCAN
AIX 6
By: sinida1984 on Wed, 20 January 2016
9 6286 Wed, 03 February 2016 20:14
By: Kevin Meade
  Oracle SQL performance analysis
oracle 12c
By: gorants on Sun, 31 January 2016
2 2542 Wed, 03 February 2016 20:04
By: Kevin Meade
  Tune query for Sum function
By: rohit_shinez on Wed, 03 February 2016
7 2540 Wed, 03 February 2016 19:48
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 2031 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 4476 Sun, 24 January 2016 03:10
By: samiyabulushi
  Understanding oracle sql explain plan
12c
By: gorants on Mon, 18 January 2016
1 1849 Mon, 18 January 2016 14:02
By: Michel Cadot
  Parallel Server for Dummies Checklist
By: WolfBrother on Wed, 06 January 2016
2 1987 Thu, 07 January 2016 01:08
By: John Watson
  Insert from Select - Performance Issue
Oracle 11 g
By: ram50958 on Thu, 20 August 2015
8 3130 Tue, 05 January 2016 23:36
By: garan
  Materialized View
Oracle 11g-Windows
By: arunOracle on Thu, 31 December 2015
4 3023 Fri, 01 January 2016 11:42
By: John Watson
  use_concat hint
DB12.1.0.2
By: John Watson on Wed, 23 December 2015
3 2877 Thu, 24 December 2015 04:22
By: Alien
  Database slowness and high load due to IO Latencies?
Oracle 11.2.0.4 on Linux
By: orausern on Thu, 10 December 2015
9 3148 Tue, 15 December 2015 04:12
By: Roachcoach
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 May 31 08:29:42 CDT 2020