dbms_space may provide some of the info you want.
It won't tell you if the blocks are contiguous.
On Wednesday 05 February 2003 12:09, [EMAIL PROTECTED] wrote:
Does any have a script that shows actual # of used and free blocks in an
extent? I would like to determine the maximum # of
Do you mean something like this:
select max(bytes) from dba_free_space where tablespace_name = 'NAME';
-Original Message-
I would like to determine the maximum # of contiguous
free blocks within an extent
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
There is a script (last updated Nov 2000) on my
website that gets you part way. But there is no
way you can find out about the contiguity of free blocks
(at least not the ones below the HWM) as you have
to walk every freelist to find all the free blocks, then
sort them into physical order. It