Re: checking for full tablespaces
From: Ruth Larson <rlarson_at_nswc-wo.nswc.navy.mil>
Date: 22 Jan 93 19:44:27 GMT
Message-ID: <1993Jan22.194427.7252_at_relay.nswc.navy.mil>
Date: 22 Jan 93 19:44:27 GMT
Message-ID: <1993Jan22.194427.7252_at_relay.nswc.navy.mil>
>Is there a simple query one may run to see if a tablespace is
>full or almost full? I am using Oracle V6 on AIX 3.2.
>Alan Beal alanb_at_owgvm0.vnet.ibm.com
> (607)751-2026
select sum(blocks),count(blocks), sum(bytes),tablespace_name
from system.dba_free_space
group by tablespace_name
This will give you the free space for all tablespaces. The count(blocks) will give you some idea of how fragmented it is. Received on Fri Jan 22 1993 - 20:44:27 CET