hmm ok, my post got messed up

should been

tkprof "file_name" report.txt (this will be the output. It will show the execution plan for the statement)

tkprof can be found in $ORACLE_HOME/bin