Oracle DB blocks for cartentries table(UPDATE cartentries)

[riazmohamed]

We are seeing db blocks coming from cart randomly.

I have seen main blocker coming from Update Cartentries always:

UPDATE cartentries SET hjmpTS = :1 ,modifiedTS=:2 ,p_calculated=:3 ,p_taxvaluesinternal=:4 WHERE PK = :5

This db blocks affects delete or other cart operations.

This db block affects the whole website and its very slow and once we kill the db blocks then site would perform normally.

We have around 10M records in cartentries table.

anyone know how to fix this issue or reduce the number of db blocks.

thanks in advance.

[JamesZ]

Can you share more about the "Oracle DB blocks" you meant? Did you see oracle event "enq: row lock contention"?

Best regards,
James (I am mainly focusing on SAP NetWeaver on Oracle topic).

[riazmohamed]

Sorry for the late reply , yes , please find attached the screenshot for the same db-blocks.png