OEM Queries

Hi Team,

We are preparing the queries for OEM Equivalent Oracle, Please can you help on the below query write in OEM.

SELECT instance.instance_name || '.' || database.name as db_instance, REPLACE(LOWER(metric.metric_name),' ','_') as monitor, round(metric.value,2) as oracle_db_buffer_cache from v$database database, gv$instance instance, gv$metric metric where metric.con_id = 0 and metric.group_id = 2 and (metric.metric_name = 'Buffer Cache Hit Ratio') and instance.inst_id=metric.inst_id

And also provide equivalent views for OEM FOR below views.

gv$metric 

v$sysstat

gv$resource_limit