EXPLAIN PLAN FOR SELECT * FROM TB_USER;

    select * from table(dbms_xplan.display);

Plan hash value: 1576953371

-----------------------------------------------------------------------------
| Id  | Operation         | Name    | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |         |   389K|   103M|  4075   (1)| 00:00:49 |
|   1 |  TABLE ACCESS FULL| TB_USER |   389K|   103M|  4075   (1)| 00:00:49 |
-----------------------------------------------------------------------------

分享题目：oracleexplain
文章源于：http://tyjierui.cn/article/ppedcg.html