Hi all ,
How do we find which sid is executing a particular procedure ??
Success Consists of Getting Up Just One More Time Than You've Fallen Down
Use dbms_application_info.set_module in your package/procedure to set the module and action .
You can query v$session (module and action).
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
you can guess using v$access and v$open_cursors