Explain the output of V$SESSION_WAIT

[omegamark]

Can anyone explain how to information from this statement ..



SQL> SELECT * FROM V$SESSION_WAIT WHERE SID=34;

SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIME SECONDS_IN_WAIT STATE
---------- ---------- ---------------------------- ----------------------- ---------- -------- ----------------------- ---------- -------- ----------------------- ---------- -------- ---------- --------------- -------------------
34 42586 direct path read file number 3 00000003 first dba 16574 000040BE block cnt 1 00000001 -2 0 WAITED UNKNOWN TIME

[Shestakov]

May be i wrong or not completed.
-----------------------------
event- direct path read - this is opepration (probably exp/imp)
then address of db block:
file number 3
block# 16574
address in db cache 000040BE
#of continius blocks in db cache 1

direct path read was waiting this block in db cache, becuase it being read (or write) by another session.

[omegamark]

Thanks ...