📋Steps in this guide1/1

Get active sid of a pl/sql object

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

oracle configurationintermediate

by OracleDba

21 views

Get active sid of a pl/sql object

Code/Command (click line numbers to comment):

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!