title: How to list all user session paramters in Oracle SQL?
body: <p>How do I list all user session parameters in Oracle Database?</p>
  
  <p>I found that Oracle provides <strong>SYS_CONTEXT</strong> function (<a href="http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions165.htm" rel="nofollow noreferrer">link</a>) allowing to retrieve chosen parameter in a following manner:</p>
  
  <pre><code>SELECT SYS_CONTEXT ('USERENV', 'NLS_CURRENCY') FROM DUAL;
  SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL;
  ...
  </code></pre>
  
  <p>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 (<a href="https://ferhatsengonul.wordpress.com/2010/07/21/to-show-nls-parameters-for-session-database-instance-together-by-pivot-and-listagg-on-11gr2/" rel="nofollow noreferrer">link</a>):</p>
  
  <pre><code>SELECT * FROM nls_session_parameters;
  </code></pre>
  
  <p>So back to my original question - <strong>How can I list ALL user session parameters?</strong></p>
  
  <p>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 <a href="http://www.oracle-wiki.net/startsqllistsessiondetails" rel="nofollow noreferrer">this one</a>.</p>