Dears,

I'm newby here and sorry for maybe simple questions. I would like to add to PRTG new sensor which should show me usage of Oracle ASM. In oracle sqlplus I use this query:

select 
g.name as gn,
round((sum(d.total_mb)-sum(d.free_mb))/sum(d.total_mb)*100,2) as used
from v$asm_disk d, v$asm_diskgroup g
where d.group_number=g.group_number(+) and d.header_status = 'MEMBER' 
group by g.name;

The query returns name of disk group and usage, for example: GN USED DATA 50 DATAALFA 75

Number of returned rows can be differenet.

I suppose that I should you Oracle SQL v2 Sensors. How to configure such sensor in PRTG which will show me the name of disk group and usage?

Thanks,

Best Regards, Daniel

Article Comments

Hi,

Maybe the following Oracle Tablespace Sensor will give you the opportunity to monitor the desired information.
You can find more information about this sensor here.

Otherwise you can also create the Oracle SQL v2 Sensor and you can find more information about this sensor here.

Kind regards,
Marijan Horsky, Team Technical Support


Apr, 2020 - Permalink

Hi Marijan,

I will check it. Thanks

Best Regards, Dan


Apr, 2020 - Permalink