Re: free space in oracle 7
From: Judy Ko -- Consultant <judy_at_gftpd-mail.citicorp.com>
Date: 11 Feb 1994 21:39:35 GMT
Message-ID: <2jgtun$ias_at_charon.citicorp.com>
Date: 11 Feb 1994 21:39:35 GMT
Message-ID: <2jgtun$ias_at_charon.citicorp.com>
> select tablespace_name, sum( bytes ) / 1e6 free_mb
> from dba_free_space
> group by tablespace_name
This query works for oracle 7. I have tired it on the HP platform.
> Also, what manuals describe such sys admin stuff as what system tables
> are available?
App B of Server Administrator's Guide will give you the detail of all
tables/views and columns. I find the SQL Language Quick Reference is
helpful too.
Judy Ko