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
Different SQL ID for same SQL/HASH_VALUE 10.2.0.3, Solaris 5.9 By: suddhasatwa_bhaumik on Fri, 02 November 2012	11	58295	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	22091	Tue, 22 September 2020 14:56 By: pallen38
New to tuning 12c By: mdarifdxb20 on Sun, 09 August 2020	1	17895	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	32004	Sat, 04 July 2020 04:09 By: Jack Almond
Find Locking History Oracle 11.2.0.4.0 enterprise, CentOS 7.2 By: weekend79 on Wed, 08 April 2020	6	30823	Wed, 08 April 2020 04:06 By: weekend79
Increase page loading speed By: mike05 on Thu, 05 March 2020	4	27271	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	19401	Fri, 14 February 2020 12:17 By: evoradba
Database performance tuning Oracle 11g,Linux 6 By: BalajiDBA on Sun, 09 February 2020	3	19315	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	34624	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	18784	Sat, 25 January 2020 02:07 By: John Watson
Database performance tuning (merged) 12c By: mha2020 on Sat, 18 January 2020	3	18845	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	18202	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	25792	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	25144	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	17551	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	120140	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	16656	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	15423	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	23587	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	19491	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	21775	Thu, 18 April 2019 03:32 By: cookiemonster
Oracle CPU usage Analysis 11g By: s.rangan@outlook.com on Wed, 10 April 2019	3	16940	Thu, 11 April 2019 01:18 By: John Watson
Oracle high "cost" SELECT query Oracle 12 By: greenstone90 on Tue, 12 March 2019	13	31190	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	21206	Sun, 10 March 2019 01:26 By: dba4oracle
high buffers oracle 11gr2 linux By: dba4oracle on Sat, 09 March 2019	19	28342	Sat, 09 March 2019 21:30 By: dba4oracle
Table Order in Join 11g By: rrcr on Thu, 07 February 2019	5	17906	Thu, 07 February 2019 11:03 By: John Watson
RELY constraints DB 12.x By: John Watson on Tue, 05 February 2019	0	12301	Tue, 05 February 2019 04:55 By: John Watson
driving table and join order 12c By: m.abdulhaq on Thu, 10 January 2019	2	18889	Thu, 10 January 2019 14:35 By: John Watson
table Partition when values are unknown 11g By: kashifchughtai on Mon, 07 January 2019	23	29133	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	25495	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	55641	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	24408	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	14695	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	15183	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	25375	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	12695	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	11695	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	14858	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	17791	Tue, 18 September 2018 02:53 By: saipradyumn
Range Scan Index Oracle 11g, any platforms By: trantuananh24hg on Tue, 28 August 2018	18	21311	Thu, 30 August 2018 09:34 By: JPBoileau