Re: Find out free space for every tablespace

In article <4e6ho5$ign_at_tnn-wan.trw.com> Ted Do <tdo_at_mailsrv1.trw.com> writes:

>Unless I've misunderstood what you've asked for but
>the previous suggested SQL statements is unneccessary complex.
 

>How's about just use the following:
 

>select tablespace_name, sum(blocks) from sys.dba_free_space
>group by tablespace_name;
 

>-Ted.
 

>--
>=============================================
>= Theodore Do =
>= Senior Technical Specialist, UNIX/ORACLE =
>= TRW Information Technology Services =
>= tdo_at_mailsrv1.trw.com =
>=============================================

I use
 select tablespace_name, sum(BYTES) from sys.dba_free_space group by tablespace_name;

That gives free space in bytes rather than blocks, which my poor brain finds easier to comprehend.

Robin Parker. Received on Thu Jan 25 1996 - 00:00:00 CET