Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trace Stored Procedures
Hi,
If I understand the question, you can see what is in your SGA by quering these views V$DB_OBJECT_CACHE and V$SQLAREA
Dias
sunny313_at_hotmail.com (Sunny Singh) wrote in message news:<f3f27ff5.0112051550.3e8f3d72_at_posting.google.com>...
> Can somebody tell how to find out what stored procedures the
> application called. I need the list of stored procedures which were
> invoked from the application. Is turning sql_trace=true a good option
> for this case? Or, can I set an "event" before I run the application?
>
> Pl help.
>
> Thanks.
Received on Thu Dec 06 2001 - 11:10:10 CST