当前位置:Gxlcms > mysql > sql数据库走索引,怎么始终有物理读?(3)_MySQL

sql数据库走索引,怎么始终有物理读?(3)_MySQL

时间:2021-07-01 10:21:17 帮助过:80人阅读

bitsCN.com

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

人气教程排行