RA_ACTIVE_SESSION
This view lists information about active client sessions currently running in the Recovery Appliance.
| Column | Data Type | NULL | Description |
|---|---|---|---|
|
|
|
The Recovery Appliance instance number where this session is running. |
|
|
|
|
The Recovery Appliance instance name where this session is running. |
|
|
|
|
The Recovery Appliance host name where this session is running. |
|
|
|
|
The session ID for the active session. |
|
|
|
|
The session serial number, which uniquely identifies the objects in a session. |
|
|
|
|
The operating system process identifier. |
|
|
|
|
The primary key for this database in the recovery catalog. |
|
|
|
|
The unique database name. |
|
|
|
|
The SBT session identifier. |
|
|
|
|
The client Identifier of the session. |
|
|
|
|
The name of the module that is currently executing. |
|
|
|
|
The name of the action that is currently executing. |
|
|
|
|
The SQL identifier of the SQL statement that is currently being executed. |
|
|
|
|
The resource or event for which the session is waiting. |
|
|
|
|
First wait event parameter |
|
|
|
|
The second wait event parameter. |
|
|
|
|
The third wait event parameter. |
|
|
|
|
The wait time in hundredths of a second. See description of |
|
|
|
|
The wait time (in seconds). If the session is currently waiting, then the value is the amount of time waited for the current wait. If the session is not in a wait, then the value is the amount of time since the start of the most recent wait. |
|
|
|
|
The state of the wait event: |
|
|
|
|
The task identifier. |
|
|
|
|
The task type. |
|
|
|
|
The task priority. |
|
|
|
|
The processing state for the task: |
|
|
|
|
The |
|
|
|
|
The tenant name for this database in the Recovery Appliance. |
|
|
|
|
The customer tenant identifier for this database in the Recovery Appliance. |