![]() ![]() 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 execution identifier NULL if SQL_ID is NULL or if the execution of that SQL has not yet started (see V$SQL_MONITOR) Time when the execution of the SQL currently executed by this session started NULL if SQL_ID is NULL 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 ![]() Such sessions will not be allowed to become active again. SNIPED - An inactive session that has exceeded some configured limits (for example, resource limits specified for the resource manager consumer group or idle_time specified in the user's profile). INACTIVE - Session which is inactive and either has no configured limits or has not yet exceeded the configured limitsĬACHED - Session temporarily cached for use by Oracle*XA The low-order 2 bytes represent the session number and the high-order bytes represent the instance ID of the query coordinator.Īddress of the lock the session is waiting for NULL if none Identifier of the user who owns the migratable session the column contents are invalid if the value is 2147483644įor operations using Parallel Slaves, interpret this value as a 4-byte value. You can find the command name for any value n returned in this COMMAND column by running this SQL query:Ī value of 0 in this COMMAND column means the command is not recorded in V$SESSION. If the database is configured for mixed mode auditing, then this column displays the traditional auditing session IDĪddress of the process that owns the sessionĬommand in progress (last statement parsed).If the database is configured for unified auditing, then this column displays the unified auditing session ID.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. Used to uniquely identify a session's objects. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |