生成执行计划 explain plan for select * from xxxx where xxx = xxx;查看索引使用明细 select * from table(dbms_xplan.display);