-- 실행계획 수집 
SQL> EXPLAIN PLAN FOR
     SELECT *
     FROM   EMP E
     WHERE  E.EMPNO  = 9999999   
       AND    E.DEPTNO = 10; 

-- BASIC FORMAT으로 조회
SQL> SELECT * 
     FROM TABLE(DBMS_XPLAN.DISPLAY(NULL, NULL, 'BASIC'));

----------------------------------------------
| Id  | Operation                   | Name   |
----------------------------------------------
|   0 | SELECT STATEMENT            |        |
|   1 |  TABLE ACCESS BY INDEX ROWID| EMP    |
|   2 |   INDEX UNIQUE SCAN         | EMP_U1 |
----------------------------------------------