title: How to get machine name/ip address of a SQL query from which that was run using sql id in ORACLE
body: <p>I have the sql id of a query. Now I want to get the machine name and IP of the machine from which this query was run.</p>
  
  <p>I have already checked the sql id in V$SESSION and V$ACTIVE_SESSION_HISTORY but didn't get any results.</p>
  
  <p>I am able to find the sql id in v$sql and LAST_LOAD_TIME is today(7 July 2016).</p>
  
  <pre><code>select LAST_LOAD_TIME from v$sql where SQL_ID='0jf4618m2u7aw' order by LAST_LOAD_TIME desc;
  2016-07-04/17:26:02
  2016-07-04/17:26:02
  
  
  select * from V$SESSION where SQL_ID='0jf4618m2u7aw';
  no rows selected
  
  select * from V$ACTIVE_SESSION_HISTORY where SQL_ID='0jf4618m2u7aw';
  no rows selected
  </code></pre>
  
  <p>Please help. Thanks in advance.</p>