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 ?
Article Comments
Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.
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
May, 2022 - Permalink
Hey,
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';
Jun, 2022 - Permalink
Hi,
Do you want to monitor the Temp Tablespace with the Oracle SQL v2 Sensor?
May, 2022 - Permalink