What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags

View all Tags

Oracle DB Monitoring - Missing Tablespace



I want to monitor our primary oracle server with prtg I have used the "system" account as logon If i want to add a tablespace sensor i can see all of the tablespaces except the "TEMP" Tablespace ... but this is the most important for monitoring .

What could be the reason for this failure ?

oracle tablespace temp

Created on May 26, 2022 10:01:13 AM

3 Replies



Do you want to monitor the Temp Tablespace with the Oracle SQL v2 Sensor?

Created on May 30, 2022 9:52:14 AM by  Marijan Horsky [Paessler Support]



yes .. and it works for all the Tablespaces of the database except !! the temp tablespace , but the temp tablespace is one of the most important .

if i configure the sensor .. i use the "system" account for logon to the oracel database and the next window shows all of the table spaces into the database. But the "temp" Tablespace is missing.

I need someone who has more knowledge about oracle rights and the connection to PRTG

Created on May 30, 2022 9:58:49 AM



I would ask you to query the following code against your oracle DB. Do you see the temp tablespace here? SELECT MAX( CASE WHEN t.online_status = 'ONLINE' THEN 0 WHEN t.online_status = 'SYSTEM' THEN 1 WHEN t.online_status = 'RECOVER' THEN 2 WHEN t.online_status = 'SYSOFF' THEN 3 WHEN t.online_status = 'OFFLINE' THEN 4 ELSE 100 END) online_status, MAX( CASE WHEN t.status = 'AVAILABLE' THEN 0 WHEN t.status = 'INVALID' THEN 1 ELSE 100 END ) status, SUM(t.maxbytes) - SUM(t.bytes) FREE, TRUNC(100 * (SUM(t.maxbytes) - SUM(t.bytes)) / SUM(t.maxbytes), 12) free_perc, SUM(t.maxblocks) - SUM(t.blocks) blocks_free, TRUNC(100 * (SUM(t.maxblocks) - SUM(t.blocks)) / SUM(t.maxblocks), 12) blocks_free_perc, SUM(t.bytes) used, SUM(t.disk_bytes) disk_used FROM (SELECT a.tablespace_name, a.file_name, a.online_status, a.status, CASE WHEN a.AUTOEXTENSIBLE = 'NO' THEN a.BYTES ELSE a.MAXBYTES END maxbytes, (SELECT a.BYTES - NVL(SUM(b.BYTES), 0) FROM dba_free_space b WHERE b.FILE_ID = a.FILE_ID ) bytes, a.BYTES disk_bytes, CASE WHEN a.AUTOEXTENSIBLE = 'NO' THEN a.BLOCKS ELSE a.MAXBLOCKS END maxblocks, (SELECT a.BLOCKS - NVL(SUM(b.BLOCKS), 0) FROM dba_free_space b WHERE b.FILE_ID = a.FILE_ID ) blocks FROM dba_data_files a ) t WHERE t.tablespace_name = 'SYSTEM';

Created on Jun 2, 2022 7:14:20 AM by  Marijan Horsky [Paessler Support]

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.