First page Back Continue Last page Graphics

V$SESSION_WAIT


Notes:

We see in this example the Oracle reports the wait event as “sbtbackup”. I have been waiting for 1000 seconds (16 minutes) for a tape to be mounted.
Chapter 15 of the Oracle9i Recovery Manager User’s Guide lists all the possible tape-related events: sbtinit sbtopen sbtread sbtwrite sbtbackup.
See the supplied script v$session_longops.sql for a working sample of this code.