Trace Files and Stored Procedures

From: Alfonso León <aleon68_at_gmail.com>
Date: Tue, 25 Jan 2005 21:34:49 -0500
Message-ID: <83a585ac050125183418edce2d@mail.gmail.com>

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

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 25 2005 - 21:37:17 CST