How to Get All Oracle Databases Size From OEM Repository

Database manager asks you as a DBA about all the database size in the supported environment .

On 13.1 OMS repository:

SQL> select host_name,target_name, sum( FILE_SIZE/1024/1024/1024)
     from mgmt$db_datafiles 
     group by host_name,target_name 
     order by host_name, target_name;

HOST_NAME                                TARGET_NAME                              SUM(FILE_SIZE/1024/1024/1024)
---------------------------------------- ---------------------------------------- -----------------------------
HOST1                                    DB1                                                    38.65
HOST2                                    DB2                                                    385.88
HOST3                                    DB3                                                    27.52
...
..
.

OR we can use another another view mgmt$db_tablespaces :

SQL> select host_name,target_name,sum( TABLESPACE_SIZE/1024/1024/1024) 
     from mgmt$db_tablespaces 
     group by host_name,target_name 
     order by 1,2;
Advertisement

2 thoughts on “How to Get All Oracle Databases Size From OEM Repository”

    1. Hi Sadi,
      Thanks for reaching dbalifeeasy.com.
      You are right. I checked our 13.4 OMS repository, and found FILE_SIZE is zero.

      If i remember correctly, the blog was written against 13.1 OMS repository.

      Thanks again.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: