title: Is there any way to get information about current session from gv$session in oracle?
body: <p>Is there any way to uniquely identify current session in <code>GV$SESSION</code> view in Oracle?</p>
  
  <p>I've faced with the problem that the following query may return more than one row in case of Oracle RAC configuration:</p>
  
  <pre><code>SELECT SID, SERIAL#
  FROM GV$SESSION
  WHERE AUDSID = Sys_Context('USERENV', 'SESSIONID')
     AND SID = Sys_Context('USERENV', 'SID');
  </code></pre>
  
  <p>Using <code>V$MYSTAT</code> is not an option either, because <code>V$MYSTAT</code> may not be accessible for the current session (for example when statistic is disabled).</p>