Use this feature to indicate the progress of long running PL/SQL operations (set with dbms_application_info.)
Columns ___________________________ SID SERIAL# OPNAME TARGET TARGET_DESC SOFAR TOTALWORK UNITS START_TIME LAST_UPDATE_TIME TIME_REMAINING ELAPSED_SECONDS CONTEXT MESSAGE USERNAME SQL_ADDRESS SQL_HASH_VALUE QCSID
Related:
DBMS_APPLICATION_INFO.set_session_longops DBMS_APPLICATION_INFO.set_module V$ACCESS V$MYSTAT V$PROCESS V$SESSION.sid V$SESSION_CONNECT_INFO V$SESSION_CURSOR_CACHE V$SESSION_EVENT V$SESSION_OBJECT_CACHE V$SESSION_WAIT V$SESSTAT V$SESS_IO