Re: Trace Files and Stored Procedures

Yep, It does in SQL*Plus but when I try to trace a stored procedure the STATS lines in the trace files from statements inside the stored procedures are gone.

I open a trace file from a session on sql*plus execute a select, the the stored procedure, in the trace files appears the execution plan of the select executed directly from the sql*plus but no execution plan nor stats from the statements inside of the stored procedure.

On Wed, 26 Jan 2005 14:38:15 +0100, Christian Antognini <Christian.Antognini_at_trivadis.com> wrote:
> Ciao Alfonso
>
> >I have 2 schemas A contains tables and B contains Stored Procedures
> >when I try to trace the stored procedures It doesn't register the
> >execution plans and the number or records of each step, although it
> >came with the parse, exec and fetch stats.
> >I'm running 9.2.0.5. Any Suggestions?
>
> The execution plans is stored in the trace file when the cursor is closed.
>
> The PL/SQL engine manages a cursor cache. In your case, I guess, this cache holds some cursors... if you close the session that called the procedure you should see the execution plans in the trace files.
>
> HTH
> Chris
>

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