There is no Data for a Particular Target Database in the "MGMT$DB_SGA_ALL" view.

We have 300+ database targets in OEM but we noticed couple of database targets doesnt have data under the view "MGMT$DB_SGA_ALL".

Please see below output. We removed the target and re-added but still its the same.

from mgmt$db_sga_all ==>

SQL> select host_name,TARGET_NAME,TARGET_TYPE ,TARGET_GUID from sysman.mgmt$db_sga_all where target_name='ORCL' and SGANAME='Total SGA (MB)';

no rows selected

SQL> select host_name,TARGET_NAME,TARGET_TYPE ,TARGET_GUID from sysman.mgmt$db_sga_all where target_name='ORCL1' and SGANAME='Total SGA (MB)';

no rows selected