Hello,

Suppose that you cache a table T1 having :

NUM_ROWS : 150904
BLOCKS : 3140
EMPTY_BLOCKS : 25019
AVG_ROW_LEN : 76
INITIAL_EXTENT : 115343360
NEXT_EXTENT : 10485760

Extent : 1
DB_block : 4Ko


I would like to cache this table in the buffer cache, I would like to know the number of buffer blocks that will be occupied :

28160 (3140+25019+1) buffer blocks (110 Mo)
or
only : 3140 (12,3 Mo)

Thanks in advance

Sofiane