2014.8.6学习Oracle记录:set autotrace on

  开启Oracle跟踪的语句set autotrace on要在sqlplus环境中运行，在PL/SQL Developer中执行始终弹出cannot set autotrace。加了索引的SQL，查询速度会很快！

Oracle统计信息，还不明白是什么意思

9 recursive calls

0 db block gets

61 consistent gets

4 physical reads

0 redo size

420 bytes sent via SQL*NET to client

400 bytes received via SQL*NET from client

2 SQL*NET roundtrips to/from client

0 sorts(memory)

0 sorts(disk)

1 rows processed