Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_RESUMABLE

Resumable session information for current user

Columns
   ___________________________
 
   SESSION_ID
      Session ID of this resumable session
   INSTANCE_ID
      Instance ID of this resumable session
   COORD_INSTANCE_ID
      Instance number of parallel query coordinator
   COORD_SESSION_ID
      Session number of parallel query coordinator
   STATUS
      Status of this resumable session
   TIMEOUT
      Timeout of this resumable session
   START_TIME
      Start time of the current transaction
   SUSPEND_TIME
      Suspend time of the current statement
   RESUME_TIME
      Resume time of the current statement
   NAME
      Name of this resumable session
   SQL_TEXT
      The current SQL text
   ERROR_NUMBER
      The current error number
   ERROR_PARAMETER1
      The 1st parameter to the current error message
   ERROR_PARAMETER2
      The 2nd parameter to the current error message
   ERROR_PARAMETER3
      The 3rd parameter to the current error message
   ERROR_PARAMETER4
      The 4th parameter to the current error message
   ERROR_PARAMETER5
      The 5th parameter to the current error message
   ERROR_MSG
      The current error message

Related:



Simon Sheppard
SS64.com