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 354 Sat, 07 March 2015 12:25
By: Kevin Meade
  queue management system
Developer 10g Database 10
By: shahzaib_4vip@hotmail.com on Sat, 07 September 2019
1 1070 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 94783 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 1438 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 1919 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 2800 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 2118 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 5026 Thu, 18 April 2019 03:32
By: cookiemonster
  Oracle CPU usage Analysis
11g
By: s.rangan@outlook.com on Wed, 10 April 2019
3 2256 Thu, 11 April 2019 01:18
By: John Watson
  Oracle high "cost" SELECT query
Oracle 12
By: greenstone90 on Tue, 12 March 2019
13 5476 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 4371 Sun, 10 March 2019 01:26
By: dba4oracle
  high buffers
oracle 11gr2 linux
By: dba4oracle on Sat, 09 March 2019
19 3401 Sat, 09 March 2019 21:30
By: dba4oracle
  Table Order in Join
11g
By: rrcr on Thu, 07 February 2019
5 3153 Thu, 07 February 2019 11:03
By: John Watson
  RELY constraints
DB 12.x
By: John Watson on Tue, 05 February 2019
0 2676 Tue, 05 February 2019 04:55
By: John Watson
  driving table and join order
12c
By: m.abdulhaq on Thu, 10 January 2019
2 5122 Thu, 10 January 2019 14:35
By: John Watson
  table Partition when values are unknown
11g
By: kashifchughtai on Mon, 07 January 2019
23 5971 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 5076 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 11547 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 4993 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 3342 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 3852 Wed, 17 October 2018 02:43
By: juniordbanewbie
  No more data to read from socket
No more data to read from socket (Oracle error 17410 )
By: saipradyumn on Sat, 22 September 2018
14 6315 Mon, 15 October 2018 05:04
By: saipradyumn
  How do I know who are running the long running ops sql?
12.1.0.2 RH7
By: juniordbanewbie on Tue, 02 October 2018
1 3507 Tue, 02 October 2018 02:45
By: Michel Cadot
  Transaction Isolation Level
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Fri, 28 September 2018
2 2337 Sat, 29 September 2018 06:31
By: saipradyumn
  Pleaese clear my doubt about View and synonym having same name
UNIX 11.35
By: Akmmhto on Wed, 26 September 2018
6 3405 Fri, 28 September 2018 12:07
By: Akmmhto
  Index on order by column
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: saipradyumn on Sat, 15 September 2018
9 3893 Tue, 18 September 2018 02:53
By: saipradyumn
  Range Scan Index
Oracle 11g, any platforms
By: trantuananh24hg on Tue, 28 August 2018
18 4606 Thu, 30 August 2018 09:34
By: JPBoileau
  Exporting AWR data in a csv file
RHEL 6 64-bit, Oracle 12.2.0.1
By: Nagesh1985 on Tue, 28 August 2018
8 3633 Thu, 30 August 2018 02:22
By: Roachcoach
  Appropriate join to the desired output
Oracle 11.2
By: senmng on Fri, 27 July 2018
3 4194 Tue, 28 August 2018 02:47
By: jennifer roche
  performance tuning
Oracle rdbms 11gR2 and #statspack
By: alanm on Mon, 30 July 2018
3 4208 Mon, 30 July 2018 04:37
By: Roachcoach
  Sql query to get Max,min and max-1 row from a table
Oracle 11.2
By: senmng on Sun, 22 July 2018
2 3476 Sun, 22 July 2018 09:36
By: senmng
  please help for sql query to find out total number of concurrent connections in database
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
By: msol25 on Thu, 05 July 2018
6 4851 Thu, 05 July 2018 06:57
By: msol25
icon5.gif Oracle Text index column when searching multiple tables
12.1.0.2.0
By: LFranz on Fri, 27 April 2018
7 8430 Thu, 28 June 2018 03:12
By: Barbara Boehmer
  Encountering issues with join condition in stored procedure
Oracle 11.2
By: senmng on Fri, 22 June 2018
4 4604 Sat, 23 June 2018 18:01
By: BlackSwan
  join is slow
Oracle12g
By: Buchas on Fri, 25 May 2018
2 4311 Wed, 20 June 2018 05:22
By: michael_bialik
  Used Left Join - Query goes for Full Table scan
Oracle 11.2
By: saravanantgu on Fri, 25 May 2018
7 5792 Wed, 20 June 2018 02:47
By: John Watson
  Wrong plan chosen by optimizer
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production OEL 6
By: Andrey_R on Wed, 30 May 2018
11 5019 Wed, 30 May 2018 09:32
By: Andrey_R
  Wrong plan chosen by optimizer
Oracle 11.1.0.6 , OEL 6
By: Andrey_R on Tue, 22 May 2018
14 5564 Wed, 23 May 2018 08:03
By: Andrey_R
  Distinct query taking long time to run
Oracle 11.2,Linux 6
By: senmng on Thu, 10 May 2018
7 5181 Tue, 22 May 2018 14:17
By: senmng
  ORA-07445: exception encountered: core dump [audplsfailure()+54]
Oracle DB 11.2.0.4 OS: Redhat Linux 6.9 64 Bit
By: suhaspdba on Tue, 15 May 2018
4 8953 Tue, 15 May 2018 11:25
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: Thu Sep 19 12:35:07 CDT 2019