— ts_usage
— summary of how each none sys/tmp/rbs ts is being used
spool ts_usage.lst
col tablespace_name form a10 head ts_name
col owner form a12
col segment_type form a15
select tablespace_name, owner, segment_type, count(*)
from dba_segments
where tablespace_name not like ‘SYS%’ and tablespace_name not like ‘RBS%’ and tablespace_name not like ‘TEMP%’
group by tablespace_name,owner,segment_type
order by tablespace_name,owner,segment_type
/
spool off
clear col