hai in sqlplus

sql>set autotrace on
sql> run the query

it will list the details that you need