오라클 실행계획 보기

1. explain plan for
   select * from emp;

    select * from table(dbms_xplan.display);

2. explain plan
    set statement_id = 'stmt1' for
    select * from emp;

    select * from table(dbms_xplan.display('plan_table','stmt1','all'));
    select * from table(dbms_xplan.display('plan_table','stmt1','typical'));
    select * from table(dbms_xplan.display('plan_table','stmt1','basic'));