Hi all , How do we find which sid is executing a particular procedure ?? Thanks
Success Consists of Getting Up Just One More Time Than You've Fallen Down Be Blessed
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
Sanjay G. 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
Forum Rules