|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon6.gif](/forum/images/message_icons/icon6.gif) |
sticky: Performances and tuning |
10 |
58504 |
Wed, 11 August 2021 08:31 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Table Statistics Keep Getting Stale Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
6 |
16328 |
Wed, 03 April 2024 12:41 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query output speed very slow oracle 12c, windows |
1 |
23229 |
Sun, 31 December 2023 02:46 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Profiles after upgrade from 11g to 19c Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
2 |
18011 |
Tue, 07 November 2023 10:30 By: wtolentino ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Regarding dba_scheduler_windows Oracle 19c |
1 |
13951 |
Thu, 21 September 2023 05:58 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to reduce query Cost Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production |
5 |
14932 |
Tue, 08 August 2023 07:45 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Bind by position Oracle 19c, Windows |
5 |
32862 |
Fri, 28 July 2023 06:14 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Cannot force indexing on alert log query Oracle 19c, Windows Server 2019 |
4 |
26807 |
Wed, 07 June 2023 10:22 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
rdbms 12.2C performance issues sometimes RDMS oracle 12C linux ODA HW |
4 |
26928 |
Thu, 11 May 2023 08:58 By: evoradba ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Sql having performance issue 19c |
6 |
25355 |
Mon, 28 November 2022 12:28 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Why *is* my index used? oracle 19c Linux |
4 |
23204 |
Sat, 29 October 2022 10:51 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Understanding UNDO 11g Oracle RDBMS 11G, Windows Server 2019 |
1 |
17003 |
Thu, 27 October 2022 05:48 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
gather statistics on partition table Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
2 |
16465 |
Fri, 21 October 2022 04:49 By: wtolentino ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Sql behaving badly after upgrade (merged) 19c |
5 |
16170 |
Tue, 18 October 2022 11:07 By: nishant1987 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
any option for this query 10g |
1 |
23609 |
Fri, 29 July 2022 00:25 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Time metrics in V$SQL don't add up Oracle 19c SE2 |
7 |
21021 |
Sat, 23 July 2022 07:52 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Percentage of CPU utilization per instance Oracle 11g, 12c |
5 |
32804 |
Sat, 23 July 2022 07:14 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query tunning oracle10g |
11 |
37639 |
Tue, 24 May 2022 06:26 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
excessive parsing ? DB SE2 19.3.0.0.0 |
2 |
24785 |
Sun, 15 May 2022 05:33 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Re-Partitioning 19C |
2 |
23955 |
Wed, 04 May 2022 02:06 By: deepakdot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Correlated subquery iteration DB 19.3 (unpatched) |
3 |
20958 |
Sat, 19 February 2022 05:46 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Long running queries Oracle, 18.0.0.0.0, Linux |
19 |
39702 |
Thu, 07 October 2021 23:14 By: BalajiDBA ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Slow Archive Apply in Physical Standby Oracle EE 12.2 , Linux 7 By: Akmmhto on Tue, 07 September 2021 |
5 |
26253 |
Thu, 09 September 2021 02:44 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
The predicate prevents the optimizer from using indices efficiently 12.2 |
1 |
19751 |
Fri, 23 July 2021 13:04 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Access Advisor from SQL*Plus Oracle 11g, 12c |
8 |
29212 |
Mon, 05 July 2021 12:35 By: db_senior ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Function blocking itself Oracle, 12.1.0.2, Windows By: patdev on Wed, 09 June 2021 |
1 |
16435 |
Wed, 09 June 2021 10:28 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query running slow 19c |
13 |
34033 |
Tue, 13 April 2021 05:17 By: JackBauer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Cannot index temp table after inserting rows Linux\Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
2 |
18329 |
Wed, 03 March 2021 03:42 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL ID changes Plan hash value 12c R1 |
5 |
22768 |
Fri, 26 February 2021 08:45 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
I/O performance problem 12c R1 |
2 |
16491 |
Fri, 12 February 2021 06:20 By: JackBauer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
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 |
22807 |
Fri, 12 February 2021 06:15 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
TKPROF showing wrong totals for non-recursive statements Oracle 12.1.0.2.0 |
0 |
13291 |
Thu, 11 February 2021 06:19 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-12705: Cannot access NLS data files or invalid environment specified with jmeter test Oracle Database 19.7, jmeter 5.3 |
1 |
18705 |
Tue, 01 December 2020 21:27 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL_Text on SQL Profile Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 |
2 |
26423 |
Sun, 22 November 2020 12:56 By: LNossov ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon11.gif](/forum/images/message_icons/icon11.gif) |
DBMS_SQLTUNE.REPORT_SQL_DETAIL: html report issue Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
0 |
15197 |
Thu, 15 October 2020 09:08 By: piripicchio ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Application Performance Issue Oracle 11g,Linux 6 |
2 |
16502 |
Sat, 10 October 2020 03:18 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Bitmap join index DB19.3 |
0 |
13331 |
Thu, 08 October 2020 04:17 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Scalar subquery merging DB 19.x |
3 |
16695 |
Tue, 29 September 2020 13:43 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Different SQL ID for same SQL/HASH_VALUE 10.2.0.3, Solaris 5.9 |
11 |
56421 |
Mon, 28 September 2020 01:45 By: amujawane ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Physical read IO requests higher than total 12.2, Linux 64 |
6 |
18511 |
Tue, 22 September 2020 14:56 By: pallen38 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |