Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

pull report on container and pluggable database size

edited February 2021 in Managing Databases using Enterprise Manager (MOSC) 1 commentAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center