Promhub Logo Prom hub

Oracledb_Dashboard_202210
1,104

Created 10/7/2022
Updated 10/15/2022
Revision 1
Categories
Databases
Grafana Version >=8.4.0
Datasources
Prometheus

监控图作者：蒋勇

监控oracle的exporter：https://github.com/iamseth/oracledb_exporter

替换default-metrics.toml用的文件：https://github.com/saitiger008/oracledb_exporter_metrics

如果GitHub不好打开，备选：

https://gitee.com/mirrors_iamseth/oracledb_exporter_1 https://gitee.com/laosai/oracledb_exporter_metrics

注意：

a）监控不同版本的数据库，需要装不同版本的客户端，我目前测试的大版本一致就行，我现在采集服务器装了11g、12c、18c的；可能12c也能兼容18c，没测试。

b）数据库监控账户，我使用的是自带的dbsnmp，这个账户实际上有dba的权限；实际上权限取决于default-metrics.toml文件中的指标采集sql需要的权限。

c）监控账户密码不能带%，带的话会报错；

d）CDB\PDB容器数据库未测试，目前我监控的都是传统数据库；

e）有问题请反馈至https://github.com/saitiger008/oracledb_exporter_metrics

Get Dashboard✕
Download
Copy to Clipboard
Dashboard screenshot 1
Source Grafana.com

Used Metrics 40

  • oracledb_env_version

  • oracledb_env_is_rac

  • oracledb_env_value

  • oracledb_env_running_time

  • oracledb_env_vols

  • oracledb_up

  • oracledb_dataguard_exist_value

  • oracledb_dataguard_status_value

  • oracledb_rman_status_value

  • oracledb_sessions_value

  • oracledb_parameter_sessions_value

  • oracledb_sysmetric_logons_per_sec

  • oracledb_sysmetric_user_transaction_per_sec

  • oracledb_sysmetric_buffer_cache_hit_ratio

  • oracledb_sysmetric_library_cache_hit_ratio

  • oracledb_sysmetric_row_cache_hit_ratio

  • oracledb_sysmetric_pga_cache_hit_

  • oracledb_sysmetric_memory_sorts_ratio

  • oracledb_sysmetric_redo_allocation_hit_ratio

  • interval

  • oracledb_db_recovery_file_dest_value

  • oracledb_db_recovery_file_dest_percent_space_used

  • oracledb_events_value

  • oracledb_sysmetric_database_time_per_sec

  • oracledb_sysmetric_logical_reads_per_sec

  • oracledb_sysmetric_physical_read_total_io_requests_per_sec

  • oracledb_sysmetric_physical_write_total_io_requests_per_sec

  • oracledb_sysmetric_redo_writes_per_sec

  • oracledb_sysstat_bytes_received_via_sqlnet_from_client

  • oracledb_sysstat_bytes_sent_via_sqlnet_to_client

  • oracledb_sysmetric_physical_read_total_bytes_per_sec

  • oracledb_sysmetric_physical_write_total_bytes_per_sec

  • oracledb_sysmetric_redo_generated_per_sec

  • oracledb_env_redo_value

  • oracledb_env_redo_switch_value

  • oracledb_tablespace_bytes

  • oracledb_tablespace_free

  • oracledb_tablespace_max_bytes

  • oracledb_parameter_value

  • oracledb_rman_info_value