Explanation about block_id in dba_extents
I have used below query to find the hot block(p2) and file(p1)
SELECT p1 "file#", p2 "block#", p3 "class#"
FROM v$session_wait
WHERE event ='latch: cache buffers chains';
In order to find the segment name and type we normally use this sql to find, but can any one explain clearly about this stmt.
WHERE file_id = &AFN and &BL between block_id AND block_id + blocks - 1
SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id = &AFN
and &BL between block_id AND block_id + blocks - 1
wat to give in &BL ?