hastechs.blogg.se

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

Subprogram ID of the currently executing PL/SQL object NULL if executing SQL Object ID of the currently executing PL/SQL subprogram NULL if executing SQL Subprogram ID of the top-most PL/SQL subprogram on the stack NULL if there is no PL/SQL subprogram on the stack Object ID of the top-most PL/SQL subprogram on the stack NULL if there is no PL/SQL subprogram on the stack SQL execution identifier of the last executed SQL statement SQL execution start of the last executed SQL statement 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