OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Database performance tuning (merged) 12c By: mha2020 on Sat, 18 January 2020	3	13134	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	12908	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	20085	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	18797	Mon, 21 October 2019 10:57 By: Michel Cadot
queue management system Developer 10g Database 10 By: shahzaib_4vip@hotmail.com on Sat, 07 September 2019	1	12931	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	110938	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	12776	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	12023	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	17989	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	14507	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	17339	Thu, 18 April 2019 03:32 By: cookiemonster
Oracle CPU usage Analysis 11g By: s.rangan@outlook.com on Wed, 10 April 2019	3	12618	Thu, 11 April 2019 01:18 By: John Watson
Oracle high "cost" SELECT query Oracle 12 By: greenstone90 on Tue, 12 March 2019	13	23936	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	16278	Sun, 10 March 2019 01:26 By: dba4oracle
high buffers oracle 11gr2 linux By: dba4oracle on Sat, 09 March 2019	19	21449	Sat, 09 March 2019 21:30 By: dba4oracle
Table Order in Join 11g By: rrcr on Thu, 07 February 2019	5	13740	Thu, 07 February 2019 11:03 By: John Watson
RELY constraints DB 12.x By: John Watson on Tue, 05 February 2019	0	9343	Tue, 05 February 2019 04:55 By: John Watson
driving table and join order 12c By: m.abdulhaq on Thu, 10 January 2019	2	13909	Thu, 10 January 2019 14:35 By: John Watson
table Partition when values are unknown 11g By: kashifchughtai on Mon, 07 January 2019	23	21460	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	18871	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	41082	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	18258	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	10360	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	11471	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	18611	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	9515	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	8445	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	10876	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	12825	Tue, 18 September 2018 02:53 By: saipradyumn
Range Scan Index Oracle 11g, any platforms By: trantuananh24hg on Tue, 28 August 2018	18	15184	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	12084	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	10604	Tue, 28 August 2018 02:47 By: jennifer roche
performance tuning Oracle rdbms 11gR2 and #statspack By: alanm on Mon, 30 July 2018	3	9208	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	7616	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	10283	Thu, 05 July 2018 06:57 By: msol25
Oracle Text index column when searching multiple tables 12.1.0.2.0 By: LFranz on Fri, 27 April 2018	7	15612	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	9040	Sat, 23 June 2018 18:01 By: BlackSwan
join is slow Oracle12g By: Buchas on Fri, 25 May 2018	2	7274	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	9927	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	8133	Wed, 30 May 2018 09:32 By: Andrey_R