Name of the currently executing action as set by calling the DBMS_APPLICATION_INFO.SET_ACTION procedure Name of the currently executing module as set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure SQL identifier of the last SQL statement executedĬhild number of the last SQL statement executed Used with SQL_HASH_VALUE to identify the last SQL statement executed Used with PREV_HASH_VALUE to identify the last SQL statement executed SQL identifier of the SQL statement that is currently being executedĬhild number of the SQL statement that is currently being executed Used with SQL_ADDRESS to identify the SQL statement that is currently being executed Used with SQL_HASH_VALUE to identify the SQL statement that is currently being executed

Server type ( DEDICATED| SHARED| PSEUDO| NONE) SNIPED - Session inactive, waiting on the client The low-order 2 bytes of which represent the session number, and the high-order bytes the instance ID of the query coordinator.Īddress of lock waiting for null if noneĬACHED - Session temporarily cached for use by Oracle*XA Otherwise, this column contains the identifier of the user who owns the migratable session.įor operations using Parallel Slaves, interpret this value as a 4-byte value.

The column contents are invalid if the value is 2147483644. These values also appear in the AUDIT_ACTIONS table. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.Īddress of the process that owns the sessionĬommand in progress (last statement parsed) for a list of values, see Table 7-5. Used to uniquely identify a session's objects.

Sononym active