![]() Hash value of the currently executing actionĬlient information (as per DBMS_APPLICATION_INFO.SET_CLIENT_INFO) Name of the currently executing action (as per DBMS_APPLICATION_INFO.SET_ACTION) Hash value of the currently executing module Name of the currently executing module (as per DBMS_APPLICATION_INFO.SET_MODULE) SQL identifier for the last SQL statement executedĬhild number for the last SQL statement executed ![]() Identifies the last SQL statement executed (used with PREV_SQL_ADDR) Identifies the last SQL statement executed (used with PREV_HASH_VALUE) SQL identifier for the SQL statement currently being executedĬhild number for the SQL statement currently being executed Identifies the SQL statement currently being executed (used with SQL_ADDRESS) Identifies the SQL statement currently being executed (used with SQL_HASH_VALUE) It can be one of the following: DEDICATED, SHARED, PSEUDO, or NONE. It can be one of the following: ACTIVE, INACTIVE, KILLED, CACHED, or SNIPED. User identifier who owns the migratable session The V$SESSION view contains the following columns: ColumnĪddress of the process that owns the session This SELECT statement will return each username that is logged in. The syntax to retrieve the users logged into Oracle is: SELECT USERNAME FROM V$SESSION
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |