Explain Plan Utility
A handy Explain Plan script for SQL*Plus. Gets the plan for the current contents of the SQL*Plus buffer, i.e. whatever statement you've most recently run or listed out (you don't have to run the SQL to see the plan). After displaying the plan, it sets the buffer back how it was so you can continue working. Just type:
@xplan
[an error occurred while processing this directive]