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.

[former_member618524]

riazmohamed did you find any solution for this ? can you please let me know