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 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.
> Chris

Alfonso Leon

Other related posts: