Created
March 7, 2026 17:23
-
-
Save cesardba/cd26b10846ae9c12612f5961db501f40 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "__inputs": [ | |
| { | |
| "name": "Prometheus", | |
| "label": "prometheus", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "prometheus", | |
| "pluginName": "Prometheus" | |
| } | |
| ], | |
| "__requires": [ | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "4.5.1" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "graph", | |
| "name": "Graph", | |
| "version": "" | |
| }, | |
| { | |
| "type": "datasource", | |
| "id": "prometheus", | |
| "name": "Prometheus", | |
| "version": "1.0.0" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "singlestat", | |
| "name": "Singlestat", | |
| "version": "" | |
| } | |
| ], | |
| "annotations": { | |
| "list": [ | |
| { | |
| "builtIn": 1, | |
| "datasource": { | |
| "type": "grafana", | |
| "uid": "-- Grafana --" | |
| }, | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "rgba(0, 211, 255, 1)", | |
| "name": "Annotations & Alerts", | |
| "type": "dashboard" | |
| } | |
| ] | |
| }, | |
| "editable": true, | |
| "fiscalYearStartMonth": 0, | |
| "graphTooltip": 0, | |
| "id": 5, | |
| "links": [], | |
| "liveNow": false, | |
| "panels": [ | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 3, | |
| "panels": [], | |
| "title": "Oracle AI Database Details", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [ | |
| { | |
| "options": { | |
| "0": { | |
| "index": 1, | |
| "text": "DEAD" | |
| }, | |
| "1": { | |
| "index": 0, | |
| "text": "ALIVE" | |
| } | |
| }, | |
| "type": "value" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 4, | |
| "x": 0, | |
| "y": 1 | |
| }, | |
| "id": 10, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "oracledb_up{database=\"$database\"}", | |
| "format": "table", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": true, | |
| "legendFormat": "__auto", | |
| "range": false, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "Database Status", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "decbytes" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 3, | |
| "x": 4, | |
| "y": 1 | |
| }, | |
| "id": 5, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "builder", | |
| "exemplar": false, | |
| "expr": "oracledb_db_system_value{name=\"sga_max_size\", database=\"$database\"}", | |
| "format": "table", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": true, | |
| "legendFormat": "__auto", | |
| "range": false, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "SGA Max Size", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "decbytes" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 3, | |
| "x": 7, | |
| "y": 1 | |
| }, | |
| "id": 6, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "builder", | |
| "exemplar": false, | |
| "expr": "oracledb_db_system_value{name=\"pga_aggregate_limit\", database=\"$database\"}", | |
| "format": "table", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": true, | |
| "legendFormat": "__auto", | |
| "range": false, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "PGA Aggregate Limit", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 5, | |
| "x": 10, | |
| "y": 1 | |
| }, | |
| "id": 11, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "builder", | |
| "expr": "oracledb_sessions_value{status=\"ACTIVE\", database=\"$database\"}", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "legendFormat": "{{type}}", | |
| "range": true, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "Active Sessions", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 3, | |
| "x": 15, | |
| "y": 1 | |
| }, | |
| "id": 12, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "builder", | |
| "expr": "oracledb_activity_user_commits{database=\"$database\"}", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "legendFormat": "__auto", | |
| "range": true, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "User commits", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "none" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 6, | |
| "w": 3, | |
| "x": 18, | |
| "y": 1 | |
| }, | |
| "id": 13, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "builder", | |
| "expr": "oracledb_activity_execute_count{database=\"$database\"}", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "legendFormat": "__auto", | |
| "range": true, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "Execute count", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": { | |
| "align": "auto", | |
| "cellOptions": { | |
| "type": "auto" | |
| }, | |
| "inspect": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 3, | |
| "x": 21, | |
| "y": 1 | |
| }, | |
| "id": 7, | |
| "options": { | |
| "cellHeight": "sm", | |
| "footer": { | |
| "countRows": false, | |
| "fields": "", | |
| "reducer": [ | |
| "sum" | |
| ], | |
| "show": false | |
| }, | |
| "showHeader": false | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "builder", | |
| "exemplar": false, | |
| "expr": "max by(platform_name) (oracledb_db_platform_value{database=\"$database\"})", | |
| "format": "table", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": true, | |
| "legendFormat": "{{platform_name}}", | |
| "range": false, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "Database Platform", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Time": true, | |
| "Value": true | |
| }, | |
| "indexByName": {}, | |
| "renameByName": {} | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [ | |
| { | |
| "options": { | |
| "0": { | |
| "index": 0, | |
| "text": "NON-MT" | |
| }, | |
| "1": { | |
| "index": 1, | |
| "text": "CDB" | |
| } | |
| }, | |
| "type": "value" | |
| }, | |
| { | |
| "options": { | |
| "from": 2, | |
| "result": { | |
| "index": 2, | |
| "text": "PDB" | |
| }, | |
| "to": 99999 | |
| }, | |
| "type": "range" | |
| } | |
| ], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 4, | |
| "x": 0, | |
| "y": 4 | |
| }, | |
| "id": 20, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "10.1.1", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "oracledb_dbtype{database=\"$database\"}", | |
| "format": "table", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": true, | |
| "legendFormat": "__auto", | |
| "range": false, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "Database Type", | |
| "type": "stat" | |
| }, | |
| { | |
| "datasource": "Prometheus", | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 3, | |
| "w": 3, | |
| "x": 21, | |
| "y": 4 | |
| }, | |
| "id": 2, | |
| "options": { | |
| "colorMode": "value", | |
| "graphMode": "area", | |
| "justifyMode": "auto", | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "textMode": "auto" | |
| }, | |
| "pluginVersion": "9.5.2", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "builder", | |
| "exemplar": false, | |
| "expr": "oracledb_db_system_value{name=\"cpu_count\", database=\"$database\"}", | |
| "format": "table", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": true, | |
| "legendFormat": "__auto", | |
| "range": false, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "CPU Count", | |
| "type": "stat" | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 7 | |
| }, | |
| "id": 4, | |
| "panels": [], | |
| "title": "System Wait Classes", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "palette-classic" | |
| }, | |
| "custom": { | |
| "axisCenteredZero": false, | |
| "axisColorMode": "text", | |
| "axisLabel": "", | |
| "axisPlacement": "auto", | |
| "barAlignment": 0, | |
| "drawStyle": "line", | |
| "fillOpacity": 72, | |
| "gradientMode": "none", | |
| "hideFrom": { | |
| "legend": false, | |
| "tooltip": false, | |
| "viz": false | |
| }, | |
| "insertNulls": false, | |
| "lineInterpolation": "linear", | |
| "lineWidth": 1, | |
| "pointSize": 5, | |
| "scaleDistribution": { | |
| "type": "linear" | |
| }, | |
| "showPoints": "auto", | |
| "spanNulls": true, | |
| "stacking": { | |
| "group": "A", | |
| "mode": "normal" | |
| }, | |
| "thresholdsStyle": { | |
| "mode": "off" | |
| } | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| }, | |
| "unit": "s" | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 10, | |
| "w": 24, | |
| "x": 0, | |
| "y": 8 | |
| }, | |
| "id": 21, | |
| "options": { | |
| "legend": { | |
| "calcs": [], | |
| "displayMode": "list", | |
| "placement": "bottom", | |
| "showLegend": true | |
| }, | |
| "tooltip": { | |
| "mode": "single", | |
| "sort": "none" | |
| } | |
| }, | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_administrative{database=\"$database\"}[$__rate_interval])", | |
| "format": "time_series", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": false, | |
| "legendFormat": "Administrative", | |
| "range": true, | |
| "refId": "A", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_application{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Application", | |
| "range": true, | |
| "refId": "B", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_cluster{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Cluster", | |
| "range": true, | |
| "refId": "C", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_commit{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Commit", | |
| "range": true, | |
| "refId": "D", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_concurrency{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Concurrency", | |
| "range": true, | |
| "refId": "E", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_configuration{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Configuration", | |
| "range": true, | |
| "refId": "F", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_network{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Network", | |
| "range": true, | |
| "refId": "G", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_other{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Other", | |
| "range": true, | |
| "refId": "H", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_scheduler{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "Scheduler", | |
| "range": true, | |
| "refId": "I", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_user_io{database=\"$database\"}[$__rate_interval])", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "User I/O", | |
| "range": true, | |
| "refId": "J", | |
| "useBackend": false | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "rate(oracledb_wait_time_system_io{database=\"$database\"}[$__rate_interval])", | |
| "format": "time_series", | |
| "fullMetaSearch": false, | |
| "hide": false, | |
| "includeNullMetadata": false, | |
| "instant": false, | |
| "legendFormat": "System I/O", | |
| "range": true, | |
| "refId": "K", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "Database Wait Times", | |
| "transformations": [ | |
| { | |
| "id": "renameByRegex", | |
| "options": { | |
| "regex": "oracledb_wait_time_(.*).*", | |
| "renamePattern": "$1" | |
| } | |
| } | |
| ], | |
| "type": "timeseries" | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 18 | |
| }, | |
| "id": 22, | |
| "panels": [], | |
| "title": "Cache Statistics", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "dark-red", | |
| "value": null | |
| }, | |
| { | |
| "color": "#EAB839", | |
| "value": 50 | |
| }, | |
| { | |
| "color": "green", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [] | |
| }, | |
| "gridPos": { | |
| "h": 8, | |
| "w": 24, | |
| "x": 0, | |
| "y": 19 | |
| }, | |
| "id": 23, | |
| "options": { | |
| "orientation": "auto", | |
| "reduceOptions": { | |
| "calcs": [ | |
| "lastNotNull" | |
| ], | |
| "fields": "", | |
| "values": false | |
| }, | |
| "showThresholdLabels": false, | |
| "showThresholdMarkers": true | |
| }, | |
| "pluginVersion": "10.1.1", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "disableTextWrap": false, | |
| "editorMode": "code", | |
| "expr": "oracledb_cache_hit_ratio_value{database=\"$database\"}", | |
| "fullMetaSearch": false, | |
| "includeNullMetadata": true, | |
| "instant": false, | |
| "legendFormat": "{{cache_hit_type}}", | |
| "range": true, | |
| "refId": "A", | |
| "useBackend": false | |
| } | |
| ], | |
| "title": "Cache Hit Ratios", | |
| "transformations": [ | |
| { | |
| "id": "renameByRegex", | |
| "options": { | |
| "regex": "(.*)", | |
| "renamePattern": "$1" | |
| } | |
| } | |
| ], | |
| "type": "gauge" | |
| }, | |
| { | |
| "collapsed": false, | |
| "gridPos": { | |
| "h": 1, | |
| "w": 24, | |
| "x": 0, | |
| "y": 27 | |
| }, | |
| "id": 8, | |
| "panels": [], | |
| "title": "Top SQL", | |
| "type": "row" | |
| }, | |
| { | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "Prometheus" | |
| }, | |
| "description": "", | |
| "fieldConfig": { | |
| "defaults": { | |
| "color": { | |
| "mode": "thresholds" | |
| }, | |
| "custom": { | |
| "align": "auto", | |
| "cellOptions": { | |
| "type": "auto" | |
| }, | |
| "inspect": false | |
| }, | |
| "mappings": [], | |
| "thresholds": { | |
| "mode": "absolute", | |
| "steps": [ | |
| { | |
| "color": "green", | |
| "value": null | |
| }, | |
| { | |
| "color": "red", | |
| "value": 80 | |
| } | |
| ] | |
| } | |
| }, | |
| "overrides": [ | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "SQL ID" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "custom.width", | |
| "value": 226 | |
| } | |
| ] | |
| }, | |
| { | |
| "matcher": { | |
| "id": "byName", | |
| "options": "SQL Text (extract)" | |
| }, | |
| "properties": [ | |
| { | |
| "id": "custom.width", | |
| "value": 1311 | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "gridPos": { | |
| "h": 9, | |
| "w": 24, | |
| "x": 0, | |
| "y": 28 | |
| }, | |
| "id": 9, | |
| "options": { | |
| "cellHeight": "sm", | |
| "footer": { | |
| "countRows": false, | |
| "fields": "", | |
| "reducer": [ | |
| "sum" | |
| ], | |
| "show": false | |
| }, | |
| "showHeader": true, | |
| "sortBy": [] | |
| }, | |
| "pluginVersion": "10.1.1", | |
| "targets": [ | |
| { | |
| "datasource": { | |
| "type": "prometheus" | |
| }, | |
| "editorMode": "code", | |
| "exemplar": false, | |
| "expr": "max(oracledb_top_sql_elapsed{database=\"$database\"}) by (sql_id, sql_text)", | |
| "format": "table", | |
| "instant": true, | |
| "legendFormat": "__auto", | |
| "range": false, | |
| "refId": "A" | |
| } | |
| ], | |
| "title": "Top SQL by elapsed time running", | |
| "transformations": [ | |
| { | |
| "id": "organize", | |
| "options": { | |
| "excludeByName": { | |
| "Time": true | |
| }, | |
| "indexByName": {}, | |
| "renameByName": { | |
| "Value": "Elapsed Time", | |
| "sql_id": "SQL ID", | |
| "sql_text": "SQL Text (extract)" | |
| } | |
| } | |
| }, | |
| { | |
| "id": "sortBy", | |
| "options": { | |
| "fields": {}, | |
| "sort": [ | |
| { | |
| "desc": true, | |
| "field": "Elapsed Time" | |
| } | |
| ] | |
| } | |
| } | |
| ], | |
| "type": "table" | |
| } | |
| ], | |
| "refresh": "5s", | |
| "schemaVersion": 38, | |
| "style": "dark", | |
| "tags": [], | |
| "templating": { | |
| "list": [ | |
| { | |
| "auto": true, | |
| "auto_count": 200, | |
| "auto_min": "10s", | |
| "current": { | |
| "selected": false, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| "hide": 0, | |
| "label": "Interval", | |
| "name": "interval", | |
| "options": [ | |
| { | |
| "selected": true, | |
| "text": "auto", | |
| "value": "$__auto_interval_interval" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1m", | |
| "value": "1m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10m", | |
| "value": "10m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30m", | |
| "value": "30m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1h", | |
| "value": "1h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "6h", | |
| "value": "6h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "12h", | |
| "value": "12h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1d", | |
| "value": "1d" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "7d", | |
| "value": "7d" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "14d", | |
| "value": "14d" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30d", | |
| "value": "30d" | |
| } | |
| ], | |
| "query": "1m,10m,30m,1h,6h,12h,1d,7d,14d,30d", | |
| "refresh": 2, | |
| "skipUrlSync": false, | |
| "type": "interval" | |
| }, | |
| { | |
| "current": { | |
| "selected": true, | |
| "text": "default", | |
| "value": "default" | |
| }, | |
| "datasource": { | |
| "type": "prometheus", | |
| "uid": "Prometheus" | |
| }, | |
| "definition": "label_values(database)", | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "database", | |
| "multi": false, | |
| "name": "database", | |
| "options": [], | |
| "query": { | |
| "query": "label_values(database)", | |
| "refId": "PrometheusVariableQueryEditor-VariableQuery" | |
| }, | |
| "refresh": 1, | |
| "regex": "", | |
| "skipUrlSync": false, | |
| "sort": 0, | |
| "type": "query" | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now-30m", | |
| "to": "now" | |
| }, | |
| "timepicker": {}, | |
| "timezone": "", | |
| "title": "Oracle Dashboard", | |
| "uid": "oracle_dashboard", | |
| "version": 3, | |
| "weekStart": "" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment