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: Performances and tuning
By: Michel Cadot on Fri, 22 June 2007
7 8425 Sat, 07 March 2015 12:25
By: Kevin Meade
icon11.gif DBMS_SQLTUNE.REPORT_SQL_DETAIL: html report issue
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: piripicchio on Thu, 15 October 2020
0 762 Thu, 15 October 2020 09:08
By: piripicchio
  Application Performance Issue
Oracle 11g,Linux 6
By: BalajiDBA on Sat, 10 October 2020
2 388 Sat, 10 October 2020 03:18
By: Michel Cadot
  Bitmap join index
DB19.3
By: John Watson on Thu, 08 October 2020
0 1163 Thu, 08 October 2020 04:17
By: John Watson
  Scalar subquery merging
DB 19.x
By: John Watson on Tue, 29 September 2020
3 1811 Tue, 29 September 2020 13:43
By: Michel Cadot
  Different SQL ID for same SQL/HASH_VALUE
10.2.0.3, Solaris 5.9
By: suddhasatwa_bhaumik on Fri, 02 November 2012
11 33157 Mon, 28 September 2020 01:45
By: amujawane
  Physical read IO requests higher than total
12.2, Linux 64
By: pallen38 on Tue, 22 September 2020
6 2959 Tue, 22 September 2020 14:56
By: pallen38
  New to tuning
12c
By: mdarifdxb20 on Sun, 09 August 2020
1 2416 Sun, 09 August 2020 05:19
By: Michel Cadot
  DBMS_AUTO_SQLTUNE
CentOS 6.2 64-bit, Oracle11gR2 11.2.0.3.0
By: debrucer2 on Mon, 05 November 2012
3 11571 Sat, 04 July 2020 04:09
By: Jack Almond
icon14.gif Find Locking History
Oracle 11.2.0.4.0 enterprise, CentOS 7.2
By: weekend79 on Wed, 08 April 2020
6 5397 Wed, 08 April 2020 04:06
By: weekend79
  Increase page loading speed
By: mike05 on Thu, 05 March 2020
4 4999 Thu, 05 March 2020 10:23
By: Michel Cadot
  Oracle & Sybase on same host
RDBMS 12.2..0.1 on linux with sybase 15.5
By: evoradba on Wed, 12 February 2020
3 3893 Fri, 14 February 2020 12:17
By: evoradba
  Database performance tuning
Oracle 11g,Linux 6
By: BalajiDBA on Sun, 09 February 2020
3 3870 Sun, 09 February 2020 09:04
By: BalajiDBA
  Select query too slow
11.2.04 Windows 2012
By: rajesh_b on Tue, 10 December 2019
16 10566 Tue, 28 January 2020 10:57
By: Michel Cadot
  sqlID time for every Sql id execution
RDBMS 12.2..0.1 on linux
By: evoradba on Fri, 24 January 2020
2 3907 Sat, 25 January 2020 02:07
By: John Watson
  Database performance tuning (merged)
12c
By: mha2020 on Sat, 18 January 2020
3 4824 Sat, 18 January 2020 06:48
By: John Watson
  Top SQL and Top sessions
Oracle 11g,Oracle 12c, Linux
By: BalajiDBA on Thu, 14 November 2019
2 5447 Thu, 14 November 2019 07:55
By: cookiemonster
  Solution for database hung
Oracle 11.2.0.4,Linux 6
By: BalajiDBA on Fri, 25 October 2019
11 9703 Wed, 13 November 2019 07:52
By: BalajiDBA
  Disk file operations i/o
ORACLE 11.2.0.4 on HP-UX.
By: nimaz85 on Mon, 21 October 2019
4 6900 Mon, 21 October 2019 10:57
By: Michel Cadot
  SQL_Text on SQL Profile
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0
By: wtolentino on Thu, 17 October 2019
1 5085 Thu, 17 October 2019 09:01
By: Michel Cadot
  queue management system
Developer 10g Database 10
By: shahzaib_4vip@hotmail.com on Sat, 07 September 2019
1 5878 Sat, 07 September 2019 06:36
By: Michel Cadot
  ORA-16951: Too many bind variables supplied for this SQL statement (merged)
oracle 11gr2 linux
By: dba4oracle on Fri, 21 June 2019
6 101441 Tue, 20 August 2019 10:01
By: dba4oracle
  Slow query with hash clustering (latch free - multiblock read objects)
Oracle 11g R2, RHEL 7
By: tabokie on Mon, 15 July 2019
2 6194 Mon, 15 July 2019 02:55
By: tabokie
  Consider of load-test invoking only one insert statement
Oracle 11g, any platform
By: trantuananh24hg on Mon, 03 June 2019
1 6176 Wed, 05 June 2019 02:48
By: John Watson
  improve performance on updating clob data
Oracle RDBMS, 12.1, Windows
By: unna on Wed, 22 May 2019
7 9031 Tue, 28 May 2019 09:38
By: Michel Cadot
  poor performance during switch log file
Oracle 12.2.0.1 linux 7.6
By: fabi88 on Sun, 12 May 2019
5 7077 Mon, 20 May 2019 22:02
By: trantuananh24hg
  Query Taking Alot of time ..Help in Tuning
11g
By: rrcr on Tue, 12 February 2019
6 10302 Thu, 18 April 2019 03:32
By: cookiemonster
  Oracle CPU usage Analysis
11g
By: s.rangan@outlook.com on Wed, 10 April 2019
3 6813 Thu, 11 April 2019 01:18
By: John Watson
  Oracle high "cost" SELECT query
Oracle 12
By: greenstone90 on Tue, 12 March 2019
13 13201 Thu, 14 March 2019 08:46
By: cookiemonster
  Retrieving 8k rows from one table takes too long
Oracle EE 11.2.0.3.0 - 64bit, Linux
By: Andrey_R on Sun, 30 December 2018
8 9456 Sun, 10 March 2019 01:26
By: dba4oracle
  high buffers
oracle 11gr2 linux
By: dba4oracle on Sat, 09 March 2019
19 11469 Sat, 09 March 2019 21:30
By: dba4oracle
  Table Order in Join
11g
By: rrcr on Thu, 07 February 2019
5 7786 Thu, 07 February 2019 11:03
By: John Watson
  RELY constraints
DB 12.x
By: John Watson on Tue, 05 February 2019
0 5466 Tue, 05 February 2019 04:55
By: John Watson
  driving table and join order
12c
By: m.abdulhaq on Thu, 10 January 2019
2 9282 Thu, 10 January 2019 14:35
By: John Watson
  table Partition when values are unknown
11g
By: kashifchughtai on Mon, 07 January 2019
23 13446 Wed, 09 January 2019 03:36
By: cookiemonster
  how to avoid window sort?
oracle 12c release 2
By: vishwaBhushan on Fri, 16 November 2018
8 10665 Fri, 16 November 2018 03:46
By: cookiemonster
  Optimal Chunk size for update of 50M record table
Oracle 11g RAC, Linux OEL 6 ( 1 2)
By: Andrey_R on Wed, 03 October 2018
46 25122 Tue, 06 November 2018 03:10
By: Andrey_R
  A question about how to code a procedure to use dbms_parallel_execute package for a huge insert
11.2.0.4 on Linux
By: orausern on Tue, 30 October 2018
13 10790 Wed, 31 October 2018 11:15
By: orausern
  scripts of Oracle SQL Performance Tuning and Optimization
Oracle
By: big on Thu, 25 October 2018
2 6733 Thu, 25 October 2018 06:36
By: big
  Is there a need to install os monitoring tools since gv$osstat already has the os statistics
12.2.0.1 Windows 2016
By: juniordbanewbie on Wed, 17 October 2018
2 7570 Wed, 17 October 2018 02:43
By: juniordbanewbie
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: Sun Oct 25 12:21:26 CDT 2020