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'));
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'));