How do I list all user session parameters in Oracle Database?
I found that Oracle provides SYS_CONTEXT function (link) allowing to retrieve chosen parameter in a following manner:
SELECT SYS_CONTEXT ('USERENV', 'NLS_CURRENCY') FROM DUAL;
SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL;
...
This is not ideal as I would like to retrieve all parameters without naming them individually, as it is possible to do with nls_session_parameters (link):
SELECT * FROM nls_session_parameters;
So back to my original question - How can I list ALL user session parameters?
Are there any tables/viewes where all parameters can be retrieved in a smarter way? From my research what I found was rather cumbersome methods, like this one.