v$session_wait p1 vrs. dba_extents file_id columns

 Hi all,

I'm trying to associate the p1 column of v$session_wait to the file_id column of either dba_extents or dba_data_files.

I'm running the following to provide the file_id and block_id for a second query...

SELECT p1 "file#", p2 "block#", p3 "class#"
FROM v$session_wait
WHERE event = 'latch: cache buffers chains';

followed by

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

The problem I'm having is that the p1 column from v$session_wait is not returning the &AFN (absolute file number).