Re: newbie question

In article <7ih2q2$sfr$1_at_nnrp1.deja.com>,   barry_deevey_at_my-dejanews.com wrote:
> Hi,
>
> I am running Oracle 7.3.4, and would like to find out if there is a
> query that would allow me to find out how much space is actually being
> used in both tablespaces and datafiles.
>
> Any replies will be greatly appreciated.
>
> Best Regards,
>
> Barry.
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>

select tablespace_name,
count(*) "pieces", max(blocks) "maximum", sum(blocks)  "total" from sys.dba_free_space group by tablespace_name;

tells you how much free space you have in a tablespace

not sure how to find free space in a datafile, but it must be available as the enterprise manager gui shows it

regards

nigel groves

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 26 1999 - 11:28:31 CDT