E.3 MON$CONTEXT_VARIABLES

MON$CONTEXT_VARIABLES displays information about custom context variables.

Column Name Data Type Description
MON$ATTACHMENT_ID BIGINT Connection identifier. It contains a valid value only for a connection-level context variable. For transaction-level variables it is NULL.
MON$TRANSACTION_ID BIGINT Transaction identifier. It contains a valid value only for transaction-level context variables. For connection-level variables it is NULL.
MON$VARIABLE_NAME VARCHAR(80) Context variable name
MON$VARIABLE_VALUE VARCHAR(32765) Context variable value

Retrieving all session context variables for the current connection

1. SELECT
2. VAR.MON$VARIABLE_NAME,
3. VAR.MON$VARIABLE_VALUE
4. FROM MON$CONTEXT_VARIABLES VAR
5. WHERE VAR.MON$ATTACHMENT_ID = CURRENT_CONNECTION