Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

DMLs are performing slow after upgrade to 19.20

Giriraj BahediyaNov 29 2023

Hi,

On our database large table DMLs are performing is slow on database upgrade from Oracle 19.16 non-CDB to Oracle 19.20 CDB.

OS - Solaris 11.4.58.144.3

Example of DML-

DELETE FROM LARGE_TAB WHERE COL1 = :1 AND COL2 = :2;

UPDATE ( SELECT /*+ PARALLEL(a,2) PARALLEL(b,2) */ a.Col1,b.Col2,a,Col3,a.Col4 FROM Tab1 A,Tab2 B WHERE a.Coln=b.Coln);

LARGE_TAB, Tab2 and Tab2 are large tables.

Any Help!!

Comments
Post Details
Added on Nov 29 2023
0 comments
89 views