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 Advance Queue consumes messages very slowly
Oracle 10g, HP-UX/ia64
By: panos9 on Wed, 07 December 2016
2 540 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 512 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 741 Wed, 07 December 2016 06:44
By: Michel Cadot
  Materlized View
Oracle 11
By: meetmallela on Sat, 03 December 2016
5 1045 Mon, 05 December 2016 02:59
By: cookiemonster
  In-database archival
Oracle 12C
By: srinivas.k2005 on Thu, 01 December 2016
2 461 Thu, 01 December 2016 05:11
By: srinivas.k2005
  Query Tuning
Oracle 12c, Unix
By: pstanand on Sun, 27 November 2016
1 662 Mon, 28 November 2016 00:28
By: Michel Cadot
  Need your help to optimize the Query
Oracle 10g and Windows 12
By: mahatab on Tue, 15 November 2016
8 1039 Thu, 12 January 2017 10:53
By: skooman
  DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING.
LINUX
By: osama.mansoor on Wed, 26 October 2016
7 890 Thu, 27 October 2016 03:05
By: Roachcoach
  Exceeding maxi,um number of cursors
11g r2, linux
By: qazims92 on Mon, 24 October 2016
7 718 Mon, 24 October 2016 06:04
By: Michel Cadot
  java.sql.SQLTimeoutException: ORA-01013
Oracle 12c
By: ajamitjain129@gmail.com on Thu, 20 October 2016
8 1112 Mon, 28 November 2016 17:24
By: ajamitjain129@gmail.com
  Cursor Optimization
Oracle 11g
By: abhijeetkumar.patil@cogni on Tue, 18 October 2016
8 961 Mon, 24 October 2016 14:56
By: Kevin Meade
  Partitioning huge table
10g
By: arifmd1705 on Sun, 09 October 2016
8 855 Wed, 12 October 2016 02:42
By: gazzag
  Slow Query Sql
Oracle 10g
By: rayrevan on Thu, 06 October 2016
14 3097 Thu, 13 October 2016 03:47
By: cookiemonster
  compare two procedures for performance
Oracle 11.2.0.3
By: pointers on Fri, 30 September 2016
5 646 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 448 Tue, 27 September 2016 03:03
By: Michel Cadot
  Application is running slow time to time
linux
By: dbabertrand on Wed, 21 September 2016
4 625 Fri, 23 September 2016 08:39
By: bpeasland
  Database options to address work load increase
By: caprikar on Mon, 19 September 2016
4 782 Fri, 23 September 2016 08:41
By: bpeasland
  MR (Metadata Repository) SQL caused poor performance
Oracle Portal 10g, OID, IAS, Windows x86_64
By: trantuananh24hg on Wed, 14 September 2016
5 773 Thu, 15 September 2016 22:54
By: trantuananh24hg
  What should i do for tuning this query
Oracle 10g
By: rayrevan on Mon, 12 September 2016
16 1560 Tue, 20 September 2016 03:24
By: cookiemonster
  Improve query execution times
oracle 12c
By: gorants on Thu, 01 September 2016
4 773 Sat, 03 September 2016 02:13
By: John Watson
  Driving site hint on a single remote table
OEL 6.5,Oracle 10g
By: swas_recall on Thu, 01 September 2016
7 505 Thu, 01 September 2016 03:35
By: Michel Cadot
  SQL Query - Just too big
11g
By: nathan59 on Thu, 01 September 2016
16 775 Thu, 01 September 2016 03:50
By: Kevin Meade
  improve performance using partitioning
oracle 11g
By: tarundas2016 on Mon, 22 August 2016
3 470 Tue, 23 August 2016 02:39
By: Roachcoach
  How to Optimise this query
Oracle 11G
By: tarundas2016 on Mon, 22 August 2016
3 534 Thu, 01 September 2016 04:10
By: Kevin Meade
  Tuning Multiple Not Exists
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
By: ricky_s on Mon, 22 August 2016
10 946 Fri, 26 August 2016 01:00
By: Michel Cadot
  Commit interval
Oracle 11g, Unix
By: ninan on Sat, 20 August 2016
11 1160 Thu, 01 September 2016 04:58
By: John Watson
  slow running sql
10g
By: arifmd1705 on Mon, 08 August 2016
16 1005 Sat, 13 August 2016 23:22
By: arifmd1705
  server session exceed
By: rameshrk0206@gmail.com on Mon, 08 August 2016
1 347 Mon, 08 August 2016 01:30
By: Michel Cadot
  Data related to DB Metrics for a period
Oracle 11.2.0.4 on Linux
By: orausern on Thu, 04 August 2016
5 593 Thu, 04 August 2016 03:52
By: John Watson
  Approach for Oracle Profiles to tune queries
Oracle 11.2.0.4 on LInux
By: orausern on Tue, 02 August 2016
4 471 Tue, 02 August 2016 04:19
By: orausern
  consecutive executions
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
By: bibhuti037 on Wed, 27 July 2016
7 663 Thu, 28 July 2016 02:24
By: pablolee
  Why rownum is not used in the query
By: samiran_cts on Tue, 02 August 2016
13 1203 Wed, 03 August 2016 08:14
By: cookiemonster
  Compare spatial and attributive query
Oracle Locator 11g
By: moehre on Tue, 05 July 2016
11 1308 Wed, 13 July 2016 03:55
By: Barbara Boehmer
  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 588 Tue, 28 June 2016 23:35
By: javed.khan
  Performance worse for given workflow query
11i
By: nishant87 on Wed, 22 June 2016
16 664 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 639 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 513 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 1300 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 527 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 887 Fri, 20 January 2017 10:58
By: Michel Cadot
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: Fri Sep 22 01:19:24 CDT 2017

Total time taken to generate the page: 0.23184 seconds