Re: show table space

From: R. Schierbeek <bytelifeNospam_at_gmail.com>
Date: Wed, 24 May 2006 10:43:38 +0200
Message-ID: <4474199c$0$61104$dbd4b001@news.wanadoo.nl>

Hi Peter, this will do it:

clear columns breaks
col KBYTES head 'Used|Kbytes'
col Segment_name for a30
col TABLESPACE_NAME for A18
break on Segment_name

select substr(owner,1,12) Owner

        ,substr(segment_name,1,30) Segment_name
        ,tablespace_name
        ,substr(segment_type,1,6)  type
        ,rtrim(to_char((bytes/1024),'999,999,999')) KBytes
        ,rtrim(to_char(extents,'99999')) Ext

from sys.DBA_SEGMENTS
where segment_name like upper ('&name%') order by owner,segment_name
/

cheers,

   Roelof Schierbeek; DBA

<cmk128_at_hotmal.cm> wrote
> Hi
> I want to know how many space of a table has consumed, may i know
> how to ??
> i cannot select the information from table space.
> thanks
> from Peter
Received on Wed May 24 2006 - 03:43:38 CDT