SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to solve buffer busy waits due to Concurrent INSERTS?

0614Nov 25 2020

Hi,
we are using 19C DB ,
we got top event buffer busy waits , identified most wait time on insert .
culprit table insert - having one PK

after identifying insert as culprit , i don't have any clue how to proceed further?

please help how to solve this kind of problem?

This post has been answered by Jonathan Lewis on Nov 28 2020

Jump to Answer

Added on Nov 25 2020

#performance, #plsql, #sql, #tuning

5 comments

9,439 views

1 mention