If these are in house modifiable procedures, you could
use DBMS_APPLICATION_INFO to cause the package/procedure name to
appear in v$session.
Here are details:
http://www.oradoc.com/ora817/appdev.817/a76936/dbms_app.htm#999107
Jared
On Sunday 09 September 2001 19:15, Suhen Pather wrote:
> Lis
List,
Is there any way to tell what procedure rather than sql_text that is currently executing?
We are trying to develop a knowledge base were we require
this information.
I tried to check v$sqlarea, v$sqltext but could not find the relevant information in
the shared pool.
Any