Create Custom Reports in GC 11g

Hi,

I am new to this community, but do have some years of dba experience. However, GridControl always causes me headaches :-)

This time I am trying to create a custom report for some trending of various elements, amongst them the Buffer Cache Hit Ratio.

Assume I want to list the above ratio for the last 24 hours, i use this statement:

SELECT  target_name as Name,

           d.collection_timestamp,

           value

           FROM

           mgmt$metric_details d

           WHERE

           -- M.TARGET_GUID=HEXTORAW(??EMIP_BIND_TARGET_GUID??) AND

           (D.TARGET_NAME LIKE '%my_target_name1%')   AND

               d.metric_column in ('bufcachehit_pct')