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

    Replies Views Last message
  DATABASE TUNING PRINCIPLE AND DATABASE TROUBLESHOOTING.
LINUX
By: osama.mansoor on Wed, 26 October 2016
7 872 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 696 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 1073 Mon, 28 November 2016 17:24
By: ajamitjain129@gmail.com
  Cursor Optimization
Oracle 11g
By: abhijeetkumar.patil@cogni on Tue, 18 October 2016
8 932 Mon, 24 October 2016 14:56
By: Kevin Meade
  Partitioning huge table
10g
By: arifmd1705 on Sun, 09 October 2016
8 842 Wed, 12 October 2016 02:42
By: gazzag
  Slow Query Sql
Oracle 10g
By: rayrevan on Thu, 06 October 2016
14 1052 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 627 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 435 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 609 Fri, 23 September 2016 08:39
By: bpeasland
  Database options to address work load increase
By: caprikar on Mon, 19 September 2016
4 765 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 737 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 1539 Tue, 20 September 2016 03:24
By: cookiemonster
  Improve query execution times
oracle 12c
By: gorants on Thu, 01 September 2016
4 751 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 484 Thu, 01 September 2016 03:35
By: Michel Cadot
  SQL Query - Just too big
11g
By: nathan59 on Thu, 01 September 2016
16 663 Thu, 01 September 2016 03:50
By: Kevin Meade
  improve performance using partitioning
oracle 11g
By: tarundas2016 on Mon, 22 August 2016
3 457 Tue, 23 August 2016 02:39
By: Roachcoach
  How to Optimise this query
Oracle 11G
By: tarundas2016 on Mon, 22 August 2016
3 519 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 924 Fri, 26 August 2016 01:00
By: Michel Cadot
  Commit interval
Oracle 11g, Unix
By: ninan on Sat, 20 August 2016
11 1141 Thu, 01 September 2016 04:58
By: John Watson
  slow running sql
10g
By: arifmd1705 on Mon, 08 August 2016
16 991 Sat, 13 August 2016 23:22
By: arifmd1705
  server session exceed
By: rameshrk0206@gmail.com on Mon, 08 August 2016
1 338 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 579 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 452 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 644 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 1182 Wed, 03 August 2016 08:14
By: cookiemonster
  Compare spatial and attributive query
Oracle Locator 11g
By: moehre on Tue, 05 July 2016
11 1283 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 579 Tue, 28 June 2016 23:35
By: javed.khan
  Performance worse for given workflow query
11i
By: nishant87 on Wed, 22 June 2016
16 649 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 620 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 496 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 1268 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 514 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 866 Fri, 20 January 2017 10:58
By: Michel Cadot
  count(*) anomaly
DB 12.1.0.2, Windows 10
By: John Watson on Sat, 28 May 2016
5 551 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 612 Tue, 17 May 2016 03:20
By: Michel Cadot
  BULK INSERT PERFORMANCE ON PROD
Oracle 12c, RHEL 6
By: jesuisantony on Sat, 14 May 2016
7 1139 Mon, 30 January 2017 13:00
By: forums.sqltop
  SGA_MAX_SIZE and SGA_TARGET
Unix, ORacle 12C
By: ninan on Mon, 02 May 2016
16 1246 Thu, 05 May 2016 11:09
By: Michel Cadot
  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 1405 Tue, 07 June 2016 08:15
By: Kevin Meade
  Cluster table access IO is unexpected
11.2.0.4
By: Roachcoach on Thu, 28 April 2016
3 476 Fri, 29 April 2016 02:32
By: Roachcoach
  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 739 Fri, 15 April 2016 11:15
By: John Watson
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: Sat Aug 19 15:39:47 CDT 2017

Total time taken to generate the page: 0.07342 seconds