Re: checking for full tablespaces

From: Ray Dutcher <rdutc_at_sarek.xerox>
Date: 22 Jan 93 19:44:20 GMT
Message-ID: <1993Jan22.194420.1436_at_spectrum.xerox.com>


How about

select fs.TABLESPACE_NAME, (sum(fs.bytes) / sum(df.bytes)) * 100 PctFull,

        count(*), max(fs.BLOCKS) max_contig
from dba_free_space fs, dba_data_files df group by fs.TABLESPACE_NAME
/ Received on Fri Jan 22 1993 - 20:44:20 CET

Original text of this message