参考《oracle性能优化实务》
(最好还是看AWR报告的Segments by Buffer Busy Waits)
select event,p1,p2,p3 from v$session_wait where event like 'buffer busy wait%';
select owner,segment_name from dba_extents where file_id=&p1 and block_id<=&p2 and (block_id+blocks)>=&p2;
参考《oracle性能优化实务》
(最好还是看AWR报告的Segments by Buffer Busy Waits)
select event,p1,p2,p3 from v$session_wait where event like 'buffer busy wait%';
select owner,segment_name from dba_extents where file_id=&p1 and block_id<=&p2 and (block_id+blocks)>=&p2;