Oracle Database Discussions

In OEM Grid 11g, we can get the Databasewise Current Disk Group Usage (GB) in percentage in a Pie Chart.

I am looking for similar. What tables need to be querieed?

Requirement is for given ASM Diskgroup name, the output should provide the DBName, Usage of the DB in the DiskGroup.

I tried and find other queries like,

 
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

select * from V$RECOVERY_FILE_DEST

Edited by: Sivaprasad S on May 2, 2012 8:23 AM