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.
I have already checked the sql id in VACTIVE_SESSION_HISTORY but didn’t get any results.
I am able to find the sql id in vsql where SQL_ID=’0jf4618m2u7aw’ order by LAST_LOAD_TIME desc; 2016-07-04/17:26:02 2016-07-04/17:26:02 select * from VACTIVE_SESSION_HISTORY where SQL_ID=’0jf4618m2u7aw’; no rows selected
Please help. Thanks in advance.