Here's a dumb bash script...
Steve Orr
--
#! /bin/bsh
#
# dotkprof.bsh
# Steve Orr 6/15/01
#
export ORACLE_HOME=whatever
export ORACLE_SID=whatever
ORACLE_BASE=whatever
UDUMPDIR="$ORACLE_BASE/Admin/$ORACLE_SID/udump"
CURDIR=`pwd`
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 sys=no