Space Management
-- Space usage in a tablespace:
SELECT * FROM dba_tablespace_usage_metrics where tablespace_name='SYSTEM';

-- List the block id's used in a specific tablespace
select * from dba_extents where tablespace_name = 'RBS' order by block_id;

--