重庆思庄技术分享——prometheus中oracle监控的toml配置文件讲解

prometheus中oracle监控的toml配置文件讲解1. 主备库角色与 Open 状态监控# [[metric]]context db_role_statusrequest select decode(database_role, PRIMARY, 1, PHYSICAL STANDBY, 2, SNAPSHOT STANDBY, 3, 0) as role_code, decode(open_mode, READ WRITE, 1, READ ONLY WITH APPLY, 2, READ ONLY, 3, MOUNTED, 4, 0) as open_code from v$databasemetricsdesc { role_code Database