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

A copy of this was sent to "Rauno Seppanen" <rauno.seppanen_at_icon.fi> (if that email address didn't require changing) On Thu, 3 Sep 1998 22:59:14 +0300, you wrote:

>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?
>

You can get all of this information from the call_stack (dbms_utility.format_call_stack) -- you'll have to parse it out but its there.

>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
>>
>>
>>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.