SQLPULS 에서 실행계획 보는 방법

  1. sqlplus 실행
    $ sqlplus userid/passwd
  2. plan table 생성
    SQL> @?/admin/utlxplan.sql
  3. execution plan를 화면에 표시하도록 설정
    SQL> SET autot ON
  4. plan를 보기 원하는 sql 실행
    SQL> SELECT * FROM member;
     
    ...
     
    257 ROWS selected.
     
     
    Execution Plan
    ----------------------------------------------------------
     
    -----------------------------------------------------------------
    | Id  | Operation         | Name   | ROWS  | Bytes | Cost (%CPU)|
    -----------------------------------------------------------------
    |   0 | SELECT STATEMENT  |        |   257 | 37265 |     5   (0)|
    |   1 |  TABLE ACCESS FULL| MEMBER |   257 | 37265 |     5   (0)|
    -----------------------------------------------------------------
     
    Note
    -----
       - 'PLAN_TABLE' IS OLD version
     
     
    Statistics
    ----------------------------------------------------------
            813  recursive calls
              0  db block gets
            184  consistent gets
             10  physical reads
             72  redo SIZE
          43330  bytes sent via SQL*Net TO client
            587  bytes received via SQL*Net FROM client
             19  SQL*Net roundtrips TO/FROM client
              5  sorts (memory)
              0  sorts (disk)
            257  ROWS processed