Get active sid of a pl/sql object - Oracle Database Script.
SELECT sid,
sql_id,
serial#,
status,
username,
program
FROM v$session
WHERE PLSQL_ENTRY_OBJECT_ID IN
(SELECT object_id
FROM dba_objects
WHERE object_name IN ('&PROCEDURE_NAME'));