Showing results for 
Search instead for 
Did you mean: 

How to get the Buffer Cache Hit Ratio from the Hana database

0 Kudos


We are trying to monitor a SAP Hana database, we would like to measure the buffer cache hit ratio of the database regularly.

Is it possible to calculate this metric with a SQL query or is there a table/view where the metric is directly stored (like in Oracle database with the view SYS.V_$SYSMETRIC_HISTORY) ?

Thank you for your help !

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

No, that’s not possible in any meaningful way.