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

来源:互联网 时间:1970-01-01

   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

原来是打开了审计功能。

 

相关阅读:
Top