Re: How to Find Data Blocks

From: Lev Smirnov <leo_at_dionis.sura.com.ru>
Date: Thu, 12 Oct 2000 04:36:06 GMT
Message-ID: <8s3f3m$k79$1@nnrp1.deja.com>

In article <a%8F5.12641$j%6.275799_at_wagner.videotron.net>, "JS" <ghp_at_videotron.ca> wrote:
> Would like to know which view to query to find out which blocks in
any given
> data file actually contain data, and which blocks are empty. Thank
you,
> running Oracle 8 PE on Win 95.
>
>

You can use view DBA_FREE_SPACE to list free extents in tablespaces. FILE_ID - ID number of the datafile,
BLOCK_ID - starting block number of the extent, BLOCKS - size of extent in blocks.

Lev Smirnov
Brainbench MVP for Oracle Admin
http://www.brainbench.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 11 2000 - 23:36:06 CDT