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