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 issue in oracle 10g database
WINDOW SERVER 2008
By: NIJ1611 on Thu, 23 February 2017
4 663 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 13026 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 1272 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 1574 Fri, 27 January 2017 12:07
By: jesuisantony
  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
5 569 Wed, 25 January 2017 02:24
By: John Watson
  Identify index key entry by rowid
Oracle SE 11.2.0.4.0
By: michael_bialik on Tue, 17 January 2017
14 1502 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 1076 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 968 Fri, 20 January 2017 10:58
By: Michel Cadot
  query Dead Slow
oRACLE EBS R12
By: annu-agi on Fri, 20 January 2017
9 957 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 858 Thu, 19 January 2017 03:37
By: saipradyumn
  SGA AND PGA TUNING
Oracle 11.2
By: arin.oradba on Thu, 05 January 2017
20 7673 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 1152 Thu, 12 January 2017 10:53
By: skooman
  slow while inserting
10g
By: arifmd1705 on Sun, 08 January 2017
4 854 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 959 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 2192 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 8605 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 2481 Tue, 20 December 2016 21:19
By: John Watson
  stale stats
Oracle 12c
By: srinivas.k2005 on Wed, 07 December 2016
18 38554 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 1067 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 1046 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 874 Wed, 07 December 2016 06:44
By: Michel Cadot
  Materlized View
Oracle 11
By: meetmallela on Sat, 03 December 2016
5 1107 Mon, 05 December 2016 02:59
By: cookiemonster
  In-database archival
Oracle 12C
By: srinivas.k2005 on Thu, 01 December 2016
2 521 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 1305 Mon, 28 November 2016 17:24
By: ajamitjain129@gmail.com
  Query Tuning
Oracle 12c, Unix
By: pstanand on Sun, 27 November 2016
1 1321 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 1005 Thu, 27 October 2016 03:05
By: Roachcoach
  Cursor Optimization
Oracle 11g
By: abhijeetkumar.patil@cogni on Tue, 18 October 2016
8 1080 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 810 Mon, 24 October 2016 06:04
By: Michel Cadot
  Slow Query Sql
Oracle 10g
By: rayrevan on Thu, 06 October 2016
14 3645 Thu, 13 October 2016 03:47
By: cookiemonster
  Partitioning huge table
10g
By: arifmd1705 on Sun, 09 October 2016
8 948 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 715 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 526 Tue, 27 September 2016 03:03
By: Michel Cadot
  Database options to address work load increase
By: caprikar on Mon, 19 September 2016
4 853 Fri, 23 September 2016 08:41
By: bpeasland
  Application is running slow time to time
linux
By: dbabertrand on Wed, 21 September 2016
4 708 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 1690 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 950 Thu, 15 September 2016 22:54
By: trantuananh24hg
  Improve query execution times
oracle 12c
By: gorants on Thu, 01 September 2016
4 891 Sat, 03 September 2016 02:13
By: John Watson
  Commit interval
Oracle 11g, Unix
By: ninan on Sat, 20 August 2016
11 1255 Thu, 01 September 2016 04:58
By: John Watson
  How to Optimise this query
Oracle 11G
By: tarundas2016 on Mon, 22 August 2016
3 604 Thu, 01 September 2016 04:10
By: Kevin Meade
  SQL Query - Just too big
11g
By: nathan59 on Thu, 01 September 2016
16 901 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 Jan 16 04:19:55 CST 2018

Total time taken to generate the page: 0.01845 seconds