Re: How big or full is a table?

You're also being a bit heavy-handed about it:

column segment_name format a25 (add TRUNC if you only want 25 chars for some reason)
select segment_name,bytes,blocks,extents,max_extents from dba_segments order by bytes;

AW

<argosy22_at_my-deja.com> wrote in message news:8eul6k$tim$1_at_nnrp1.deja.com...
> Thanks,
>
> I've wrote a script which gives me a good indication:
>
>
> Select substr(SEGMENT_NAME, 1, 25) segment_name,
> sum(bytes) sum_of_bytes,
> sum (blocks) sum_of_blocks,
> count(1) extent_count
> from dba_extents
> group by segment_name
> order by sum(bytes)
>
>
> Ciao,
>
> Argosy
>
>
> In article <8esl9a$o1i$1_at_nnrp1.deja.com>,
> argosy22_at_my-deja.com wrote:
> > 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.
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri May 05 2000 - 00:00:00 CDT