Re: DBA_FREE_SPACE

From: m.mueller <m.mueller_at_snafu.de>
Date: Tue, 28 Aug 2001 20:42:15 +0200
Message-ID: <3B8BE607.8892EFF8@snafu.de>

>Hi,
>
>There are two columns in the view DBA_FREE_SPACE_COALESCED,
>called 'totaly_bytes' and 'bytes_coalesced'.
>
>What means 'coalesced' in this context? Or, does anyone know the difference
>between this two columns?
>
>Thanks
>Ralf

Hello Ralf,
take a look at http://technet.oracle.com/doc/server.815/a67790/ch2.htm#934 In very short:
TOTAL_BYTES: Total number (=sum) of free bytes in tablespace BYTES_COALESCED: Total number (=sum)of coalesced free bytes in tablespace. (Coalesced means process of 'connecting, linking' adjacent free Oracle Data Blocks -very very short).

For more info about Data Blocks, Extents, and Segments http://technet.oracle.com/doc/server.815/a67781/c02block.htm#2528 Take also a look at 'How Extents Are Allocated' in the same chapter of the document.
This should get you started.

Regards
Manuela Mueller Received on Tue Aug 28 2001 - 13:42:15 CDT

Re: DBA_FREE_SPACE_COALESCED