hi,
Given the statistic reports about the number of extents, Initial , Next is it possible to find the number of blocks in the extent.
How else do we find the number of blocks for each extent?
Badrianth
Printable View
hi,
Given the statistic reports about the number of extents, Initial , Next is it possible to find the number of blocks in the extent.
How else do we find the number of blocks for each extent?
Badrianth
Divide extent size with block size, what you get z no of blocks.
Right ?
yeah!,
I just wanted to know if any of the V$.. tables gives it?
badrianth
There is a blocks column in these views. I Guess thats what you wanted.
DBA_EXTENTS
DBA_SEGMENTS