I'm querying the V$SESSION_WAIT for the "buffer busy waits" event, but the P1 parameter which is the FILE # does not exist when queried in DBA_DATA_FILES or in DBA_TEMP_FILES. Why is that so? Am I missing something? Please help.
Note: I'm not dropping neither did I drop any tablespace.
Our version of Oracle is 11gR2.
SQL> select event, p1 "File #", p2 "Block #", p3 "Reason Code", wait_class from v$session_wait
where event = 'buffer busy waits';
EVENT File # Block # Reason Code WAIT_CLASS
------------------------------ ---------- ---------- ----------- ------------------------------
buffer busy waits 1033 2 13 Concurrency
buffer busy waits 1033 2 13 Concurrency
buffer busy waits 1033 2 13 Concurrency
SQL> select * from dba_data_files
2 where file_id = 1033;
no rows selected
SQL> select * from dba_temp_files
2 where file_id = 1033;
no rows selected