Statistically you will lose one half of the last extent.
So if you have 1,000 tables you have (4MB) * (1/2) * (1,000) = 2GB
of unused space.
> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Peter
> Barnett
> Sent: Wednesday, January 24, 2001 10:41 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Bytes Used Inside an Extent
>
>
> Does anyone have a script to determine the bytes actually used by an
> extent? We are using locally managed tablespaces with uniform extents
> for a warehouse. Once the tables are loaded, they will be static until
> they are reloaded.
>
> Just running the math, I have am pretty sure that the last extent (4M in
> size) is near empty for most of the tables. I would like to be able to look into
> that last extent and confirm my suspicions.
>
> Thanks,
>
>
> Pete Barnett
> Oracle Database Administrator
> Regence BlueCross BlueShield
> pnbarne_at_regence.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Peter Barnett
> INET: pnbarne_at_shep.bcbso.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Wed Jan 24 2001 - 11:55:09 CST
