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
sticky: Performances and tuning By: Michel Cadot on Fri, 22 June 2007	7	6527	Sat, 07 March 2015 12:25 By: Kevin Meade
DBMS_AUTO_SQLTUNE CentOS 6.2 64-bit, Oracle11gR2 11.2.0.3.0 By: debrucer2 on Mon, 05 November 2012	3	8175	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	2719	Wed, 08 April 2020 04:06 By: weekend79
Increase page loading speed By: mike05 on Thu, 05 March 2020	4	2896	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	2591	Fri, 14 February 2020 12:17 By: evoradba
Database performance tuning Oracle 11g,Linux 6 By: BalajiDBA on Sun, 09 February 2020	3	2773	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	8478	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	2800	Sat, 25 January 2020 02:07 By: John Watson
Database performance tuning (merged) 12c By: mha2020 on Sat, 18 January 2020	3	3626	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	4236	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	7951	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	5022	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	4013	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	4732	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	99960	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	5015	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	5109	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	7720	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	6017	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	9217	Thu, 18 April 2019 03:32 By: cookiemonster
Oracle CPU usage Analysis 11g By: s.rangan@outlook.com on Wed, 10 April 2019	3	5529	Thu, 11 April 2019 01:18 By: John Watson
Oracle high "cost" SELECT query Oracle 12 By: greenstone90 on Tue, 12 March 2019	13	11403	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	8158	Sun, 10 March 2019 01:26 By: dba4oracle
high buffers oracle 11gr2 linux By: dba4oracle on Sat, 09 March 2019	19	9718	Sat, 09 March 2019 21:30 By: dba4oracle
Table Order in Join 11g By: rrcr on Thu, 07 February 2019	5	6390	Thu, 07 February 2019 11:03 By: John Watson
RELY constraints DB 12.x By: John Watson on Tue, 05 February 2019	0	4582	Tue, 05 February 2019 04:55 By: John Watson
driving table and join order 12c By: m.abdulhaq on Thu, 10 January 2019	2	8001	Thu, 10 January 2019 14:35 By: John Watson
table Partition when values are unknown 11g By: kashifchughtai on Mon, 07 January 2019	23	11741	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	8718	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	21432	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	9186	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	5582	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	6328	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	10842	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	5562	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	4335	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	6201	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	7062	Tue, 18 September 2018 02:53 By: saipradyumn
Range Scan Index Oracle 11g, any platforms By: trantuananh24hg on Tue, 28 August 2018	18	9082	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	6667	Thu, 30 August 2018 02:22 By: Roachcoach