para ver esos datos
vista --> dba_tablespaces
qiery sql
SELECT TABLESPACE_NAME,BYTES,MAXBYTES FROM DBA_TABLESPACES
Evidentemente hay consultas mucho mas refinadas que te dan toda la informacion , Una seria esta
set echo off feedb off timi off pau off pages 60 lines 500 trimsp on
spool /tmp/chk_spc_${ORACLE_SID}.lst
col tablespace_name format a15 heading "Tablespaces|over 99% Full"
col total_space format 999,990.00 heading "Current|Total|Space (Mb)"
col free_space format 999,990.00 heading "Current|Free|Space (Mb)"
col pct_free format 990.00 heading "Current|% Free"
col addl_space format 999,990.00 heading "Total Space|after|AutoExtend"
col addl_free_space format 999,990.00 heading "Total Free|Space after|AutoExtend"
select t.tablespace_name,
s.total_space,
f.free_space,
(f.free_space / s.total_space) * 100 pct_free,
s.extensible addl_space,
f.free_space + (s.extensible - s.total_space) addl_free_space
from dba_tablespaces t,
(select tablespace_name,
sum(user_bytes) / 1048576 total_space,
sum(decode(autoextensible, 'YES', maxbytes, user_bytes)) / 1048576 extensible
from dba_data_files
group by tablespace_name) s,
(select tablespace_name,
sum(bytes) / 1048576 free_space
from dba_free_space
group by tablespace_name) f
where t.contents = 'PERMANENT'
and s.tablespace_name = t.tablespace_name
and f.tablespace_name = t.tablespace_name
and (f.free_space / s.total_space) * 100 <= 1