Skip to content

Latest commit

 

History

History
 
 

xplan

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.txt
README.txt
 
 
login.sql
login.sql
 
 
sess_active.sql
sess_active.sql
 
 
xplan.sql
xplan.sql
 
 
xplan_56pwkjspvmg3h_i1.lst
xplan_56pwkjspvmg3h_i1.lst
 
 
xplan_89b7r2pg1cn4a_i1.lst
xplan_89b7r2pg1cn4a_i1.lst
 
 
xplan_ash_body.sql
xplan_ash_body.sql
 
 
xplan_awr.sql
xplan_awr.sql
 
 
xplan_defines.sql
xplan_defines.sql
 
 
xplan_fr4562kczqpcx_i1.lst
xplan_fr4562kczqpcx_i1.lst
 
 
xplan_mcf_body.sql
xplan_mcf_body.sql
 
 
xplan_mcf_vars.sql
xplan_mcf_vars.sql
 
 
xplan_null_script.sql
xplan_null_script.sql
 
 
xplan_objinfos_body.sql
xplan_objinfos_body.sql
 
 
xplan_objinfos_vars.sql
xplan_objinfos_vars.sql
 
 
xplan_optim_env_body.sql
xplan_optim_env_body.sql
 
 
xplan_optim_env_vars.sql
xplan_optim_env_vars.sql
 
 
xplan_print_plan.sql
xplan_print_plan.sql
 
 
xplan_run.lst
xplan_run.lst
 
 
xplan_scf_body.sql
xplan_scf_body.sql
 
 
xplan_scf_vars.sql
xplan_scf_vars.sql
 
 
xplan_setup.lst
xplan_setup.lst
 
 
xplan_showcase.sql
xplan_showcase.sql
 
 
xplan_tabinfos_body.sql
xplan_tabinfos_body.sql
 
 
xplan_tabinfos_vars.sql
xplan_tabinfos_vars.sql
 
 
xplan_test.sql
xplan_test.sql
 
 
xplan_test_ass_stats.sql
xplan_test_ass_stats.sql
 
 
xplan_test_self.sql
xplan_test_self.sql
 
 
xplan_utilities_body.sql
xplan_utilities_body.sql
 
 
xplan_utilities_vars.sql
xplan_utilities_vars.sql
 
 

README.txt

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"