查询执行计划: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%'