Is it possible to generate a Cache Hit Ratio Report for Oracle agents? (4300530)

Does foglight DBO have the capability to generate a report with a detailed chart on cache hit ratio max, min and average values (numerical) for a selected time frame?

There is no in-built template to generate this type of report. However, the values are available within the Configuration | Data dashboard. Follow the steps below in order to locate this data:

1. Navigate to Configuration | Data Dashboard
2. Select Databases | Oracle | Oracle instances | <DB_name> | IO Activity
3. Scroll down to select Cache Hit Ratio

Please note: Anything beyond this point will require Quest Professional Services (PSO) engagement in order to use these values to generate a custom report.