billdegithub
commented
3 years ago example: this json module import grafana dashboard
{ "annotations": { "list": [ { "builtIn": 1, "datasource": "Prometheus", "enable": false, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "limit": 100, "name": "Annotations & Alerts", "showIn": 0, "type": "dashboard" } ] }, "description": "使用oracledb-exporter进行oracle数据库监控，相对其他dashboard增加了tablespace的监控，可拓展设置为表空间告警；\n\n", "editable": true, "gnetId": 11121, "graphTooltip": 1, "id": 30, "iteration": 1607564135956, "links": [ { "asDropdown": true, "icon": "external link", "tags": [], "type": "dashboards" } ], "panels": [ { "collapsed": false, "datasource": null, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 67, "panels": [], "title": "数据库", "type": "row" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": true, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 3, "w": 5, "x": 0, "y": 1 }, "height": "125px", "id": 12, "interval": "$interval", "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "postfix": "", "postfixFontSize": "80%", "prefix": "", "prefixFontSize": "80%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "calculatedInterval": "10m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_up{instance=\"$host\",database=\"$db\"}", "format": "time_series", "hide": false, "instant": false, "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 300 } ], "thresholds": "0,1", "title": "数据库状态", "type": "singlestat", "valueFontSize": "100%", "valueMaps": [ { "op": "=", "text": "DEAD", "value": "0" }, { "op": "=", "text": "ALIVE", "value": "1" } ], "valueName": "current" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "Prometheus", "decimals": null, "description": "", "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 3, "w": 6, "x": 5, "y": 1 }, "height": "125px", "id": 52, "interval": "$interval", "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "postfix": "天", "postfixFontSize": "100%", "prefix": "", "prefixFontSize": "80%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "repeat": null, "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "calculatedInterval": "10m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_sysstat{instance=\"$host\",database=\"$db\",type=\"execute_count\"}", "format": "time_series", "hide": true, "instant": true, "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 300 }, { "calculatedInterval": "10m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_uptime{instance=\"$host\",database=\"$db\"}", "format": "time_series", "instant": true, "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "B", "step": 300 } ], "thresholds": "", "title": "运行时间", "type": "singlestat", "valueFontSize": "100%", "valueMaps": [ { "op": "=", "text": "", "value": "" } ], "valueName": "current" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 3, "w": 4, "x": 11, "y": 1 }, "height": "125px", "id": 51, "interval": "$interval", "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "postfix": "", "postfixFontSize": "80%", "prefix": "", "prefixFontSize": "80%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "calculatedInterval": "10m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_sysstat{instance=\"$host\",database=\"$db\",type=\"user_commits\"}", "format": "time_series", "instant": false, "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 300 } ], "thresholds": "90,95", "title": "用户提交数", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [], "valueName": "current" }, { "cacheTimeout": null, "columns": [], "datasource": "Prometheus", "fontSize": "90%", "gridPos": { "h": 19, "w": 9, "x": 15, "y": 1 }, "id": 79, "links": [], "options": {}, "pageSize": null, "repeatDirection": null, "scroll": true, "showHeader": true, "sort": { "col": 7, "desc": true }, "styles": [ { "alias": "Time", "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "hidden" }, { "alias": "类型", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": false, "mappingType": 1, "pattern": "type", "preserveFormat": false, "thresholds": [], "type": "string", "unit": "short", "valueMaps": [ { "text": "已用", "value": "used" }, { "text": "剩余", "value": "free" }, { "text": "总计", "value": "total" } ] }, { "alias": "表空间", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "link": false, "mappingType": 1, "pattern": "name", "sanitize": false, "thresholds": [], "type": "number", "unit": "short", "valueMaps": [] }, { "alias": "表空间类型", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "contents", "thresholds": [ "" ], "type": "string", "unit": "short", "valueMaps": [ { "text": "常驻", "value": "PERMANENT" }, { "text": "重做", "value": "UNDO" }, { "text": "临时", "value": "TEMPORARY" } ] }, { "alias": "空间", "colorMode": null, "colors": [ "rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "Value", "thresholds": [ "" ], "type": "number", "unit": "bytes" }, { "alias": "", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "decimals": 2, "pattern": "/./", "thresholds": [], "type": "hidden", "unit": "short" } ], "targets": [ { "expr": "oracledb_tablespace{instance=\"$host\",database=\"$db\"}", "format": "table", "hide": false, "instant": true, "intervalFactor": 1, "legendFormat": "", "refId": "A" } ], "timeFrom": null, "timeShift": null, "title": "表空间状态", "transform": "table", "type": "table" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": true, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "format": "short", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 5, "w": 5, "x": 0, "y": 4 }, "height": "125px", "id": 13, "interval": "$interval", "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "80%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "calculatedInterval": "10m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_session{instance=\"$host\",state=\"ACTIVE\",database=\"$db\",type=\"USER\"}", "format": "time_series", "instant": false, "interval": "$interval", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 60 } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "活动会话(USER)", "type": "singlestat", "valueFontSize": "100%", "valueMaps": [], "valueName": "current" }, { "cacheTimeout": null, "columns": [], "datasource": null, "fontSize": "100%", "gridPos": { "h": 5, "w": 6, "x": 5, "y": 4 }, "id": 71, "links": [], "options": {}, "pageSize": null, "pluginVersion": "6.2.5", "showHeader": true, "sort": { "col": 0, "desc": true }, "styles": [ { "alias": "状态", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "state", "thresholds": [], "type": "string", "unit": "short" }, { "alias": "类型", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "type", "thresholds": [], "type": "number", "unit": "short" }, { "alias": "连接数", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "Value", "thresholds": [], "type": "number", "unit": "short" }, { "alias": "", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "decimals": 2, "pattern": "/./", "thresholds": [], "type": "hidden", "unit": "short" } ], "targets": [ { "expr": "oracledb_session{instance=\"$host\",database=\"$db\"}", "format": "table", "instant": true, "intervalFactor": 1, "legendFormat": "{{descr}} - 进程计数", "refId": "A" } ], "timeFrom": null, "timeShift": null, "title": "会话计数", "transform": "table", "type": "table" }, { "cacheTimeout": null, "colorBackground": false, "colorPostfix": true, "colorPrefix": true, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": null, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 3, "w": 4, "x": 11, "y": 4 }, "id": 69, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "pluginVersion": "6.2.5", "postfix": "", "postfixFontSize": "70%", "prefix": "", "prefixFontSize": "70%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "expr": "oracledb_sysstat{instance=\"$host\",database=\"$db\",type=\"user_rollbacks\"}", "format": "time_series", "instant": false, "intervalFactor": 1, "legendFormat": "{{descr}} - 用户回滚", "refId": "A" } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "用户回滚", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "current" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "datasource": "Prometheus", "decimals": null, "description": "", "editable": true, "error": false, "format": "none", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 2, "w": 4, "x": 11, "y": 7 }, "height": "125px", "id": 80, "interval": "$interval", "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "postfix": "", "postfixFontSize": "100%", "prefix": "", "prefixFontSize": "80%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": true }, "tableColumn": "", "targets": [ { "calculatedInterval": "10m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_sysstat{instance=\"$host\",database=\"$db\",type=\"execute_count\"}", "format": "time_series", "hide": false, "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 300 } ], "thresholds": "", "title": "执行计数", "type": "singlestat", "valueFontSize": "100%", "valueMaps": [], "valueName": "current" }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 7, "x": 0, "y": 9 }, "hiddenSeries": false, "id": 53, "legend": { "alignAsTable": false, "avg": false, "current": false, "max": false, "min": false, "rightSide": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"concurrency\"}", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - 并发等待时间", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "并发等待时间", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "max": null, "min": 0, "show": true }, { "format": "short", "logBase": 1, "max": null, "min": 0, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 8, "x": 7, "y": 9 }, "hiddenSeries": false, "id": 54, "legend": { "alignAsTable": false, "avg": false, "current": false, "max": false, "min": false, "rightSide": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"commit\"}", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - 提交等待时间", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "提交等待时间", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "max": null, "min": 0, "show": true }, { "format": "short", "logBase": 1, "max": null, "min": 0, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 5, "w": 7, "x": 0, "y": 15 }, "hiddenSeries": false, "id": 59, "legend": { "alignAsTable": false, "avg": false, "current": false, "max": false, "min": false, "rightSide": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"application\"}\t", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - 应用等待", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "应用等待", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "max": null, "min": 0, "show": true }, { "format": "short", "logBase": 1, "max": null, "min": 0, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 5, "w": 8, "x": 7, "y": 15 }, "hiddenSeries": false, "id": 60, "legend": { "alignAsTable": false, "avg": false, "current": false, "max": false, "min": false, "rightSide": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"network\"}\t", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - 网络等待", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "网络等待", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "max": null, "min": 0, "show": true }, { "format": "short", "logBase": 1, "max": null, "min": 0, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 7, "x": 0, "y": 20 }, "hiddenSeries": false, "id": 55, "legend": { "alignAsTable": false, "avg": false, "current": false, "max": false, "min": false, "rightSide": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"system_io\"}", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - 系统I/O等待", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "系统I/O等待", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "max": null, "min": 0, "show": true }, { "format": "short", "logBase": 1, "max": null, "min": 0, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": "Prometheus", "decimals": null, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 8, "x": 7, "y": 20 }, "hiddenSeries": false, "id": 56, "legend": { "alignAsTable": false, "avg": false, "current": false, "max": false, "min": false, "rightSide": false, "show": false, "total": false, "values": false }, "lines": true, "linewidth": 2, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasourceErrors": {}, "errors": {}, "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"user_io\"}\t", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - 用户I/O等待", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "用户I/O等待", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "max": null, "min": 0, "show": true }, { "format": "short", "logBase": 1, "max": null, "min": 0, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": null, "fill": 1, "fillGradient": 0, "gridPos": { "h": 12, "w": 9, "x": 15, "y": 20 }, "hiddenSeries": false, "id": 73, "legend": { "alignAsTable": true, "avg": false, "current": true, "max": false, "min": false, "rightSide": false, "show": true, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "expr": "oracledb_sysmetric{instance=\"$host\",database=\"$db\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "资源利用率 - {{type}} ", "refId": "A" } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "资源利用率", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": null, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 7, "x": 0, "y": 26 }, "hiddenSeries": false, "id": 75, "legend": { "alignAsTable": false, "avg": false, "current": true, "max": false, "min": false, "show": false, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"configuration\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "{{descr}} - 组态等待时间", "refId": "A" } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "组态等待时间", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": null, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 8, "x": 7, "y": 26 }, "hiddenSeries": false, "id": 77, "legend": { "alignAsTable": false, "avg": false, "current": true, "max": false, "min": false, "show": false, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "options": { "dataLinks": [] }, "percentage": false, "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "expr": "oracledb_waitclass{instance=\"$host\",database=\"$db\",type=\"scheduler\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "{{descr}} - Scheduler 等待时间", "refId": "A" } ], "thresholds": [], "timeFrom": null, "timeRegions": [], "timeShift": null, "title": "Scheduler 等待时间", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "buckets": null, "mode": "time", "name": null, "show": true, "values": [] }, "yaxes": [ { "format": "s", "label": null, "logBase": 1, "max": null, "min": null, "show": true }, { "format": "short", "label": null, "logBase": 1, "max": null, "min": null, "show": true } ], "yaxis": { "align": false, "alignLevel": null } }, { "collapsed": false, "datasource": null, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 32 }, "id": 62, "panels": [], "repeat": null, "title": "性能收集器状态", "type": "row" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "Prometheus", "format": "none", "gauge": { "maxValue": 1000, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 4, "w": 3, "x": 0, "y": 33 }, "id": 58, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "pluginVersion": "6.2.5", "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": true }, "tableColumn": "", "targets": [ { "expr": "oracledb_exporter_scrapes_total{instance=\"$host\"}", "format": "time_series", "intervalFactor": 2, "refId": "A", "step": 10 } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "总收集", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "current" }, { "cacheTimeout": null, "colorBackground": false, "colorValue": false, "colors": [ "#299c46", "rgba(237, 129, 40, 0.89)", "#d44a3a" ], "datasource": "Prometheus", "format": "s", "gauge": { "maxValue": 100, "minValue": 0, "show": false, "thresholdLabels": false, "thresholdMarkers": true }, "gridPos": { "h": 4, "w": 3, "x": 3, "y": 33 }, "id": 57, "interval": null, "links": [], "mappingType": 1, "mappingTypes": [ { "name": "value to text", "value": 1 }, { "name": "range to text", "value": 2 } ], "maxDataPoints": 100, "nullPointMode": "connected", "nullText": null, "options": {}, "postfix": "", "postfixFontSize": "50%", "prefix": "", "prefixFontSize": "50%", "rangeMaps": [ { "from": "null", "text": "N/A", "to": "null" } ], "sparkline": { "fillColor": "rgba(31, 118, 189, 0.18)", "full": false, "lineColor": "rgb(31, 120, 193)", "show": false }, "tableColumn": "", "targets": [ { "expr": "oracledb_exporter_last_scrape_duration_seconds{instance=\"$host\"}\t", "format": "time_series", "intervalFactor": 2, "refId": "A", "step": 10 } ], "thresholds": "", "timeFrom": null, "timeShift": null, "title": "最后收集用时", "type": "singlestat", "valueFontSize": "80%", "valueMaps": [ { "op": "=", "text": "N/A", "value": "null" } ], "valueName": "current" } ], "refresh": false, "schemaVersion": 21, "style": "dark", "tags": [ "oracle" ], "templating": { "list": [ { "allFormat": "glob", "allValue": null, "current": { "text": "10.206.0.100:9161", "value": "10.206.0.100:9161" }, "datasource": "Prometheus", "definition": "label_values(oracledb_up, instance)", "hide": 0, "includeAll": false, "label": "", "multi": false, "multiFormat": "regex values", "name": "host", "options": [], "query": "label_values(oracledb_up, instance)", "refresh": 1, "refresh_on_load": false, "regex": "", "skipUrlSync": false, "sort": 1, "tagValuesQuery": null, "tags": [], "tagsQuery": null, "type": "query", "useTags": false }, { "allValue": null, "current": { "text": "10.207.0.105", "value": "10.207.0.105" }, "datasource": "Prometheus", "definition": "label_values(oracledb_up,database)", "hide": 0, "includeAll": false, "label": null, "multi": false, "name": "db", "options": [], "query": "label_values(oracledb_up,database)", "refresh": 2, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false }, { "allFormat": "glob", "auto": true, "auto_count": 200, "auto_min": "1s", "current": { "selected": false, "text": "1m", "value": "1m" }, "datasource": "Prometheus", "hide": 0, "includeAll": false, "label": "Interval", "multi": false, "multiFormat": "glob", "name": "interval", "options": [ { "selected": false, "text": "auto", "value": "$__auto_interval_interval" }, { "selected": false, "text": "1s", "value": "1s" }, { "selected": false, "text": "5s", "value": "5s" }, { "selected": true, "text": "1m", "value": "1m" }, { "selected": false, "text": "5m", "value": "5m" }, { "selected": false, "text": "1h", "value": "1h" }, { "selected": false, "text": "6h", "value": "6h" }, { "selected": false, "text": "1d", "value": "1d" } ], "query": "1s,5s,1m,5m,1h,6h,1d", "refresh": 2, "skipUrlSync": false, "type": "interval" } ] }, "time": { "from": "now-30m", "to": "now" }, "timepicker": { "collapse": false, "enable": true, "notice": false, "now": true, "refresh_intervals": [ "5s", "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d" ], "status": "Stable", "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ], "type": "timepicker" }, "timezone": "browser", "title": "Oracledb监控-性能与表空间", "uid": "1ee82mJWk", "version": 30 }
Which dashboard is used in the grafana.com warehous？