xplan utility - copyright (C) 2008-2012 Alberto Dell'Era, www.adellera.it

Uncompress this .zip in a directory of your choice.

Change local directory to that directory (or add it to your SQLPATH environment variable).

Log in sqlplus, than run the script
@xplan <sql like> <options, comma-separated>

See xplan.sql comment header for more informations.


TO RUN it...can use below cmds....

-- @xplan "" "sql_id=a1nxudt81v5y7,tabinfos=n,objinfos=n"
-- @xplan "" "sql_id=a1nxudt81v5y7"