pyorastats

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

★ 22 Open GitHub ↗

Oracle system stats with output for collectd and cacti

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 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](http://i61.tinypic.com/35l6ubp.png)

pyorastats

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README