Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01

Library
Product
Contents
Index

Go to previous page Go to beginning of chapter Go to next page

Static Data Dictionary Views, 155 of 452

DBA_FREE_SPACE_COALESCED

DBA_FREE_SPACE_COALESCED contains statistics on coalesced space in tablespaces.

Column  Datatype  NULL  Description 

TABLESPACE_NAME 

VARCHAR2(30) 

NOT NULL 

Name of tablespace 

TOTAL_EXTENTS 

NUMBER 

 

Total number of free extents in tablespace 

EXTENTS_COALESCED 

NUMBER 

 

Total number of coalesced free extents in tablespace 

PERCENT_EXTENTS
_COALESCED 

NUMBER 

   

Percentage of coalesced free extents in tablespace 

TOTAL_BYTES 

NUMBER 

   

Total number of free bytes in tablespace 

BYTES_COALESCED 

NUMBER 

   

Total number of coalesced free bytes in tablespace 

TOTAL_BLOCKS 

NUMBER 

   

Total number of free Oracle blocks in tablespace 

BLOCKS_COALESCED 

NUMBER 

   

Total number of coalesced free Oracle blocks in tablespace 

PERCENT_BLOCKS
_COALESCED 

NUMBER 

   

Percentage of coalesced free Oracle blocks in tablespace 

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index