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://ybzwz.com/article/ppedcg.html