4.267 DBA_FREE_SPACE_COALESCED
DBA_FREE_SPACE_COALESCED
describes statistics on coalesced space in all tablespaces in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the tablespace |
|
|
|
Total number of free extents in the tablespace |
|
|
|
Total number of coalesced free extents in the tablespace |
|
|
|
Percentage of coalesced free extents in the tablespace |
|
|
|
Total number of free bytes in the tablespace |
|
|
|
Total number of coalesced free bytes in the tablespace |
|
|
|
Total number of free Oracle blocks in the tablespace |
|
|
|
Total number of coalesced free Oracle blocks in the tablespace |
|
|
|
Percentage of coalesced free Oracle blocks in the tablespace |