Re: How big or full is a table?

From: <argosy22_at_my-deja.com>
Date: 2000/05/05
Message-ID: <8eul6k$tim$1@nnrp1.deja.com>#1/1

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