Re: Newbie - How can I check diskspace usage?

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!
>
> --
> Earvin Lim
> -- Programmer/Analyst
> -- Academic Computing Services
> -- University of Texas at Arlington
> email: earvin_at_omega.uta.edu
> Phone: (817)272-3678

Another way is to

select tablespace_name, file_name, sum(bytes) (you can also divide by

from sys.dba_data_files                         1048576 to get Meg)

T. M. Gray
Principal
Sirius, Inc.
Denver, CO Received on Sat Dec 07 1996 - 00:00:00 CET