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;
TABLESPACE_SIZE of mgmt$db_datafiles view doesn’t show anything. can you please tell why this happen??
LikeLike
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.
LikeLike