Oracle查看SQL执行信息

在查询语句前加上 explain plan for

explain plan for 
select
  * 
from
  HEAD 
where
  fcd = 'A1' 
  and fname= 'hu'

同时执行下面这条SQL

select * from table(dbms_xplan.display())