Database Tuning (MOSC)

MOSC Banner

Slow performance for inserts and updates in 19c databases

edited Jul 19, 2020 11:08PM in Database Tuning (MOSC) 27 commentsAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center