(*) from v$session_wait where wait_time=0 and event = 'buffer busy waits' group by event, p1, p2, p3; select ses.sql_hash_value, sql.sql_text from v$session ses , v$sql sql where ses.sid IN (SELECT sid FROM v$lock WHERE request <> 0) and ses.sql_hash_value = sql.hash_...