Help, I'm trying to get the total size of a database, as well as the size occupied by each of its extent files and not the actual size shown in the _AreaExtent table.
Any idea how to do that?
> the size occupied by each of its extent files and not the actual size shown in the _AreaExtent table.
Can you explain what do you mean? "Not actual" = "fake"?
I mean for example that each extent weighs 2 GB but really the space occupied by the extent file is 1.8 GB
Do you mean the physical size of the extent on disk or the amount of space the data occupies within the extent?
to the amount of space the data occupies within the extent
Such information is available only from dbanalys. But even dbanalys does not provide the statistics of space usage per extents.
In an area composed of multiple extents, the “space occupied” will be all the space up to the area’s high-water mark.
If you want to know the total number of bytes consumed by your data (without storage overhead), that can be obtained from the database analysis report or for an individual table or area by making binary dump files.