Monday, 16 January 2017



Oracle – Find consuming sql from process id


SELECT SQL_TEXT
FROM v$sql
WHERE sql_id = (SELECT sql_id FROM v$session WHERE paddr = (sELECT addr
FROM v$process
WHERE spid = '&process_id'));

No comments:

Post a Comment