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

From: Andy Johnson <AJohnson_at_Armature.com>
Date: Thu, 25 Oct 2001 08:29:49 +0100
Message-ID: <783866CAB183D211883F0090271F46C208BDA84A@COW>

Hi..

You could also concider looking at the dbma_space package.

regards

andy

-----Original Message-----
From: allanwtham_at_yahoo.com (godmann) [mailto:allanwtham_at_yahoo.com] Posted At: 25 October 2001 03:51
Posted To: server
Conversation: how to figure out how much disk space is being used? Subject: 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 Thu Oct 25 2001 - 02:29:49 CDT