Hi,
Can anyone show me how to run explain plan on a whole
stored procedure? 815 on Sun 5.6. Thanks a lot.
Leslie
__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please
One idea would be to start SQL Trace for your session, execute the stored
procedure, stop SQL Trace.
That will create a trace file in your udump directory which you can format
using TKPROF to include the explain plan for each SQL statement executed.
E.g.,
tkprof x.trc formattedfile.txt
Here's a dumb bash script...
Steve Orr
--
#! /bin/bsh
#
# dotkprof.bsh user pwd script.sql tkprof.out
# Steve Orr 6/15/01
#
export ORACLE_HOME=whatever
export ORACLE_SID=whatever
ORACLE_BASE=whatever