While going through the AWR report found that the row lock waits on indexes and buffer busy waits are more (rest of the stats look normal).
Could someone tell me if we can interpret by the below if it (row lock waits & buffer busy waits) is the cause of slowness? Or the stats look ok based on the DB time.
Thank you for your time.
Can we reduce the row lock waits on indexes and reduce the buffer busy waits by further tuning of IX1_PCWAUDITLOG, IX1_PCWREQRESP & LOBSEG_NEW (image).