Re: Block_id in the dba_free

From: Michel Cadot <micadot_at_altern.org>
Date: Fri, 13 Aug 1999 14:22:40 +0200
Message-ID: <7p12nu$20r$1@oceanite.cybercable.fr>

dba_free_space contains a row for each free extent in the tablespaces per file. BLOCK_ID is the id of the first block in the file for the current extent and BLOCKS is the size of the extent in blocks.

There is no extent_id in dba_free_space.

Wind a écrit dans le message <37ab8965.32902439_at_news.earthlink.net>...
>
>hey guys,
>
> How are you all doing?
>
> I have a question regarding the column "BLOCK_ID" in the view,
>dba_free_space. I know what a data block is. For example, in this
>site that I am working on, data block is defined as 8k. What really
>is the BLOCK_ID? How does it related to EXTENT_)D?
>
>thanks in advance.
>
>Michael
>
>mleung_at_earthlink.net or mleung_at_intelus.com
>
>WindyCloud
>7k_at_gamestats.com
>
>Realms of the Kingdoms, http://7k.gamestats.com
>
Received on Fri Aug 13 1999 - 07:22:40 CDT

Re: Block_id in the dba_free_space