sql数据库走索引,怎么始终有物理读?(3)_MySQL
ame,scn,plhol,sqlbind,oshst,clientid,extid,lsqltext)
3 values
4 (:1,sysdate,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13)
01 call count cpu elapsed disk query current rows
02 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
03 Parse 1 0.00 0.00 0 0 0 0
04 Execute 1 2.09 2.94 1 2 2 1
05 Fetch 0 0.00 0.00 0 0 0 0
06 ------- ------ -------- ---------- ---------- ---------- ---------- ----------
07 total 2 2.09 2.94 1 2 2 1
08
09 Misses in library cache during parse: 1
10 Optimizer mode: CHOOSE
11 Parsing user id: SYS (recursive depth: 1)
12
13 Elapsed times include waiting on following events:
14 Event waited on Times Max. Wait Total Waited
15 ---------------------------------------- Waited ---------- ------------
16 direct path read (lob) 1 0.00 0.00
原来是打开了审计功能。
bitsCN.com