Re: Which dict. table stores the Block usage details for every segment (w/o. analyze table/index) ?

Home -> Community -> Usenet -> c.d.o.server -> Re: Which dict. table stores the Block usage details for every segment (w/o. analyze table/index) ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 21 Sep 1999 15:48:20 +0100
Message-ID: <937926046.17976.0.nnrp-07.9e984b29@news.demon.co.uk>

On a block by block basis, you cannot find out without querying each block in turn, which you could do using the 'dump block' methods (again see my website).

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Mehul Zaveri wrote in message <7s84ud$6c211_at_news.emirates.net.ae>...
>I think I am not clear in my question. I want block usage. i.e. How much %
>of each block is free (remember pctfree, pctused) in a given segment and
how
>much room does it have (or doesn;t have) to fillup of more rows including
>the deatils of chained/migrated rows if any.
Received on Tue Sep 21 1999 - 09:48:20 CDT