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

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

   ;       0          0         12           0

05 Fetch        2      0.00       0.00          0          1          0           1

06 ------- ------  -------- ---------- ---------- ---------- ----------  ----------

07 total        4      0.79       0.90          0          1         12           1

08

09 Misses in library cache during parse: 1

10 Optimizer mode: ALL_ROWS

11 Parsing user id: 64

12

13 Rows     Row Source Operation

14 -------  ---------------------------------------------------

15       1  SORT AGGREGATE

16       0   FILTER

17       0    INDEX RANGE SCAN IND_T_PREBM4 (object id 38674)

18

19 Elapsed times include waiting on following events:

20   Event waited on                             Times   Max. Wait  Total Waited

21   ----------------------------------------   Waited  ----------  ------------

22   direct path write                               1        0.00          0.00

23   SQL*Net message to client                       2        0.00          0.00

24   SQL*Net message from client                     2       27.20         27.22

1 insert into sys.fga_log$(sessionid,timestamp#,dbuid,osuid,obj$schema,obj$name,

2   policyn

 

相关阅读:
Top