select mc.target_name ,t.host_name,mc.collection_timestamp,mc.key_value schema,mc.key_value2 table_name,to_number(mc.value) size_mb
from MGMT$METRIC_CURRENT mc
    join sysman.mgmt_targets t on t.target_guid=mc.target_guid
where metric_label='table_top_allocations'
and column_label='size_mb' 
order by to_number(mc.value) desc;