Hi,

I am trying to learn a batch process that runs every night. So, I ran the batch process on a development database by doing the following:

DECLARE
l_result BINARY_INTEGER;
BEGIN
DBMS_TRACE.set_plsql_trace (DBMS_TRACE.trace_all_calls);
run_batch(10);
DBMS_TRACE.clear_plsql_trace;
end;
/

I thought if I could trace the batch run then I could see which procedure is being called in which order and so on. But, this created like 4million + rows just for one batch run. So, I am wondering what constants should I set to just trace the procedural calls.

And also if a cursor has 1000 rows and within the cursor for loop a procedure is being called, does the dbms_trace log 1000 calls to this procedure? How can I avoid this.

Appreciate any thoughts or suggesgtions.
ThankYou,
Manasa.

Oracle LazyDBA home page