updating v$session_wait details for the session. Surprisingly (at least for me) wait time is 0 here.
Code:
SID EVENT WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS WAIT_TIME SECONDS_IN_WAIT STATE
---------- ------------------------------ ------------- ----------- --------------- ---------- --------------- -------------------
131 db file sequential read 1740759767 8 User I/O 0 0 WAITING
Last edited by vnktummala; 11-11-2010 at 12:37 PM.
Reason: typo
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Reply With Quote