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 9.2.0.5. 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
--
//www.freelists.org/webpage/oracle-l

Other related posts: