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; -- |