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@xxxxxxxxxxxx> 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

Other related posts: