Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

DBA_FREE_SPACE_COALESCED

DBA_FREE_SPACE_COALESCED describes statistics on coalesced space in all tablespaces in the database.

Column Datatype NULL Description

TABLESPACE_NAME

VARCHAR2(30)

NOT NULL

Name of the tablespace

TOTAL_EXTENTS

NUMBER

Total number of free extents in the tablespace

EXTENTS_COALESCED

NUMBER

Total number of coalesced free extents in the tablespace

PERCENT_EXTENTS
_COALESCED

NUMBER

  

Percentage of coalesced free extents in the tablespace

TOTAL_BYTES

NUMBER

  

Total number of free bytes in the tablespace

BYTES_COALESCED

NUMBER

  

Total number of coalesced free bytes in the tablespace

TOTAL_BLOCKS

NUMBER

  

Total number of free Oracle blocks in the tablespace

BLOCKS_COALESCED

NUMBER

  

Total number of coalesced free Oracle blocks in the tablespace

PERCENT_BLOCKS
_COALESCED

NUMBER

  

Percentage of coalesced free Oracle blocks in the tablespace