Database Administrator Guide > Database Administrator Guide > Calculating Disk Space > Space Requirements for Tables > Calculation of Allocated Table Size
Was this helpful?
Calculation of Allocated Table Size
VDBA automatically calculates table size based on the number of allocated pages. Using VDBA, select a table and select the Pages tab to view the pages property sheet.
Alternatively, the allocated_pages field in the iitables standard catalog can be used to calculate table size based on the number of allocated pages. You can calculate:
• The size of the table on disk as:
iitables.allocated_pages * PageSize
• The number of free pages left in the table as:
iitables.allocated_pages – iitables.number_pages
Last modified date: 04/03/2024