The checkpoint buf_cache_hit_ratio contains a mistake in the syntax and therefore it is failing to run and to retrieve data.
Wrong query
SELECT a.value as db_block_gets_from_cache,b.value as consistent_gets_from_cache,c.value as physical_reads_from_cacheFROM v$sysstat a, v$sysstat b, v$sysstat cWHERE a.name = 'db block gets from cache'AND b.name = 'consistent gets from cache' AND c.name = 'physical reads cache'
The working query is :
SELECT a.value as db_block_gets_from_cache,b.value as consistent_gets_from_cache,c.value as physical_reads_from_cache FROM v$sysstat a, v$sysstat b, v$sysstat c WHERE a.name = 'db block gets from cache' AND b.name = 'consistent gets from cache' AND c.name = 'physical reads cache'
the query is missing spaces.
With probe version 5.41 and Oracle 11.x issue does not occurr as query is correct.
Defect in the probe
UIM 9.x/20.x.x
Oracle probe V5.45
Oracle DB 19C
oracle_5.45_T1.zip resolves this issue