prometheus_oracle_exporter icon indicating copy to clipboard operation
prometheus_oracle_exporter copied to clipboard

Temp tablespace incorrectly reported as autoextend = NO

Open chrisfw opened this issue 4 years ago • 0 comments

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

chrisfw avatar May 18 '20 21:05 chrisfw