Oracledb监控-性能与表空间
3,636 4.0 (1 reviews)

Created 11/7/2019
Updated 11/7/2019
Revision 1
Categories
Databases
Grafana Version >=6.2.5
Datasources
Prometheus

使用oracledb-exporter进行oracle数据库监控,相对其他dashboard增加了tablespace的监控,可拓展设置为表空间告警;

docker部署oracledb-exporter: docker pull iamseth/oracledb_exporter docker run -d --name oracledb_exporter
--restart=always -p 9161:9161 -e DATA_SOURCE_NAME=[db_user]/[db_passwd]@[db_ip]:[db_port]/[SID]
iamseth/oracledb_exporter

Get Dashboard
Download
Copy to Clipboard
Source Grafana.com

Used Metrics 17

  • oracledb_up

  • oracledb_activity_execute_count

  • oracledb_activity_user_commits

  • oracledb_tablespace_free

  • oracledb_tablespace_max_bytes

  • oracledb_sessions_value

  • oracledb_process_count

  • oracledb_activity_user_rollbacks

  • oracledb_wait_time_concurrency

  • oracledb_wait_time_commit

  • oracledb_wait_time_application

  • oracledb_wait_time_network

  • oracledb_wait_time_system_io

  • oracledb_wait_time_user_io

  • oracledb_resource_current_utilization

  • oracledb_wait_time_configuration

  • oracledb_wait_time_scheduler