Hi
As far as the documentation is concerned consistent gets
is gets from rollbac segments. I dont understand why in a database just bounced and no activity at all wen I run this query
select * from emp;
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
4 consistent gets
0 physical reads
0 redo size
198 bytes sent via SQL*Net to client
309 bytes received via SQL*Net from client
4 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
consistent gets is 4? I mean there is no DML why db block gets is 0 and consistent gets is 4...? Doesnt it should be the other way round?
cheers
