prometheus_oracle_exporter
prometheus_oracle_exporter copied to clipboard
Temp tablespace incorrectly reported as autoextend = NO
Hi,
When I run the exporter against an Oracle instance, the metric displays as oracledb_tablespace{autoextend="NO",contents="TEMPORARY",database="redacted",dbinstance="redacted",name="TEMP",type="free"} 2.5764560896e+10 oracledb_tablespace{autoextend="NO",contents="TEMPORARY",database="redacted",dbinstance="redacted",name="TEMP",type="total"} 2.5769803776e+10 oracledb_tablespace{autoextend="NO",contents="TEMPORARY",database="redacted",dbinstance="redacted",name="TEMP",type="used"} 5.24288e+06 However, running the corresponding query below directly against the DB reveals that it is autoextensible. I confirmed that the db connection utilized by both the exporter and SQL Developer point to the same db.
select file_name, tablespace_name, autoextensible from dba_temp_files
"FILE_NAME","TABLESPACE_NAME","AUTOEXTENSIBLE" "/u04/oradata/redacted/temp01.dbf","TEMP","YES"
Any assistance you can provide in resolving this issue would be greatly appreciated.
Thanks, Chris Whelan