Hi all ,
How do we find which sid is executing a particular procedure ??
Thanks
Printable View
Hi all ,
How do we find which sid is executing a particular procedure ??
Thanks
Use dbms_application_info.set_module in your package/procedure to set the module and action .
You can query v$session (module and action).
HTH
you can guess using v$access and v$open_cursors