Re: How big or full is a table?

Assuming you are using CBO which will need tables to be analyzed or you analyze to monitor segment characteristics, check dba_tables, this will tell you how many block are used in the allocated extents.

Dave

<argosy22_at_my-deja.com> wrote in message news:8esl9a$o1i$1_at_nnrp1.deja.com...
> Hi all,
>
> This is related to the extents questions that I
> had recently.
>
> A table will have a MAXEXTENTS property, and will
> be part of a tablespace, which will also have a
> MAXEXTENTS property.
>
> The table will only be able to expand to maximum
> extents of either the table, or the tablespace,
> whichever is lower. Correct?
>
> But how can we tell just how full a table is?
> If it can expand to a maximum of 100 extents,
> how can we tell how many extents that the data
> is currently taking up? Say, at 90 extents.
>
> A similar idea is that if all tables use the same
> tablespace, how can we tell which tables are
> taking up most of the tablespace/datafile?
>
> I've been searching the data dictionary for clues,
> but haven't found anything yet.
>
>
> Thanks,
>
> Argosy
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri May 05 2000 - 00:00:00 CDT