SESSION_PARAMETER

Purpose

This function returns the session parameter value of a given session and a parameter name.

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;