Re: How to trace what is happening inside the stored procedure

Jaffar,

The problem is that the SP is invoked by Java program which makes the database connection from the connection pool. We don't have the control of which connection will be used for each execution.

On Sat, 5 Feb 2005 17:33:53 +0300, Jaffar_DBA <sjaffarhussain_at_gmail.com> wrote:
> I would suggest to trace with 10046 event.
> The best option would be
>
> set the following in your SP with execute immediate option.
>
> set tracefile_identifier = 'SP_TRACE'
> alter session set events '10046 trace name context forever, level 8'';
> ...procedure execution.
>
> alter session set events '10046 trace name context off';
>

--
http://www.freelists.org/webpage/oracle-l