Re: used/free space in a segment or extent

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 14 May 2002 18:59:33 +0200
Message-ID: <dig2eust1c70jij7h59ko4i5c1vojg37s7@4ax.com>

On Tue, 14 May 2002 16:21:51 GMT, "Henry" <henry_2303_at_hotmail.com> wrote:

>Hi,
>Lets say I create table with initial extent 10M so it takes 10M from a
>tablespace right away.
>But if the table is empty or have only few records the whole extent is not
>used up...
>Is it possible to see how much space is used /available within an extent??
>
>Thanks.
>
>

Please refer to the dbms_space package in your Oracle supplied packages manual or to the book of Thomas Kyte.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue May 14 2002 - 11:59:33 CDT