Re: used/free space in a segment or extent

Henry,

It is possible to do such query.

Here is the example:
http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi?s=3ce15fd747bfffff;act=ST; f=15;t=190;hl=hwm
(all this goes in one line)

For more information or ideas check the latest Oracle DBA forums: http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi

Hope that helps,

Trifon Anguelov
Senior Oracle DBA

http://www.dbaclick.com

"Henry" <henry_2303_at_hotmail.com> wrote in message news:zQaE8.4822$t8_.223_at_news01.bloor.is.net.cable.rogers.com...
> 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.
>
>
>
Received on Wed May 15 2002 - 01:09:54 CDT