Trace Files and Stored Procedures

  • From: Alfonso León <aleon68@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 25 Jan 2005 21:34:49 -0500

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?

Also do you know if there is a restriction on using SQL_TRACE
sometimes it doesn't generate the trace files.

Thanks in advance for your suggestios

Alfonso Leon

Other related posts: