Find object from the file id and block number

by Granville Bonyata on October 5, 2016

Every time I hit a wait event where I want to see what object is being hit, I have to look up the query to get the object from the file id and block #, so I’m posting it here for easy access:

select e.segment_name, e.*
FROM dba_extents e
WHERE file_id = 123456
AND 6327867 between block_id and block_id + blocks - 1

Previous post:

Next post: