pull report on container and pluggable database size
Enterprise Manager 13.3.0.0 pulling data for Oracle 19c Database Enterprise Edition
Need to gather database size for container and pluggable database. Is there a sql query or a report in OEM to get this information for multiple databases?
This query returns 0 for size_GB
select target_name DB_NAME,host_name Host,
sum(trunc(tablespace_used_size/1024/1024/1024,2)) size_GB
from sysman.MGMT$DB_TABLESPACES
where target_name like 'c2y%'
group by
host_name,target_name;
Thanks