-
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
Sofiane
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|