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 ASM Monitoring

Votes:

0

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

oracle-sensors oracle-sql-sensor oraclesql

Created on Apr 14, 2020 11:37:18 AM

Last change on Apr 15, 2020 5:50:23 AM by  Sven Roggenhofer [Paessler Technical Support]



2 Replies

Votes:

0

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

Created on Apr 15, 2020 8:36:32 AM by  Marijan Horsky [Paessler Support]



Votes:

0

Hi Marijan,

I will check it. Thanks

Best Regards, Dan

Created on Apr 17, 2020 6:43:58 AM




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.