Re: How to find out which procedure is currently executing ?

I guess the Oracle way is following:
'Use the SET_MODULE and SET_ACTION procedures in the DBMS_APPLICATION_INFO package to record the name of the executing module or transaction in the database for use later when tracking the performance of various modules. Registering the application allows system administrators and performance tuning specialists to track performance by module. System administrators can also use this information to track resource usage by module. When an application registers with the database, its name and actions are recorded in the V$SESSION and V$SQLAREA views. Registering applications is described in the Oracle7 Server Tuning manual.'
So actually I would be interested how You have solved the problem withous using these SET_MODULE and SET_ACTION procedures to find out what is happening in Oracle?

Regards, Rauno

> In a trigger I would like to know which procedure (if any) is currently
>executing.
>Now I'm using a package. But maybe there's another, _Oracle_ way to find
 out
>which procedure (if any) is currently running ?
>
>Regards,
>George
>
>
>
Received on Thu Sep 03 1998 - 00:00:00 CDT