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	60434	Wed, 11 August 2021 08:31 By: Michel Cadot
Simple Query on Table with Billions of rows getting ORA-01652 Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 25 September 2024	10	10683	Wed, 02 October 2024 10:24 By: cookiemonster
Parallel Degree Limit correct num to use on Parallel Hints Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 11 September 2024	10	6651	Wed, 11 September 2024 13:10 By: John Watson
Table Statistics Keep Getting Stale Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 03 April 2024	6	17756	Wed, 03 April 2024 12:41 By: John Watson
query output speed very slow oracle 12c, windows By: hissam78 on Sun, 31 December 2023	1	24974	Sun, 31 December 2023 02:46 By: Michel Cadot
SQL Profiles after upgrade from 11g to 19c Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Tue, 07 November 2023	2	20010	Tue, 07 November 2023 10:30 By: wtolentino
Regarding dba_scheduler_windows Oracle 19c By: shipon_97 on Thu, 21 September 2023	1	15891	Thu, 21 September 2023 05:58 By: John Watson
How to reduce query Cost Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: chat2raj.s on Tue, 08 August 2023	5	16002	Tue, 08 August 2023 07:45 By: John Watson
Bind by position Oracle 19c, Windows By: Andrey_R on Sun, 14 May 2023	5	34042	Fri, 28 July 2023 06:14 By: Andrey_R
Cannot force indexing on alert log query Oracle 19c, Windows Server 2019 By: Andrey_R on Sun, 28 May 2023	4	27809	Wed, 07 June 2023 10:22 By: Michel Cadot
rdbms 12.2C performance issues sometimes RDMS oracle 12C linux ODA HW By: evoradba on Fri, 05 May 2023	4	29852	Thu, 11 May 2023 08:58 By: evoradba
Sql having performance issue 19c By: nishant87 on Sun, 27 November 2022	6	26622	Mon, 28 November 2022 12:28 By: John Watson
Why is my index used? oracle 19c Linux By: Andrey_R on Sun, 23 October 2022	4	24201	Sat, 29 October 2022 10:51 By: John Watson
Understanding UNDO 11g Oracle RDBMS 11G, Windows Server 2019 By: esirenko on Thu, 27 October 2022	1	17712	Thu, 27 October 2022 05:48 By: John Watson
gather statistics on partition table Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Wed, 19 October 2022	2	17750	Fri, 21 October 2022 04:49 By: wtolentino
Sql behaving badly after upgrade (merged) 19c By: nishant1987 on Tue, 18 October 2022	5	17330	Tue, 18 October 2022 11:07 By: nishant1987
any option for this query 10g By: rnemkul on Thu, 28 July 2022	1	24290	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	22415	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	34064	Sat, 23 July 2022 07:14 By: Andrey_R
query tunning oracle10g By: arun888 on Wed, 11 May 2022	11	39233	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	25545	Sun, 15 May 2022 05:33 By: John Watson
Re-Partitioning 19C By: deepakdot on Mon, 02 May 2022	2	24678	Wed, 04 May 2022 02:06 By: deepakdot
Correlated subquery iteration DB 19.3 (unpatched) By: John Watson on Fri, 18 February 2022	3	21756	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	41916	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	29772	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	21243	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	30679	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	18315	Wed, 09 June 2021 10:28 By: Michel Cadot
Query running slow 19c By: JackBauer on Wed, 31 March 2021	13	35635	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	18993	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	23822	Fri, 26 February 2021 08:45 By: BlackSwan
I/O performance problem 12c R1 By: JackBauer on Thu, 11 February 2021	2	19005	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	23618	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	13755	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	19371	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	28706	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	15693	Thu, 15 October 2020 09:08 By: piripicchio
Application Performance Issue Oracle 11g,Linux 6 By: BalajiDBA on Sat, 10 October 2020	2	18404	Sat, 10 October 2020 03:18 By: Michel Cadot
Bitmap join index DB19.3 By: John Watson on Thu, 08 October 2020	0	13845	Thu, 08 October 2020 04:17 By: John Watson
Scalar subquery merging DB 19.x By: John Watson on Tue, 29 September 2020	3	17437	Tue, 29 September 2020 13:43 By: Michel Cadot