New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

300.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


Oracle ASM Monitoring

Votes:

0

Your Vote:

Up

Down

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 by  dsilwon (0) 1

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



2 Replies

Votes:

0

Your Vote:

Up

Down

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

Your Vote:

Up

Down

Hi Marijan,

I will check it. Thanks

Best Regards, Dan

Created on Apr 17, 2020 6:43:58 AM by  dsilwon (0) 1



Please log in or register to enter your reply.


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.