这个 consistent gets怎么会这么大?
我就使用了一条SQL语句:select * from user_tables where table_name='SYSTEM_TABLE3'
统计信息如下:
Statistics
----------------------------------------------------------
231 recursive calls
0 db block gets
29765 consistent gets
3 physical reads
0 redo size
37405 bytes sent via SQL*Net to client
891 bytes received via SQL*Net from client
48 SQL*Net roundtrips to/from client
1 sorts (memory)
0 sorts (disk)
705 rows processed
按照我的理解:这个consistent gets怎么会这么大?是从回滚段读取了29765个数据块吗?
查了很多资料,不是很理解,希望能用通俗一点的话解释一下