DBMS_SPACE
This package enables the analysis of segment growth and space requirements.
Procedures
The most relevant procedures are:
CREATE_TABLE_COST
: determines the size of a tableCREATE_INDEX_COST
: determines the size of an indexFREE_BLOCKS
: returns information about free blocks in an objectSPACE_USAGE
: returns information about free blocks in a segment managed by automatic space management