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
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.