Re: Newbie - How can I check diskspace usage?

earvin_at_omega.uta.edu (Earvin C. Lim) wrote:
>We have created a database in a UNIX file system and have allocated
>about 400MB to it. How can we check the actual diskspace that is in use?
>
>Thanks!
>

Hi there,

You can issue the following query to find out the tablespace and its usages.

SELECT SEGMENT_NAME, SUM(BYTES)
FROM DBA_SEGMENTS
WHERE SEGMENT_TYPE = 'TABLESPACE'
GROUP BY SEGMENT_NAME The space allocated to each tablespace can be obtained from DBA_TABLESPACES select * from dba_tablespaces;

Regards

N.Prabhakar Received on Fri Dec 06 1996 - 00:00:00 CET