You can use the Management Server console to view the Oracle databases that consume storage from Oracle ASM disk group. The information includes the name of the database, its version, state, type, Oracle instance status (online or offline), storage sizes (total, free, used), and other attributes.
To view Oracle databases consuming storage from Oracle ASM disk groups
In the Management Server console, select Manage > Databases.
In the Databases view, click the Oracle database to view its details.
In the database details view, click the ASM tab.
In the ASM table, click the required ASM instance.
Under the Databases tab, you can view information about all the databases that consume storage from any of the ASM disk groups in the Oracle ASM instance.