执行计划查看

查询执行计划：
select * from table(dbms_xplan.display(null,null,'advanced'));
select * from table(dbms_xplan.display_cursor('fc9vvz3s82gyk',null,'advanced'));

查询游标：
select sql_id,child_number, sql_text from v$sql where sql_text like '%emp%' and sql_text not like '%v$sql%'