Re: checking for full tablespaces

In article <19930122.061744.917_at_almaden.ibm.com>, alanb_at_vnet.ibm.com (Alan Beal) writes:
|> 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

How about
select * from sys.dba_free_space
where tablespace_name='WHATEVER'
order by file_id,block_id
/

-- 

 Leila Schneberger                 leilas_at_ems.cdc.com