SESSION_PARAMETER
Purpose
This function returns the session parameter value of a given session and a parameter name.
Syntax
session_parameter::=
Usage Notes
- A user can only query session parameters from the user's own session, unless the user has the
SELECT ANY DICTIONARY
privilege. The session parameters are available in the EXA_PARAMETERS system table. -
If the session id is illegal, the function returns
NULL
. - The return type depends on the parameter.
Examples
SELECT SESSION_PARAMETER(current_session, 'NLS_FIRST_DAY_OF_WEEK') AS SESSION_VALUE;
SELECT SESSION_PARAMETER(current_session, 'NLS_TIMESTAMP_FORMAT') AS SESSION_VALUE;
SELECT SUM(SESSION_PARAMETER(session_id, 'SESSION_TEMP_DB_RAM_LIMIT')) AS TOTAL_TEMP_DB_RAM from exa_all_sessions;