Find Machine ID by SQL ID
need 'SELECT ANY DICTIONARY' grant
SQL
SELECT A.MODULE, A.USERNAME, A.MACHINE, B.SQL_ID, C.SQL_TEXT FROM V$SESSION A, V$ACTIVE_SESSION_HISTORY B, V$SQL C
WHERE A.SID = B.SESSION_ID
AND B.SQL_ID = C.SQL_ID
AND B.SQL_ID = 'byxtkdvmvgtpz'
GROUP BY A.MODULE, A.USERNAME, A.MACHINE, B.SQL_ID, C.SQL_TEXT;
thank you for following me in advance. i will upvote and comment on your every post if you do the same we both are new on steemit.if it works for you let me know just reply this post
Congratulations @nngumzzil! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOP
Congratulations @nngumzzil! You received a personal award!
Click here to view your Board of Honor
Congratulations @nngumzzil! You received a personal award!
You can view your badges on your Steem Board and compare to others on the Steem Ranking
Vote for @Steemitboard as a witness to get one more award and increased upvotes!