Brother-Eagle™ Oracle Performance
Advice: Buffer Busy Waits

Buffer busy waits occur when two processes are attempting to access the same buffer concurrently.

The V$SESSION view provides valuable information for researching this event:

Select row_wait_obj# from v$session where event = 'buffer busy waits'

The return value from this statement can then be used to query DBA_OBJECTS using the row_wait_obj# as the data_object_id.

View full list of Oracle advice topics