Hi All,

The P1 field in V$SESSION_WAIT view contains the File# of the file being
accessed for 'direct path read' wait events, and other file I/O wait
events for that matter.

How can I determine if the File# is for a Data or Temp file as defined in
the V$DATAFILE and V$TEMPFILE views, as they can both use the same
File#s ?

I've searched the documentation and cannot find the answer to this.

Thanks Phil




Oracle LazyDBA home page