Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Block_id in the dba_free_space
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