September 26th, 2005, 11:50 PM
explain plan for stored procedures
I am trying to generate the execution plan for a stored procedure in SQLPlus console of Oracle server. I tried :
but it complained that there is missing keyword. Does anybody know how we can generate the execution plan for a stored procedure by its name?
EXPLAIN PLAN FOR EXEC <stored procedure name>(<param list>);
When the programming world turns decent, the real world will turn upside down.
September 27th, 2005, 02:18 AM
I don't think you can, but you can of course explain individually the selects it contains.