[QUESTION] Integration other metrics

[lnxbil]

Hi Bertrand,

great tool and great metrics on your website.

Are you planning to migrate/adopt your other metric schemes into this or another telegraf plugin? Most of the work snapshotting and comparing previous could be done by influxdb, so maybe one just need to run the corresponding selects and pipe them into influxdb.

Best, Andreas

[bdrouvot]

Hello Andreas,

That's a good idea! I may have a look at it later on.

Thanks Bertrand

[lnxbil]

Hi Bertrand,

I just implemented an Oracle Perl-based metric program this week, so that it can be used directly on any Oracle database server without any external dependencies. It uses os authentication and needs an oracle sid. I think this is for others the most simple version possible and will probably run on every platform due to the sole use of Oracle Perl. I use simple JSON output and it is then parsed by telegraf and it works so far. At the moment, I'm playing around with the sysstat, asm_diskio (like in your ASM metric program) and resource limits views to get some metric examples to play around with. I am going to investigate the statspack a little to get other ideas for metrics. The asm metrics are also directly accessible through the database instance, so it is sufficient to just metric every Oracle instance (and only the v$ instead of gv$ in a RAC environment) for every host combination and combine them with a frontend like Grafana.

[lnxbil]

Just found our, you're actually doing the same in your perl program. I only looked at the ASM select stuff.