Counts the permanent, temporary, spool, and persistent spool space used by each object in a database. For databases that use global space allocation, the allocations across the AMPs are fixed. If any AMP has excessive space, this procedure deallocates space appropriately.
Use this procedure to fix phantom spool problems or correct inconsistencies in the DBC.DATABASESPACE table, which may occur because of rare types of system failures.