Hi All,

I am trying to get the object information related to performance issues. File#, block# information received from v$session_wait. Some of the online documents suggest to use the query:

SELECT relative_fno, owner, segment_name, segment_type 
 FROM dba_extents 
 WHERE file_id = &file_id
 AND &block BETWEEN block_id AND block_id + blocks - 1;

However, I am comfortable to use the below given query:

SELECT relative_fno, owner, segment_name, segment_type 
 FROM dba_extents 
 WHERE file_id = &file_id
 and block_id=&block_id

Both of them provide the same result. Is there any difference between the queries? How will it benefit?

Regards,
A