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 V
ACTIVE_SESSION_HISTORY where SQL_ID=’0jf4618m2u7aw’;
no rows selected
Please help. Thanks in advance.
Anonymous Asked question May 13, 2021
Recent Comments