Size of extent file - Forum - OpenEdge General - Progress Community
 Forum

Size of extent file

This question is not answered

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?

All Replies
  • > 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?

    Consulting in Model-Based Development, Transformation, and Object-Oriented Best Practice  http://www.cintegrity.com

  • 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.