need help with a metric from oracle

[ebe...@kobo.com]

Hi,

I am pulling oracle metris using prometheus oracle exporter. This exporter is output'ing ta blespace info as below. Now when i try to calculate the something using these metrics, i am not getting any results.

promql query: 

oracledb_tablespace{name="DATA",type="used"} / oracledb_tablespace{name="DATA",type="total"}

result: no data

if modify the query as little as below i am getting the result, can someone tell me why?

(((scalar(oracledb_tablespace{name="SYSTEM",type="used"}) / scalar(oracledb_tablespace{name="SYSTEM",type="total"})) * 100 ) > bool(75)) 

result:

ElementValue
scalar.     0

thanks

Eswar