Oracle-L: Re: Determine how many used and free blocks in an extent.

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 06 Feb 2003 01:23:53 -0800
Message-ID: <F001.005457AA.20030206012353@fatcity.com>

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, Rick_Cale_at_teamhealth.com 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 contiguous
> free blocks within an extent
>
> Thanks
> Rick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Feb 06 2003 - 03:23:53 CST