执行计划查看

    技术2022-05-18  13

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


    最新回复(0)