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

    Replies Views Last message
  Oracle 12c -Query CPU Cost is very high
Oracle 12c Release 1, Linux(Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)
By: anil_mk on Tue, 27 December 2016
5 2386 Mon, 27 February 2017 13:00
By: Caffeine+
  Performance issue in oracle 10g database
WINDOW SERVER 2008
By: NIJ1611 on Thu, 23 February 2017
4 1129 Thu, 23 February 2017 08:26
By: cookiemonster
  Query is taking longer duration
Oracle 11g 11.2.0.1.0
By: manoj12 on Fri, 10 February 2017
19 17720 Wed, 22 February 2017 16:03
By: mikek
  BULK INSERT PERFORMANCE ON PROD
Oracle 12c, RHEL 6
By: jesuisantony on Sat, 14 May 2016
7 1850 Mon, 30 January 2017 13:00
By: forums.sqltop
  TOP_LEVEL_SQL_ID
Oracle 11.2.0.4, Windows 2008 Server
By: jesuisantony on Tue, 07 June 2016
8 2456 Fri, 27 January 2017 12:07
By: jesuisantony
  Identify index key entry by rowid
Oracle SE 11.2.0.4.0
By: michael_bialik on Tue, 17 January 2017
14 3026 Tue, 24 January 2017 04:51
By: Michel Cadot
  Tuning update query - for more than 3 billion rows
By: kurki on Fri, 20 January 2017
12 1988 Mon, 23 January 2017 03:41
By: Roachcoach
  ora-01555 snapshot too old. Query executed 4000s
10g, 10.2.0.5, hp-unix
By: ashishkumarmahanta80 on Tue, 07 June 2016
4 1450 Fri, 20 January 2017 10:58
By: Michel Cadot
  query Dead Slow
oRACLE EBS R12
By: annu-agi on Fri, 20 January 2017
9 1639 Fri, 20 January 2017 10:37
By: Michel Cadot
  Avoiding the -ve execute to parse for MV refresh(highest parse calls total than execution totals)
Oracle 11
By: saipradyumn on Wed, 18 January 2017
11 1642 Thu, 19 January 2017 03:37
By: saipradyumn
  SGA AND PGA TUNING
Oracle 11.2
By: arin.oradba on Thu, 05 January 2017
20 11238 Fri, 13 January 2017 01:57
By: arin.oradba
  Need your help to optimize the Query
Oracle 10g and Windows 12
By: mahatab on Tue, 15 November 2016
8 1692 Thu, 12 January 2017 10:53
By: skooman
  slow while inserting
10g
By: arifmd1705 on Sun, 08 January 2017
4 1245 Mon, 09 January 2017 00:50
By: Michel Cadot
  db file sequential read causing Performance Issues
Oracle 12c
By: subbaiyan on Fri, 06 January 2017
11 1681 Fri, 06 January 2017 07:47
By: BlackSwan
  Union all tables with View and using the Index
Oracle 11g
By: preet_kumar on Fri, 23 December 2016
5 2820 Tue, 03 January 2017 03:48
By: cookiemonster
  Identifying the parsing of the query (merged by MC)
Oracle 11g
By: saipradyumn on Tue, 27 December 2016
13 10761 Thu, 29 December 2016 06:36
By: Michel Cadot
  Which index to choose local or global for attached scenario
10.2.0.3 db and AIX OS
By: oratech10 on Mon, 19 December 2016
24 3589 Tue, 20 December 2016 21:19
By: John Watson
  stale stats
Oracle 12c
By: srinivas.k2005 on Wed, 07 December 2016
18 46227 Tue, 13 December 2016 03:44
By: srinivas.k2005
  Oracle Advance Queue consumes messages very slowly
Oracle 10g, HP-UX/ia64
By: panos9 on Wed, 07 December 2016
2 1494 Wed, 07 December 2016 10:11
By: panos9
  query Dead Slow
11g, 11.2.0.3.0
By: annu-agi on Wed, 07 December 2016
2 1450 Wed, 07 December 2016 09:06
By: John Watson
  ORA-01555 error during expdp
Oracle 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production, Windows Server 2008 R2
By: ashussain on Tue, 06 December 2016
4 1503 Wed, 07 December 2016 06:44
By: Michel Cadot
  Materlized View
Oracle 11
By: meetmallela on Sat, 03 December 2016
5 1572 Mon, 05 December 2016 02:59
By: cookiemonster
  In-database archival
Oracle 12C
By: srinivas.k2005 on Thu, 01 December 2016
2 866 Thu, 01 December 2016 05:11
By: srinivas.k2005
  java.sql.SQLTimeoutException: ORA-01013
Oracle 12c
By: ajamitjain129@gmail.com on Thu, 20 October 2016
8 2217 Mon, 28 November 2016 17:24
By: ajamitjain129@gmail.com
  Query Tuning
Oracle 12c, Unix
By: pstanand on Sun, 27 November 2016
1 1719 Mon, 28 November 2016 00:28
By: Michel Cadot
  DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING.
LINUX
By: osama.mansoor on Wed, 26 October 2016
7 1522 Thu, 27 October 2016 03:05
By: Roachcoach
  Cursor Optimization
Oracle 11g
By: abhijeetkumar.patil@cogni on Tue, 18 October 2016
8 1630 Mon, 24 October 2016 14:56
By: Kevin Meade
  Exceeding maxi,um number of cursors
11g r2, linux
By: qazims92 on Mon, 24 October 2016
7 1265 Mon, 24 October 2016 06:04
By: Michel Cadot
  Slow Query Sql
Oracle 10g
By: rayrevan on Thu, 06 October 2016
14 5550 Thu, 13 October 2016 03:47
By: cookiemonster
  Partitioning huge table
10g
By: arifmd1705 on Sun, 09 October 2016
8 1451 Wed, 12 October 2016 02:42
By: gazzag
  compare two procedures for performance
Oracle 11.2.0.3
By: pointers on Fri, 30 September 2016
5 1125 Fri, 30 September 2016 04:40
By: Michel Cadot
  Do we need to sit down with custom about determining which statspack snapshot to be used as baseline
11.2.0.4 SE, RHEL 7.1
By: juniordbanewbie on Tue, 27 September 2016
1 856 Tue, 27 September 2016 03:03
By: Michel Cadot
  Database options to address work load increase
By: caprikar on Mon, 19 September 2016
4 1218 Fri, 23 September 2016 08:41
By: bpeasland
  Application is running slow time to time
linux
By: dbabertrand on Wed, 21 September 2016
4 1117 Fri, 23 September 2016 08:39
By: bpeasland
  What should i do for tuning this query
Oracle 10g
By: rayrevan on Mon, 12 September 2016
16 2407 Tue, 20 September 2016 03:24
By: cookiemonster
  MR (Metadata Repository) SQL caused poor performance
Oracle Portal 10g, OID, IAS, Windows x86_64
By: trantuananh24hg on Wed, 14 September 2016
5 1752 Thu, 15 September 2016 22:54
By: trantuananh24hg
  Improve query execution times
oracle 12c
By: gorants on Thu, 01 September 2016
4 1380 Sat, 03 September 2016 02:13
By: John Watson
  Commit interval
Oracle 11g, Unix
By: ninan on Sat, 20 August 2016
11 1763 Thu, 01 September 2016 04:58
By: John Watson
  How to Optimise this query
Oracle 11G
By: tarundas2016 on Mon, 22 August 2016
3 963 Thu, 01 September 2016 04:10
By: Kevin Meade
  SQL Query - Just too big
11g
By: nathan59 on Thu, 01 September 2016
16 1573 Thu, 01 September 2016 03:50
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 Nov 20 17:29:54 CST 2018