Skip to content

Latest commit

 

History

History
49 lines (35 loc) · 1.36 KB

README.md

File metadata and controls

49 lines (35 loc) · 1.36 KB
Raw

pyorastats

Oracle system stats with output for collectd and cacti

With pyorastats you can easy create a dashboard with graphite and grafana

usage: ora_system_stats.py [-h] [-f {cacti,collectd}] {ASM,TBS,PHYSIO,ACTV,CURS,WAITS,ALL} ...

stats arguments:

  • ASM Get stats from ASM disks
  • TBS Get stats from tablespaces
  • PHYSIO Get physical IO stats
  • ACTV Get database activity stats
  • CURS Get database cursors stats
  • WAITS Get database waits stats
  • ALL Get all database stats

optional arguments:
-h, --help show this help message and exit
-f {cacti,collectd}, --format {cacti,collectd} Output format, default collectd

Now if you want send this metrics to graphite need to complete your collectd config with this new 2 sections:

LoadPlugin exec
<Plugin exec>
      Exec collectd "python" "/path/to/ora_system_stats.py" "ALL" "-u" "system" "-p" "passwd" "-s" "SID"
</Plugin>

LoadPlugin write_graphite
<Plugin write_graphite>
  <Node "graphitehost">
    Host "localhost"
    Port "2003"
    Protocol "tcp"
    LogSendErrors true
    Prefix "collectd."
  </Node>
</Plugin>

Screenshot grafana dashboard https://lnxnet.es/oracle-dashboard-with-graphite-collectd-and-pyorastats.html

Alt text