How to trace SQL in a procedure?

From: <Richard_Pomeroy_at_usa.net>
Date: Wed, 07 Apr 1999 13:42:56 GMT
Message-ID: <7efncu$202$1@nnrp1.dejanews.com>

I have a PL/SQL procedure that needs to be tuned. I would like to obatin a trace in the same format as the 'set autotrace on' option for sqlplus. Is there anyway of switching this on? I have taken a look at the 'alter session set sql_trace true', but it's not as neat or as readable as autotrace.

Can anyone help.

Thanks

Richard Pomeroy

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 07 1999 - 08:42:56 CDT