1、set timi on:查看SQL执行的时间
SQL> set timi on
SQL> select * from hs_sett.fusettarg;
执行结果如下:
FUTU_EXCH_TYPE PREV_DATE INIT_DATE NEXT_TRADE_DATE BUSINESS_DATE SYS_STATUS SETT_BATCH_NO
-------------- ----------- ----------- --------------- ------------- ---------- -------------
F1 20180410 20180411 20180412 20180411 1 0
F2 20180410 20180411 20180412 20180411 1 0
F3 20180410 20180411 20180412 20180411 1 0
F4 20180410 20180411 20180412 20180411 1 0
F5 20180410 20180411 20180412 20180411 1 0
Executed in 0.125 seconds
2、explain plan for:查看执行计划
SQL> explain plan for select * from hs_sett.fusettarg;
Explained
select * from table(dbms_xplan.display);
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 2858018777
-------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 5 | 155 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| FUSETTARG | 5 | 155 | 3 (0)| 00:00:01 |
-------------------------------------------------------------------------------
8 rows selected