Votes:
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 ?
3 Replies
Votes:
Hi,
Do you want to monitor the Temp Tablespace with the Oracle SQL v2 Sensor?
Created on May 30, 2022 9:52:14 AM by
Votes:
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';
Created on Jun 2, 2022 7:14:20 AM by
Add comment