Slow performance for inserts and updates in 19c databases
Noticing slowness in the performance of inserts and updates on tables which are row store advanced compressed after the upgrade from 18c to 19c.
The conventional inserts and updates are performing slow in the 19c environments, this is a consistent behaviour across all the databases which we upgraded to 19c.
Here is the select statement and its plan-
INSERT INTO "TEST" ("BILLING_PERIOD", "ZBILL_TYPE", "Z_ADJ", "INTOPBEL", "STO_OPBEL", "INVOICING_PARTY", "BCBLN", "AGGR_BUDAT", "BEGABRPE", "ENDABRPE", "Z_ADJ_FR", "Z_ADJ_TO", "BELZART", "ABRMENGE", "PREISBTR", "NETTOBTR", "MWSKZ", "TARIFTYP", "LOAD_GRP_NAME", "SCENARIO", "Z_CUST_TYPE", "Z_BILL_OPTION", "VSTELLE", "Z_MI_IND", "EINZDAT", "AUSZDAT", "ZEBSCTRCTACC", "CC_EFF_DATE", "CC_EXP_DATE", "CPUDT", "CPUTM", "ZACC_ACT_DATE", "Z_IGS_ACCT", "Z_DRS_ACCT", "Z_EG_ACC", "Z_METER_TYPE", "Z_PAID_BY", "Z_GEN_CAP", "Z_METER_OP", "Z_CAPACITY", "MANDT", "BUDAT", "BUKRS", "PARTNER", "VKONT", "OPBEL", "FIKEY", "BELZEILE") VALUES (:A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15, :A16, :A17, :A18, :A19, :A20, :A21, :A22, :A23, :A24, :A25, :A26, :A27, :A28, :A29, :A30, :A31, :A32, :A33, :A34, :A35, :A36, :A37, :A38, :A39, :A40, :A41, :A42, :A43, :A44, :A45, :A46, :A47) |