Mackerel Plugin Oracle

mackerel-plugin-oracle

Oracle custom metrics plugin for mackerel.io agent.

Synopsis

mackerel-plugin-oracle -dsn= -event= -event ...

`-dsn` is database source name. `-event` is Oracle WaitEvent name.

Example of mackerel-agent.conf

[plugin.metrics.oracle]
command = [
	"/path/to/mackerel-plugin-oracle",
	"-event=Disk File Operations I/O",
	"-event=control file sequential read",
	"-event=OS Thread Startup",
	"-dsn=scott/tiger@XE"
]

mackerel-agent is executed by root user. And root user probably doesn't have Oracle setup like environment variables. If your OS use yum/rpm, add following like to load `oracle_env.sh` into `/etc/sysconfig/mackerel-agent`.

. /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

This is an example of the case using Oracle XE 11.2.

If your OS use apt/deb, the path should be `/etc/default/mackerel-agent`.

Reference

You can find event name

SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;

See also: