Open manotoshroy opened 1 year ago
Hi, The link is right here: https://grafana.com/grafana/dashboards/3333-oracledb/
But I don't use this dashboard and the exporter have changed a lot. Maybe we need to update it in some way.
Contribution on this subject are welcome.
I am using the dashboard and had to fix some queries. Can you put the dashboard json into the repository to contribute fixes?
Hi, Sorry for not replying sooner. Here is the JSON I am using now.
{ "annotations": { "list": [ { "builtIn": 1, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "enable": false, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "limit": 100, "name": "Annotations & Alerts", "showIn": 0, "type": "dashboard" } ] }, "description": "Use oracledb exporter for oracle database monitoring. Compared with other dashboards, tablespace monitoring is added, which can be expanded to set tablespace alarms", "editable": true, "fiscalYearStartMonth": 0, "gnetId": 13555, "graphTooltip": 1, "id": 18, "links": [ { "asDropdown": true, "icon": "external link", "tags": [], "type": "dashboards" } ], "liveNow": false, "panels": [ { "collapsed": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 0 }, "id": 67, "panels": [], "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "refId": "A" } ], "title": "Database", "type": "row" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "0": { "text": "DEAD" }, "1": { "text": "ALIVE" } }, "type": "value" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "rgba(245, 54, 54, 0.9)", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 0 }, { "color": "rgba(50, 172, 45, 0.97)", "value": 1 } ] }, "unit": "none" }, "overrides": [] }, "gridPos": { "h": 3, "w": 5, "x": 0, "y": 1 }, "id": 12, "interval": "$interval", "links": [], "maxDataPoints": 100, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "calculatedInterval": "10m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "editorMode": "code", "errors": {}, "expr": "oracledb_up{instance=\"$host\"}", "format": "time_series", "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "range": true, "refId": "A", "step": 300 } ], "title": "Database status", "type": "stat" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "rgb(31, 120, 193)", "mode": "fixed" }, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "none" }, "overrides": [] }, "gridPos": { "h": 3, "w": 6, "x": 5, "y": 1 }, "id": 71, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "oracledb_process_count{instance=\"$host\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "{{descr}} - Process count", "refId": "A" } ], "title": "Process count", "type": "stat" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "rgb(31, 120, 193)", "mode": "fixed" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "rgba(50, 172, 45, 0.97)", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 90 }, { "color": "rgba(245, 54, 54, 0.9)", "value": 95 } ] }, "unit": "none" }, "overrides": [] }, "gridPos": { "h": 3, "w": 4, "x": 11, "y": 1 }, "id": 51, "interval": "$interval", "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "calculatedInterval": "10m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_activity_user_commits{instance=\"$host\"}", "format": "time_series", "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 300 } ], "title": "User commits", "type": "stat" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "custom": { "align": "auto", "displayMode": "basic", "filterable": false, "inspect": false }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "green", "value": 0 }, { "color": "#EAB839", "value": 80 }, { "color": "red", "value": 90 } ] }, "unit": "percent" }, "overrides": [ { "matcher": { "id": "byName", "options": "tablespace" }, "properties": [ { "id": "color", "value": { "mode": "fixed" } }, { "id": "custom.displayMode", "value": "color-text" }, { "id": "displayName" } ] }, { "matcher": { "id": "byName", "options": "Value (lastNotNull)" }, "properties": [ { "id": "displayName", "value": "Usage" } ] } ] }, "gridPos": { "h": 12, "w": 9, "x": 15, "y": 1 }, "id": 79, "links": [], "options": { "footer": { "fields": "", "reducer": [ "sum" ], "show": false }, "frameIndex": 13, "showHeader": true, "sortBy": [ { "desc": true, "displayName": "Usage" } ] }, "pluginVersion": "9.3.1", "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "editorMode": "code", "expr": "100(1-oracledb_tablespace_free{instance=\"$host\"}/oracledb_tablespace_bytes{instance=\"$host\"})", "interval": "", "legendFormat": "", "range": true, "refId": "A" } ], "title": "Tablespace status", "transformations": [ { "id": "labelsToFields", "options": {} }, { "id": "merge", "options": {} }, { "id": "groupBy", "options": { "fields": { "Time": { "aggregations": [ "lastNotNull" ] }, "Value": { "aggregations": [ "lastNotNull" ], "operation": "aggregate" }, "instance": { "aggregations": [] }, "job": { "aggregations": [] }, "tablespace": { "aggregations": [], "operation": "groupby" }, "type": { "aggregations": [] } } } }, { "id": "organize", "options": { "excludeByName": {}, "indexByName": {}, "renameByName": { "Value (lastNotNull)": "" } } } ], "type": "table" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "short" }, "overrides": [] }, "gridPos": { "h": 3, "w": 5, "x": 0, "y": 4 }, "id": 13, "interval": "$interval", "links": [], "maxDataPoints": 100, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "calculatedInterval": "10m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_sessions_value{instance=\"$host\",status=\"ACTIVE\",type=\"USER\"}", "format": "time_series", "instant": false, "interval": "$interval", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 60 } ], "title": "Active sessions (USER)", "type": "stat" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "none" }, "overrides": [] }, "gridPos": { "h": 3, "w": 6, "x": 5, "y": 4 }, "id": 52, "interval": "$interval", "links": [], "maxDataPoints": 100, "options": { "colorMode": "value", "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "calculatedInterval": "10m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_activity_execute_count{instance=\"$host\"}", "format": "time_series", "interval": "5m", "intervalFactor": 1, "legendFormat": "", "metric": "", "refId": "A", "step": 300 } ], "title": "Execute count", "type": "stat" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "rgb(31, 120, 193)", "mode": "fixed" }, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "red", "value": 80 } ] }, "unit": "none" }, "overrides": [] }, "gridPos": { "h": 3, "w": 4, "x": 11, "y": 4 }, "id": 69, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "oracledb_activity_user_rollbacks{instance=\"$host\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "{{descr}} - User rollback", "refId": "A" } ], "title": "User rollback", "type": "stat" }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 7, "x": 0, "y": 7 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_wait_time_concurrency{instance=\"$host\"}", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - Concurrent wait time", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeRegions": [], "title": "Concurrent wait time", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "min": 0, "show": true }, { "format": "short", "logBase": 1, "min": 0, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 8, "x": 7, "y": 7 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_wait_time_commit{instance=\"$host\"}", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - Commit wait time", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeRegions": [], "title": "Commit wait time", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "min": 0, "show": true }, { "format": "short", "logBase": 1, "min": 0, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "unit": "percent" }, "overrides": [ { "matcher": { "id": "byName", "options": "tablespace" }, "properties": [ { "id": "displayName" } ] }, { "matcher": { "id": "byName", "options": "Value (lastNotNull)" }, "properties": [ { "id": "displayName", "value": "Usage" } ] } ] }, "fill": 0, "fillGradient": 0, "gridPos": { "h": 8, "w": 24, "x": 0, "y": 13 }, "hiddenSeries": false, "id": 81, "legend": { "alignAsTable": true, "avg": true, "current": false, "max": true, "min": true, "rightSide": true, "show": true, "sort": "current", "sortDesc": false, "total": false, "values": true }, "lines": true, "linewidth": 1, "links": [], "nullPointMode": "null", "options": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "100(1-oracledb_tablespace_free{instance=\"$host\"}/oracledb_tablespace_bytes{instance=\"$host\"})", "hide": false, "interval": "", "legendFormat": "", "refId": "F" } ], "thresholds": [], "timeRegions": [], "title": "Tablespace usage over time", "tooltip": { "shared": false, "sort": 2, "value_type": "individual" }, "transformations": [ { "id": "labelsToFields", "options": { "valueLabel": "tablespace" } }, { "id": "merge", "options": {} } ], "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "$$hashKey": "object:126", "format": "percent", "logBase": 1, "show": true }, { "$$hashKey": "object:127", "format": "short", "logBase": 1, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 5, "w": 7, "x": 0, "y": 21 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_wait_time_application{instance=\"$host\"}\t", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - Application wait time", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeRegions": [], "title": "Application wait time", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "min": 0, "show": true }, { "format": "short", "logBase": 1, "min": 0, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 5, "w": 8, "x": 7, "y": 21 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_wait_time_network{instance=\"$host\"}\t", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - Network wait time", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeRegions": [], "title": "Network wait time", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "min": 0, "show": true }, { "format": "short", "logBase": 1, "min": 0, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 8, "w": 9, "x": 15, "y": 21 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "oracledb_resource_current_utilization{instance=\"$host\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "Resource utilization - {{resource_name}} ", "refId": "A" } ], "thresholds": [], "timeRegions": [], "title": "Resource utilization", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "short", "logBase": 1, "show": true }, { "format": "short", "logBase": 1, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 7, "x": 0, "y": 26 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_wait_time_system_io{instance=\"$host\"}", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - System I/O wait", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeRegions": [], "title": "System I/O wait", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "min": 0, "show": true }, { "format": "short", "logBase": 1, "min": 0, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "editable": true, "error": false, "fill": 2, "fillGradient": 0, "grid": {}, "gridPos": { "h": 6, "w": 8, "x": 7, "y": 26 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 5, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "calculatedInterval": "2m", "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "datasourceErrors": {}, "errors": {}, "expr": "oracledb_wait_time_user_io{instance=\"$host\"}\t", "format": "time_series", "interval": "$interval", "intervalFactor": 1, "legendFormat": "{{descr}} - User I/O wait", "metric": "", "refId": "A", "step": 60 } ], "thresholds": [], "timeRegions": [], "title": "User I/O wait", "tooltip": { "msResolution": false, "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "min": 0, "show": true }, { "format": "short", "logBase": 1, "min": 0, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 7, "x": 0, "y": 32 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "oracledb_wait_time_configuration{instance=\"$host\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "{{descr}} - Configure wait time", "refId": "A" } ], "thresholds": [], "timeRegions": [], "title": "Configure wait time", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "show": true }, { "format": "short", "logBase": 1, "show": true } ], "yaxis": { "align": false } }, { "aliasColors": {}, "bars": false, "dashLength": 10, "dashes": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fill": 1, "fillGradient": 0, "gridPos": { "h": 6, "w": 8, "x": 7, "y": 32 }, "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": { "alertThreshold": true }, "percentage": false, "pluginVersion": "9.3.1", "pointradius": 2, "points": false, "renderer": "flot", "seriesOverrides": [], "spaceLength": 10, "stack": false, "steppedLine": false, "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "oracledb_wait_time_scheduler{instance=\"$host\"}", "format": "time_series", "intervalFactor": 1, "legendFormat": "{{descr}} - Scheduler wait time", "refId": "A" } ], "thresholds": [], "timeRegions": [], "title": "Scheduler wait time", "tooltip": { "shared": true, "sort": 0, "value_type": "individual" }, "type": "graph", "xaxis": { "mode": "time", "show": true, "values": [] }, "yaxes": [ { "format": "s", "logBase": 1, "show": true }, { "format": "short", "logBase": 1, "show": true } ], "yaxis": { "align": false } }, { "collapsed": false, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "gridPos": { "h": 1, "w": 24, "x": 0, "y": 38 }, "id": 62, "panels": [], "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "refId": "A" } ], "title": "Performance collector status", "type": "row" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "fixedColor": "rgb(31, 120, 193)", "mode": "fixed" }, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "none" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 0, "y": 39 }, "id": 58, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "area", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "oracledb_exporter_scrapes_total{instance=\"$host\"}", "format": "time_series", "intervalFactor": 2, "refId": "A", "step": 10 } ], "title": "Total collection", "type": "stat" }, { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "fieldConfig": { "defaults": { "color": { "mode": "thresholds" }, "mappings": [ { "options": { "match": "null", "result": { "text": "N/A" } }, "type": "special" } ], "thresholds": { "mode": "absolute", "steps": [ { "color": "green" }, { "color": "red", "value": 80 } ] }, "unit": "s" }, "overrides": [] }, "gridPos": { "h": 4, "w": 3, "x": 3, "y": 39 }, "id": 57, "links": [], "maxDataPoints": 100, "options": { "colorMode": "none", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "lastNotNull" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "9.3.1", "targets": [ { "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "expr": "oracledb_exporter_last_scrape_duration_seconds{instance=\"$host\"}\t", "format": "time_series", "intervalFactor": 2, "refId": "A", "step": 10 } ], "title": "Final collection time", "type": "stat" } ], "refresh": "", "schemaVersion": 37, "style": "dark", "tags": [], "templating": { "list": [ { "allFormat": "glob", "current": { "selected": true, "text": "localhost:9161", "value": "localhost:9161" }, "datasource": { "type": "prometheus", "uid": "4ipBeg54z" }, "definition": "", "hide": 0, "includeAll": false, "label": "", "multi": false, "multiFormat": "regex values", "name": "host", "options": [], "query": { "query": "label_values(oracledb_up, instance)", "refId": "Prometheus-host-Variable-Query" }, "refresh": 1, "refresh_on_load": false, "regex": "", "skipUrlSync": false, "sort": 1, "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", "queryValue": "", "refresh": 2, "skipUrlSync": false, "type": "interval" } ] }, "time": { "from": "now-6h", "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 Monitoring - performance and table space stats", "uid": "6f1a26360", "version": 3, "weekStart": "" }
On Wed, Jun 21, 2023 at 12:22 PM Oskars @.***> wrote:
I am using the dashboard and had to fix some queries. Can you put the dashboard json into the repository to contribute fixes?
— Reply to this email directly, view it on GitHub https://github.com/iamseth/oracledb_exporter/issues/269#issuecomment-1600280318, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF7LV4UJLRP24LCPG55OJDDXMKK4BANCNFSM6AAAAAAUANSWPM . You are receiving this because you authored the thread.Message ID: @.***>
Thank you. Would you mind puting it into version control so that in the future it is available next to compatible exporter version?
Which repo are you referring to? In my personal repo and keep it open?
On Tue, Jul 11, 2023 at 7:59 PM Oskars @.***> wrote:
Thank you. Would you mind puting it into version control so that in the future it is available next to compatible exporter version?
— Reply to this email directly, view it on GitHub https://github.com/iamseth/oracledb_exporter/issues/269#issuecomment-1630938095, or unsubscribe https://github.com/notifications/unsubscribe-auth/AF7LV4TNSX6LFCP6ZZ45DEDXPVPLDANCNFSM6AAAAAAUANSWPM . You are receiving this because you authored the thread.Message ID: @.***>
Imho it would be nice to keep it in this exporter repo. Matbe in some docs folder.
The sample dashboard link (An example Grafana dashboard is available here(https://grafana.com/dashboards/3333) is broken in Readme.md files.