When a database or table is created, the allocated disk space is divided evenly among all AMPs. The TableSize view returns one row of usage information for each AMP in the system (or for all AMPs if the SUM aggregate is used).
Corresponding Tables
The X view references these additional tables:
- DBC.AccessRights
- DBC.Owners
- DBC.RoleGrants
- DBC.Roles
CurrentPerm
CurrentPerm returns the permanent space (in bytes) used by the database or table. The CurrentPerm column value includes all AMPs unless a specific AMP is requested.
PeakPerm
Use the DBC.ClearPeakDisk macro to reset the PeakPerm column.