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

    Replies Views Last message
icon6.gif sticky: How to tune SQL or Identify Performance Problem and Bottleneck
By: Michel Cadot on Fri, 22 June 2007
7 80704 Sat, 07 March 2015 12:25
By: Kevin Meade
icon5.gif Oracle Text index column when searching multiple tables
12.1.0.2.0
By: LFranz on Fri, 27 April 2018
5 1955 Fri, 15 June 2018 21:00
By: Barbara Boehmer
  Wrong plan chosen by optimizer
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production OEL 6
By: Andrey_R on Wed, 30 May 2018
11 634 Wed, 30 May 2018 09:32
By: Andrey_R
  Used Left Join - Query goes for Full Table scan
Oracle 11.2
By: saravanantgu on Fri, 25 May 2018
5 617 Tue, 29 May 2018 09:14
By: saravanantgu
  join is slow
Oracle12g
By: Buchas on Fri, 25 May 2018
1 494 Tue, 29 May 2018 01:39
By: Buchas
  Wrong plan chosen by optimizer
Oracle 11.1.0.6 , OEL 6
By: Andrey_R on Tue, 22 May 2018
14 458 Wed, 23 May 2018 08:03
By: Andrey_R
  Distinct query taking long time to run
Oracle 11.2,Linux 6
By: senmng on Thu, 10 May 2018
7 1327 Tue, 22 May 2018 14:17
By: senmng
  ORA-07445: exception encountered: core dump [audplsfailure()+54]
Oracle DB 11.2.0.4 OS: Redhat Linux 6.9 64 Bit
By: suhaspdba on Tue, 15 May 2018
4 683 Tue, 15 May 2018 11:25
By: Michel Cadot
  Stored procedure taking long time to run
Oracle 11.2, Linux v6
By: senmng on Thu, 03 May 2018
4 1292 Tue, 08 May 2018 10:17
By: BlackSwan
  Update Query Performance
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
By: kangula17 on Wed, 02 May 2018
2 814 Thu, 03 May 2018 00:49
By: John Watson
  A case need to help clear
Oracle 11.2.0.4, any platform
By: trantuananh24hg on Wed, 21 March 2018
12 2762 Thu, 19 April 2018 05:03
By: John Watson
  Remove Merge cartesian Join
Oracle 10g
By: pradies on Wed, 11 April 2018
1 829 Wed, 11 April 2018 08:46
By: John Watson
  Finding downgraded sql
Oracle 12.1.0.2
By: LarsFranzen on Thu, 05 April 2018
2 801 Thu, 05 April 2018 10:14
By: John Watson
  Is there a way to find out activities due to redo logs
11.2.0.4 Windows 2008 R2 Data Center
By: juniordbanewbie on Sun, 10 September 2017
15 50041 Wed, 04 April 2018 23:52
By: juniordbanewbie
  Better query for max(date) per account in big table
12.1.0.2.0
By: nciteamo on Tue, 03 April 2018
15 1549 Tue, 03 April 2018 08:10
By: Roachcoach
  Fine Tune Big SQL Reporting Query
By: dinavahi.saradhi@gmail.co on Fri, 30 March 2018
6 1392 Sun, 01 April 2018 16:18
By: dinavahi.saradhi@gmail.co
  Direct path load insert take much longer than query inside it
12.1.0.2.0
By: nciteamo on Wed, 28 March 2018
4 1314 Thu, 29 March 2018 08:33
By: Roachcoach
  Incosistent Wait Event
12.1.0.2.0
By: nciteamo on Thu, 29 March 2018
6 843 Thu, 29 March 2018 05:06
By: Roachcoach
  optimzer dynmic smpling
By: elixir86 on Wed, 28 March 2018
9 1121 Thu, 29 March 2018 02:34
By: John Watson
  Oracle Golden gate- Compression tables
Oracle 12CR2
By: srinivas.k2005 on Fri, 16 March 2018
4 1768 Thu, 29 March 2018 02:24
By: Roachcoach
  Reorganizing index datafiles with tables in partition (merged)
Oracle 10g 10.2.0.5, RHEL 6.2
By: reym21 on Mon, 26 March 2018
11 1886 Wed, 28 March 2018 08:34
By: JPBoileau
  SQL Query performance Tuning
RDBMS : 11.2.0.4.0
By: saketsingare on Thu, 08 March 2018
9 1923 Tue, 13 March 2018 09:21
By: msol25
  Partitioning in table
Oracle 11gr2 rhel
By: dba4oracle on Fri, 23 February 2018
15 2344 Mon, 26 February 2018 09:55
By: Roachcoach
  How long lock should be in order to take snapshot of locks
11.2.0.4, windows 2012 SE
By: juniordbanewbie on Tue, 24 January 2017
6 1549 Thu, 08 February 2018 02:49
By: juniordbanewbie
  Can we delete specific execution plan in the db buffer for a statement
12.1.0.2 DB Linux 64 Bit
By: juniordbanewbie on Mon, 28 August 2017
2 9164 Thu, 08 February 2018 02:36
By: juniordbanewbie
  Move unused partitioned from one tablespace to another tablespace.
Oracle 12c (12.1.0.1.0)- Unix
By: daulat01 on Thu, 04 January 2018
2 1479 Wed, 07 February 2018 03:23
By: daulat01
  View Performance Tuning
By: dancko on Tue, 30 January 2018
7 1392 Tue, 30 January 2018 10:34
By: cookiemonster
  Is there a equivalent of delete nologging operations
11.2.0.4 SE, Windows 2012 r2 Datacenter
By: juniordbanewbie on Tue, 19 September 2017
4 2687 Thu, 25 January 2018 18:13
By: juniordbanewbie
  Driving Table is not given more speed result
Oracle 11g
By: venkat_kayal on Thu, 18 January 2018
15 3056 Thu, 25 January 2018 03:46
By: venkat_kayal
  Non-value Added Indexes
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Tue, 02 January 2018
12 3315 Mon, 15 January 2018 08:15
By: msol25
  Consuming a more time (low performance)
Oracle8i Enterprise Edition Release 8.1.7.0.0, for 32-bit Windows
By: shawaj on Fri, 17 November 2017
4 2315 Sun, 24 December 2017 03:09
By: SmithXu
  Query taking 20 minutes in Production
ORACLE 11g
By: manoj12 on Fri, 17 November 2017
3 1814 Fri, 15 December 2017 03:26
By: cookiemonster
  AWR Interpretation and analysis
oracle 11gr2 on linux
By: dba4oracle on Tue, 05 December 2017
7 1852 Fri, 08 December 2017 02:04
By: trantuananh24hg
  DB Health checks
oracle 11gr2 on linux
By: dba4oracle on Tue, 05 December 2017
16 2414 Thu, 07 December 2017 05:43
By: dba4oracle
  Running out of 64gb Temp Space
12c
By: dbogey on Tue, 05 December 2017
2 1110 Tue, 05 December 2017 15:05
By: BlackSwan
  Session Trace file Location - Oracle 12c
oracle 12c Windows 2012
By: muthukrish104 on Mon, 04 December 2017
3 1156 Mon, 04 December 2017 03:24
By: muthukrish104
  Undo tablespace(monitoring and avoiding ORA-01555
oracle 11grw on linux
By: dba4oracle on Mon, 30 October 2017
8 2285 Sat, 11 November 2017 08:02
By: trantuananh24hg
  Performance Issue
Oracle8i Enterprise Edition Release 8.1.7.0.0,TNS for 32-bit Windows
By: shawaj on Thu, 09 November 2017
6 27884 Sat, 11 November 2017 00:59
By: shawaj
  Hints
Oracle 11g
By: sathishsr on Wed, 25 October 2017
3 99748 Wed, 25 October 2017 07:53
By: BlackSwan
  using sysdate from dual takes longer time
By: manikandan23 on Tue, 17 October 2017
10 87249 Wed, 18 October 2017 09:42
By: manikandan23
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: Mon Jun 18 14:35:15 CDT 2018