select /*+ all_rows */ distinct owner, segment_name, segment_type
from dba_extents where file_id = &filid
and &blkid between block_id and block_id+blocks-1;
select /*+ all_rows */ distinct owner, segment_name, segment_type
from dba_extents where file_id = &filid
and &blkid between block_id and block_id+blocks-1;