Oracle probe V5.41 buf_cache_hit_ratio contains a mistake in the syntax

book

Article ID: 211232

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

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. 

Cause

Defect in the probe

Environment

UIM 9.x/20.x.x


Oracle probe V5.45
Oracle DB 19C

Resolution

oracle_5.45_T1.zip resolves this issue