New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


Why is my Oracle Tablespace sensor showing negative values?

Votes:

0

Your Vote:

Up

Down

One of my Tablespace sensors is showing negative values. What is causing this and what can I do about it?

oracle-tablespace oracle-tablespace-sensor prtg

Created on Apr 17, 2018 11:30:46 AM by  Brandy Greger [Paessler Support]

Last change on Apr 17, 2018 11:41:31 AM by  Brandy Greger [Paessler Support]



1 Reply

Accepted Answer

Votes:

0

Your Vote:

Up

Down

This article applies to PRTG Network Monitor 19 or later

Oracle Tablespace Sensor and Negative Values

If your Oracle Tablespace sensor is showing negative values and is therefore in a Down status, this could be because the tablespace has been overprovisioned. This means that the actual file size of the tablespace exceeds the defined maximum size of the tablespace, which was defined when it was initially created.

The Oracle Tablespace sensor does not support overprovisioning.

For the sensor to properly monitor a tablespace, the file size on-disk must not exceed the value in DBA_DATA_FILES.MAXBYTES. If the file size on-disk exceeds this value, the sensor reports negative values indicating that the file contains more data than defined in the database metadata.

So, the sensor is working exactly as intended. It is not a issue of PRTG.

Workaround

The only workaround to avoid such errors is to delete the sensors that are monitoring overprovisioned tablespaces. If you cannot delete them or still want to be able to see data for overprovisioned tablespaces without receiving errors for sensors in a Down status, you can simply acknowledge the alarms.

Created on Apr 17, 2018 11:55:35 AM by  Brandy Greger [Paessler Support]

Last change on Jul 24, 2019 12:16:06 PM by  Brandy Greger [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.