So I was testing out the Oracle tablespace sensor and it created sensors for my tablespaces without any issues. The only problem I can see is the individual sensors don't seem to be reporting their values correctly. For example I have a tablespace flagged as Down - free space below the error limit of 5% so when I look at it I see these results in PRTG:
|Free Blocks %||is empty|
|Free Space||3096 MByte|
|Free Space %||is empty|
Using a SQL query I see these values for the same tablespace:
Total Tablespace size 3096 MBytes Total Used space 0 Mbytes % Used 0%
So I'm curious as to why it would report down with less than 5% remaining when in fact the tablespace is empty and has 100% remaining. In looking at the data PRTG is showing 4 tablespaces as having less than 5% remaining but those 4 are fine on space. The only common issue I see is that the 4 tablespaces are not set to autoextend but have distinctly allocated sizes. For those 4 tablespaces the Free Blocks % and Free Space % fields are empty (not calculated).