查看oracle 方法,oracle查看性能的方法

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