![session meaning session meaning](http://image.slideserve.com/226341/benefits-strategy-n.jpg)
This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ# is not -1.
![session meaning session meaning](https://i.ytimg.com/vi/1f8r1Rj2N4s/sddefault.jpg)
Identifier for the datafile containing the row specified in ROW_WAIT_ROW#. Object ID for the table containing the row specified in ROW_WAIT_ROW# All the other sessions have been idle since the last time the performance monitor looked at the database. Each time the performance monitor looks at the database, it only needs to look at sessions that are currently active or have a higher value in this column than the highest value that the performance monitor saw the last time. This column can be used by performance monitors to monitor statistics in the database. This contains a number that increases every time the session completes a call to the database and there has been an intervening select from a dynamic performance table. Information set by the DBMS_APPLICATION_INFO.SET_CLIENT_INFO procedure 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
![session meaning session meaning](https://i.ytimg.com/vi/bf1OZGptz_8/maxresdefault.jpg)
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.