Re: how to figure out how much disk space is being used?

Hi there,

   To find out how many disk space taken for a particular tablespace you can do a

   select sum(bytes)
   from dba_segments
   where tablespace_name='XYZ'

   Likewise, for a table or any object, do a

   select sum(bytes)
   from dba_segments
   where segment_name ='TABLE_NAME'

Allan W. Tham
DBA Received on Wed Oct 24 2001 - 21:50:33 CDT