欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2022-06-12 12:24:40
...
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
相关标签: 3 sql数据库