首页 > 代码库 > AUTOTRACE

AUTOTRACE

17:46:15 HR@ datacenter>set autotrace onlyUsage: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]17:47:36 HR@ datacenter>set autot trace17:47:50 HR@ datacenter>select * from employees;107 rows selected.Execution Plan----------------------------------------------------------Plan hash value: 1445457117-------------------------------------------------------------------------------| Id  | Operation         | Name      | Rows  | Bytes | Cost (%CPU)| Time     |-------------------------------------------------------------------------------|   0 | SELECT STATEMENT  |           |   107 |  7383 |     3   (0)| 00:00:01 ||   1 |  TABLE ACCESS FULL| EMPLOYEES |   107 |  7383 |     3   (0)| 00:00:01 |-------------------------------------------------------------------------------Statistics----------------------------------------------------------          0  recursive calls          0  db block gets         14  consistent gets          0  physical reads          0  redo size      10427  bytes sent via SQL*Net to client        601  bytes received via SQL*Net from client          9  SQL*Net roundtrips to/from client          0  sorts (memory)          0  sorts (disk)        107  rows processed