#1
  1. Daniel Schildsky
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Mar 2004
    Location
    KL, Malaysia.
    Posts
    1,555
    Rep Power
    1621

    explain plan for stored procedures


    Hi all,

    I am trying to generate the execution plan for a stored procedure in SQLPlus console of Oracle server. I tried :

    Code:
         EXPLAIN PLAN FOR EXEC <stored procedure name>(<param list>);
    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?
    When the programming world turns decent, the real world will turn upside down.
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539

IMN logo majestic logo threadwatch logo seochat tools logo