Re: used storage space

From: darryl dB Balaski <darryl_e_balaski_at_groton.pfizer.com>
Date: Thu, 28 Jan 1999 12:20:32 -0500
Message-ID: <36B09C5F.797170C8@groton.pfizer.com>

Try this query, It will prompt you for tablename....

select  substr(s.owner,1,15),
        substr(s.segment_name,1,25),
        substr(s.segment_type,1,1),
        TO_CHAR(s.extents,'9,999') "Ext",
        TO_CHAR(s.max_extents,'99,999') "MaxExt",
        to_char(s.Blocks,'9,999,999') "Blocks",
        to_char(s.bytes,'9,999,999,999') "Bytes",
        to_char(s.initial_extent, '999,999,999') "Initial",
        to_char(s.next_extent,  '999,999,999') "Next",
        to_char(t.PCT_used,  '999') "Used",
        to_char(t.PCT_free,  '999') "Free"

from dba_segments s, dba_tables t

where s.owner not in ('SYS','SYSTEM')
and   s.segment_type = 'TABLE'
and   s.segment_name = t.table_name
and   s.segment_name = upper('&&TABLENAME')

order by s.owner, s.segment_name
/

Victor Zwimpfer wrote:

> Hi,
>
> Is there a possibility to find out, how much storage space is effectivly
> used by a couple of tables? I have to find out, how much space (average
> value) is needed by an address ( a relationship of ca. 5 tables).
>
> Thank you
> Victor
Received on Thu Jan 28 1999 - 11:20:32 CST