Re: Trace Stored Procedures

From: dias <ydias_at_hotmail.com>
Date: 6 Dec 2001 09:10:10 -0800
Message-ID: <55a68b47.0112060910.2867b8a2@posting.google.com>

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