1、安装和配置oralcedb_exporter
1.1 使用docker安装oralcedb_exporter
这里以容器的方式提供oracledb_exporter,所使用的镜像为iamseth/oracledb_exporter,以守护进程方式运行此容器。对外暴露9161端口,通过DATA_SOURCE_NAME环境变量指定要监控的oracle数据库。
$ docker run -d –name oracle -p 1521:1521 wnameless/oracle-xe-11g:16.04
$ docker run -d –name oracledb_exporter –link=oracle -p 9161:9161 -e DATA_SOURCE_NAME=system/oracle@oracle/xe iamseth/oracledb_exporter
1.2 查看oracle的指标数据
oracledb_exporter_last_scrape_duration_seconds
oracledb_exporter_last_scrape_error
oracledb_exporter_scrapes_total
oracledb_up
oracledb_activity_execute_count
oracledb_activity_parse_count_total
oracledb_activity_user_commits
oracledb_activity_user_rollbacks
oracledb_sessions_activity
oracledb_wait_time_application:
oracledb_wait_time_commit
oracledb_wait_tim