RA_ACTIVE_SESSION
This view lists information about active client sessions currently running in the Recovery Appliance.
| Column | Data Type | NULL | Description |
|---|---|---|---|
INST_ID |
NUMBER |
The Recovery Appliance instance number where this session is running. | |
INSTANCE_NAME |
VARCHAR2(16) |
The Recovery Appliance instance name where this session is running. | |
HOST_NAME |
VARCHAR2(64) |
The Recovery Appliance host name where this session is running. | |
SID |
NUMBER |
The session ID for the active session. | |
SERIAL# |
NUMBER |
The session serial number, which uniquely identifies the objects in a session. | |
SPID |
VARCHAR2(24) |
The operating system process identifier. | |
DB_KEY |
NUMBER |
The primary key for this database in the recovery catalog. | |
DB_UNIQUE_NAME |
VARCHAR2(30) |
The unique database name. | |
SBT_SID |
VARCHAR2(64) |
The SBT session identifier. | |
CLIENT_IDENTIFIER |
VARCHAR2(64) |
The client Identifier of the session. | |
MODULE |
VARCHAR2(64) |
The name of the module that is currently executing. | |
ACTION |
VARCHAR2(64) |
The name of the action that is currently executing. | |
SQL_ID |
VARCHAR2(13) |
The SQL identifier of the SQL statement that is currently being executed. | |
EVENT |
VARCHAR2(64) |
The resource or event for which the session is waiting. | |
P1 |
NUMBER |
First wait event parameter | |
P2 |
NUMBER |
The second wait event parameter. | |
P3 |
NUMBER |
The third wait event parameter. | |
WAIT_TIME |
NUMBER |
The wait time in hundredths of a second. See description of V$SESSION.WAIT_TIME for more information. |
|
SECONDS_IN_WAIT |
NUMBER |
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. | |
STATE |
VARCHAR2(19) |
The state of the wait event: WAITING, WAITED UNKNOWN TIME, WAITED SHORT TIME, WAITED KNOWN TIME. See description of V$SESSION.STATE for more information. |
|
TASK_ID |
NUMBER |
The task identifier. | |
TASK_TYPE |
VARCHAR2(30) |
The task type. | |
PRIORITY |
NUMBER |
The task priority. | |
TASK_STATE |
VARCHAR2(13) |
The processing state for the task: EXECUTABLE, RUNNING, COMPLETED, TASK_WAIT, FAILED, and so on. |
|
JOB_NAME |
VARCHAR2(128) |
The DBMS_SCHEDULER job name. |
|
TENANT_NAME |
VARCHAR2 |
The tenant name for this database in the Recovery Appliance. | |
TENANT_IDENTIFIER |
NUMBER |
The customer tenant identifier for this database in the Recovery Appliance. |