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

In versions newer than about 7.1.6 there is a package called dbms_space which can
interrogate the segment header block and report high water mark details. It can also run along the free list and tell you how many blocks are on the free list.

My web site has an example of how you
can use this package to produce a report.

--

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

Mehul Zaveri wrote in message <7s7ag5$6c28_at_news.emirates.net.ae>...
>Hai all,
>Can we find out w/o. using analyze command, exact block usage of segment?
>Based on output, we can make decision of reorganizing BIG tables. Any
ideas?
>
>Kind regards,
>Mehul Zaveri,
>Oracle DBA
Received on Tue Sep 21 1999 - 08:12:50 CDT