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	15023	Sat, 07 March 2015 12:25 By: Kevin Meade
The predicate prevents the optimizer from using indices efficiently 12.2 By: lisyloo12 on Fri, 23 July 2021	1	5980	Fri, 23 July 2021 13:04 By: John Watson
SQL Access Advisor from SQL*Plus Oracle 11g, 12c By: db_senior on Sat, 03 July 2021	8	7603	Mon, 05 July 2021 12:35 By: db_senior
Function blocking itself Oracle, 12.1.0.2, Windows By: patdev on Wed, 09 June 2021	1	3568	Wed, 09 June 2021 10:28 By: Michel Cadot
Query running slow 19c By: JackBauer on Wed, 31 March 2021	13	12716	Tue, 13 April 2021 05:17 By: JackBauer
Cannot index temp table after inserting rows Linux\Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: Andrey_R on Wed, 03 March 2021	2	4034	Wed, 03 March 2021 03:42 By: Andrey_R
SQL ID changes Plan hash value 12c R1 By: JackBauer on Tue, 16 February 2021	5	7652	Fri, 26 February 2021 08:45 By: BlackSwan
I/O performance problem 12c R1 By: JackBauer on Thu, 11 February 2021	2	4011	Fri, 12 February 2021 06:20 By: JackBauer
Program is slower with Oracle12C compared to Oracle 11G Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: LiorI on Wed, 13 January 2021	3	10280	Fri, 12 February 2021 06:15 By: Andrey_R
TKPROF showing wrong totals for non-recursive statements Oracle 12.1.0.2.0 By: Andrey_R on Thu, 11 February 2021	0	2983	Thu, 11 February 2021 06:19 By: Andrey_R
ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test Oracle Database 19.7, jmeter 5.3 By: estonolose on Tue, 01 December 2020	1	5453	Tue, 01 December 2020 21:27 By: BlackSwan
SQL_Text on SQL Profile Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 By: wtolentino on Thu, 17 October 2019	2	11619	Sun, 22 November 2020 12:56 By: LNossov
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	4353	Thu, 15 October 2020 09:08 By: piripicchio
Application Performance Issue Oracle 11g,Linux 6 By: BalajiDBA on Sat, 10 October 2020	2	3372	Sat, 10 October 2020 03:18 By: Michel Cadot
Bitmap join index DB19.3 By: John Watson on Thu, 08 October 2020	0	3520	Thu, 08 October 2020 04:17 By: John Watson
Scalar subquery merging DB 19.x By: John Watson on Tue, 29 September 2020	3	4676	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	37859	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	6230	Tue, 22 September 2020 14:56 By: pallen38
New to tuning 12c By: mdarifdxb20 on Sun, 09 August 2020	1	5972	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	16623	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	11135	Wed, 08 April 2020 04:06 By: weekend79
Increase page loading speed By: mike05 on Thu, 05 March 2020	4	10116	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	7919	Fri, 14 February 2020 12:17 By: evoradba
Database performance tuning Oracle 11g,Linux 6 By: BalajiDBA on Sun, 09 February 2020	3	7399	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	17056	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	7622	Sat, 25 January 2020 02:07 By: John Watson
Database performance tuning (merged) 12c By: mha2020 on Sat, 18 January 2020	3	8542	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	8995	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	14492	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	12442	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	9205	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	105834	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	9621	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	9331	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	13519	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	11046	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	14156	Thu, 18 April 2019 03:32 By: cookiemonster
Oracle CPU usage Analysis 11g By: s.rangan@outlook.com on Wed, 10 April 2019	3	10374	Thu, 11 April 2019 01:18 By: John Watson
Oracle high "cost" SELECT query Oracle 12 By: greenstone90 on Tue, 12 March 2019	13	19160	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	13889	Sun, 10 March 2019 01:26 By: dba4oracle