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	10	33632	Wed, 11 August 2021 08:31 By: Michel Cadot
any option for this query 10g By: rnemkul on Thu, 28 July 2022	1	12040	Fri, 29 July 2022 00:25 By: Michel Cadot
Time metrics in V$SQL don't add up Oracle 19c SE2 By: Andrey_R on Wed, 20 July 2022	7	6902	Sat, 23 July 2022 07:52 By: Andrey_R
Percentage of CPU utilization per instance Oracle 11g, 12c By: db_senior on Thu, 05 August 2021	5	18383	Sat, 23 July 2022 07:14 By: Andrey_R
query tunning oracle10g By: arun888 on Wed, 11 May 2022	11	22516	Tue, 24 May 2022 06:26 By: John Watson
excessive parsing ? DB SE2 19.3.0.0.0 By: John Watson on Fri, 13 May 2022	2	14137	Sun, 15 May 2022 05:33 By: John Watson
Re-Partitioning 19C By: deepakdot on Mon, 02 May 2022	2	13695	Wed, 04 May 2022 02:06 By: deepakdot
Correlated subquery iteration DB 19.3 (unpatched) By: John Watson on Fri, 18 February 2022	3	10125	Sat, 19 February 2022 05:46 By: Michel Cadot
Long running queries Oracle, 18.0.0.0.0, Linux By: BalajiDBA on Mon, 04 October 2021	19	21329	Thu, 07 October 2021 23:14 By: BalajiDBA
Slow Archive Apply in Physical Standby Oracle EE 12.2 , Linux 7 By: Akmmhto on Tue, 07 September 2021	5	15553	Thu, 09 September 2021 02:44 By: John Watson
The predicate prevents the optimizer from using indices efficiently 12.2 By: lisyloo12 on Fri, 23 July 2021	1	10470	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	15070	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	7408	Wed, 09 June 2021 10:28 By: Michel Cadot
Query running slow 19c By: JackBauer on Wed, 31 March 2021	13	20673	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	8103	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	12722	Fri, 26 February 2021 08:45 By: BlackSwan
I/O performance problem 12c R1 By: JackBauer on Thu, 11 February 2021	2	7993	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	14401	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	5784	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	9709	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	16547	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	7493	Thu, 15 October 2020 09:08 By: piripicchio
Application Performance Issue Oracle 11g,Linux 6 By: BalajiDBA on Sat, 10 October 2020	2	7886	Sat, 10 October 2020 03:18 By: Michel Cadot
Bitmap join index DB19.3 By: John Watson on Thu, 08 October 2020	0	6259	Thu, 08 October 2020 04:17 By: John Watson
Scalar subquery merging DB 19.x By: John Watson on Tue, 29 September 2020	3	8471	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	44433	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	9898	Tue, 22 September 2020 14:56 By: pallen38
New to tuning 12c By: mdarifdxb20 on Sun, 09 August 2020	1	9251	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	21669	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	17245	Wed, 08 April 2020 04:06 By: weekend79
Increase page loading speed By: mike05 on Thu, 05 March 2020	4	15557	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	12114	Fri, 14 February 2020 12:17 By: evoradba
Database performance tuning Oracle 11g,Linux 6 By: BalajiDBA on Sun, 09 February 2020	3	11065	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	23397	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	11055	Sat, 25 January 2020 02:07 By: John Watson
Database performance tuning (merged) 12c By: mha2020 on Sat, 18 January 2020	3	12066	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	12129	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	18919	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	17514	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	12163	Sat, 07 September 2019 06:36 By: Michel Cadot