Re: Trace Files and Stored Procedures
- From: Alfonso León <aleon68@xxxxxxxxx>
- To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- Date: Thu, 27 Jan 2005 20:04:05 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
