SESSION_PARAMETER function

Detail name	Value
Changelog Number	9377
Type	New Feature
Status	Resolved
Fix Versions	Exasol 7.0.0
Resolution Date	2020-09-11

 

Feature description

We introduce the new scalar function  SESSION_PARAMETER. This function returns the session parameter value of a given session and a parameter name. The return type could be numeric or string, according the parameter itself.

Numeric: 'NLS_FIRST_DAY_OF_WEEK', 'QUERY_TIMEOUT', 'TEMP_DB_RAM_LIMIT', 'USER_TEMP_DB_RAM_LIMIT', 'SESSION_TEMP_DB_RAM_LIMIT'
String: The rest

Examples:

SELECT SESSION_PARAMETER(current_session, 'NLS_FIRST_DAY_OF_WEEK') AS SESSION_VALUE;

SESSION_VALUE
7

SELECT SESSION_PARAMETER(current_session, 'NLS_TIMESTAMP_FORMAT') AS SESSION_VALUE;

SESSION_VALUE
YYYY-MM-DD HH24:MI:SS.FF6

SELECT SUM(SESSION_PARAMETER(session_id, 'SESSION_TEMP_DB_RAM_LIMIT')) AS TOTAL_TEMP_DB_RAM from exa_all_sessions;

TOTAL_TEMP_DB_RAM
1000

Benefits
This feature makes it easy to retrieve a session parameter value.

Restrictions
A user can only query session parameters of its own session, unless it has SELECT ANY DICTIONARY privilege.