{"id":43169,"date":"2023-05-14T20:15:14","date_gmt":"2023-10-23T08:06:55","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/"},"modified":"2024-04-30T04:09:23","modified_gmt":"2024-04-29T20:09:23","slug":"%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/","title":{"rendered":"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues"},"content":{"rendered":"

\u9996\u5148<\/h1>\n

\u5728Oracle Database 23c(21c)\u4e2d\uff0c\u6709\u4e24\u4e2a\u514d\u8d39\u53ef\u7528\u7684\u529f\u80fd\uff0c\u4e00\u4e2a\u662f\u529f\u80fd\u5f3a\u5927\u7684\u6d88\u606f\u961f\u5217\u7cfb\u7edfAdvanced Queuing(AQ)\uff0c\u53e6\u4e00\u4e2a\u662f\u53ef\u4ee5\u5b9e\u73b0\u9ad8\u541e\u5410\u91cf\u6d88\u606f\u4ea4\u6362\u7684Transactional Event Queues(TxEventQ)\u3002\u672c\u6b21\u6211\u4eec\u60f3\u8981\u6784\u5efa\u4e00\u4e2a\u7528\u4e8e\u76d1\u63a7\u6027\u80fd\u7684TxEventQ Monitor\u7cfb\u7edf\u6765\u4f7f\u7528\u8fd9\u4e9b\u529f\u80fd\u3002\u6709\u5173TxEventQ\u7684\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u53c2\u8003\u6b64\u5904\u7684\u6587\u6863\u6216\u4ee5\u4e0b\u7684Qiita\u6587\u7ae0\u3002<\/p>\n

 <\/p>\n

\u7ec4\u4ef6\u5305\u62ec\u4ee5\u4e0b\u4e09\u4e2a\u90e8\u5206\u3002<\/p>\n

Oracle Database Observability Exporter: Oracle Database\u7528\u306ePrometheus\u30a8\u30af\u30b9\u30dd\u30fc\u30bf\u3002\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057\u3001\u30e1\u30c8\u30ea\u30c3\u30af\u3092\u554f\u3044\u5408\u305b\u3066\u3001\u30e1\u30c8\u30ea\u30c3\u30af\u3092Prometheus\u69d8\u5f0f\u306e\u30e1\u30c8\u30ea\u30c3\u30af\u306b\u66f8\u5f0f\u5316\u3057\u307e\u3059\u3002<\/p>\n

Prometheus: \u76e3\u8996\u30b7\u30b9\u30c6\u30e0\u304a\u3088\u3073\u6642\u7cfb\u5217\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3002Oracle DB\u30a8\u30af\u30b9\u30dd\u30fc\u30bf\u304b\u3089\u53ce\u96c6\u3057\u305f\u30e1\u30c8\u30ea\u30c3\u30af\u3092\u6642\u7cfb\u5217\u5f62\u5f0f\u3067\u7ba1\u7406\u3057\u307e\u3059\u3002<\/p>\n

Grafana: \u5206\u6790\u304a\u3088\u3073\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u306a\u8996\u899a\u5316\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3002\u30c7\u30fc\u30bf\u30fb\u30bd\u30fc\u30b9\u3068\u3057\u3066Prometheus\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002<\/p>\n

\u6587\u4ef6\u5728\u8fd9\u91cc\u3002<\/p>\n

\"image.png\"<\/div>\n

\u73af\u5883\u4fe1\u606f<\/h1>\n

\u6784\u5efa\u76d1\u89c6\u6846\u67b6\u7684\u865a\u62df\u673a\u4fe1\u606f<\/p>\n

    \n
  • \n
      \u30b7\u30a7\u30a4\u30d7: VM.Standard.E4.Flex<\/ul>\n<\/li>\n<\/ul>\n

       <\/p>\n

        \n
      • \n
          \u30a4\u30e1\u30fc\u30b8: Oracle Linux 8.8<\/ul>\n<\/li>\n<\/ul>\n

           <\/p>\n

            \n
          • \n
              Docker: 24.0.7<\/ul>\n<\/li>\n<\/ul>\n

               <\/p>\n

                Docker Compose: 2.21.0<\/ul>\n

                \u88ab\u76d1\u89c6\u7684Oracle\u6570\u636e\u5e93<\/p>\n

                  Oracle Database 23.3(OCI\u306eBaseDB)<\/ul>\n

                  \u521b\u5efa\u76d1\u89c6\u7528\u6570\u636e\u5e93\u7528\u6237<\/h1>\n

                  \u8fd9\u6b21\u6211\u4eec\u5728OCI\u4e0a\u521b\u5efa\u4e86\u4e00\u4e2a23c(23.3)\u7684BaseDB\uff0c\u5e76\u5728\u5176\u4e0a\u9762\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3apdb23c\u7684PDB\u3002\u6211\u4eec\u5c06\u5176\u4f5c\u4e3a\u76d1\u89c6\u5bf9\u8c61\u7684PDB\uff0c\u5e76\u5728\u5176\u4e2d\u521b\u5efa\u4e86\u4e00\u4e2a\u540d\u4e3amonitor\u7684\u6570\u636e\u5e93\u7528\u6237\u7528\u4e8e\u76d1\u89c6\u3002<\/p>\n

                    \n
                  1. \n
                      \u4f7f\u7528SYS\u521b\u5efa\u7528\u6237<\/ol>\n<\/li>\n<\/ol>\n

                       <\/p>\n

                        \n
                      1. \n
                          \u901a\u8fc7\u6388\u4e88SELECT_CATALOG_ROLE\u89d2\u8272\uff0c\u60a8\u53ef\u4ee5\u83b7\u5f97\u5728Prometheus\u4e2d\u6536\u96c6\u5ea6\u91cf\u7684\u76ee\u5f55\u7b49\u53c2\u8003\u6743\u9650\u3002<\/ol>\n<\/li>\n<\/ol>\n

                           <\/p>\n

                            \n
                          1. \n
                              create user monitor identified by Welcome12345#;<\/ol>\n<\/li>\n<\/ol>\n

                               <\/p>\n

                                \n
                              1. \n
                                  grant connect, resource, DBA, SELECT_CATALOG_ROLE, unlimited tablespace to monitor;<\/ol>\n<\/li>\n<\/ol>\n

                                  \u6388\u4e88TxEventQ\u76f8\u5173\u89d2\u8272
                                  \ngrant execute on dbms_aq to monitor;
                                  \ngrant execute on dbms_aqadm to monitor;
                                  \ngrant execute on dbms_aqin to monitor;
                                  \ngrant execute on dbms_aqjms_internal to monitor;
                                  \ngrant execute on dbms_teqk to monitor;
                                  \ngrant execute on DBMS_RESOURCE_MANAGER to monitor;
                                  \ngrant select on sys.aq$_queue_shards to monitor;
                                  \ngrant select on user_queue_partition_assignment_table to monitor;<\/p>\n

                                  \u4ece\u865a\u62df\u673a\u4f7f\u7528SQL*Plus\u8fde\u63a5\u5230pdb23c\u8fdb\u884c\u76d1\u6d4b(\u7b80\u6613\u8fde\u63a5)
                                  \nsqlplus monitor\/Welcome12345#@xxxx:1521\/pdb23c.xxxx.vcn1.oraclevcn.com<\/p>\n

                                  SQL*Plus: Release 21.0.0.0.0 – Production on Tue Nov 14 06:26:35 2023
                                  \nVersion 21.9.0.0.0<\/p>\n

                                  Copyright (c) 1982, 2022, Oracle. All rights reserved.<\/p>\n

                                  \u4e0a\u6b21\u6210\u529f\u767b\u5f55\u65f6\u95f4: Tue Nov 14 2023 06:26:23 +00:00<\/p>\n

                                  \u5df2\u8fde\u63a5\u5230:
                                  \nOracle Database 23c Enterprise Edition Release 23.0.0.0.0 – Production
                                  \nVersion 23.3.0.23.09<\/p>\n

                                  Oracle\u6570\u636e\u5e93\u53ef\u89c2\u5bdf\u6027\u5bfc\u51fa\u5668\u7684\u8bbe\u7f6e\u3002<\/h1>\n

                                  Oracle\u6570\u636e\u5e93\u53ef\u89c2\u6d4b\u6027\u5bfc\u51fa\u7a0b\u5e8f\u53ef\u4f7f\u7528\u53ef\u4eceOracle\u5bb9\u5668\u6ce8\u518c\u8868\u4e0b\u8f7d\u7684\u5bb9\u5668\u6620\u50cf\u5728\u672c\u5730\u5bb9\u5668\u4e2d\u4f7f\u7528\u3002\u4e0d\u9700\u8981\u8fdb\u884c\u8eab\u4efd\u9a8c\u8bc1\u6216\u8bb8\u53ef\u8bc1\u660e\/\u6279\u51c6\u3002<\/p>\n

                                  \u987a\u4fbf\u8bf4\u4e00\u4e0b\uff0c\u8fd9\u4e2aOracle\u5bb9\u5668\u6ce8\u518c\u8868\u4e2d\u8fd8\u5305\u542b\u4e86Autonomous Database\u7684\u514d\u8d39\u6620\u50cf\u4ee5\u53ca\u9002\u7528\u4e8e\u5fae\u670d\u52a1\u7684Oracle\u4ea4\u6613\u7ba1\u7406\u5668\uff08MicroTx\uff09\u7684\u6620\u50cf\u3002<\/p>\n

                                    \n
                                  1. \n
                                      \u521b\u5efa\u4f5c\u4e1a\u76ee\u5f55<\/ol>\n<\/li>\n<\/ol>\n

                                       <\/p>\n

                                        \n
                                      1. \n
                                          mkdir -p monitoring\/exporter<\/ol>\n<\/li>\n<\/ol>\n

                                           <\/p>\n

                                            \n
                                          1. \n
                                              cd monitoring\/exporter<\/ol>\n<\/li>\n<\/ol>\n

                                              \u521b\u5efa\u81ea\u5b9a\u4e49\u6307\u6807\u914d\u7f6e\u6587\u4ef6txeventq-metrics.toml
                                              \n\u8fd9\u6b21\u9664\u4e86\u9ed8\u8ba4\u7684\u6307\u6807\u4e4b\u5916\uff0c\u6211\u4eec\u8fd8\u60f3\u6536\u96c6TxEventQ\u7684\u6307\u6807\uff0c\u6240\u4ee5\u6211\u4eec\u9700\u8981\u521b\u5efa\u4e00\u4e2atoml\u6587\u4ef6\uff0c\u5e76\u4f7f\u7528\u8be5\u6587\u4ef6\u6765\u521b\u5efaDocker\u955c\u50cf\u3002<\/p>\n

                                              txeventq-metrics.toml
                                              \n[[metric]]
                                              \ncontext = “ownership”
                                              \nmetricsdesc = { inst_id = “\u5f53\u524d\u961f\u5217\u7684\u6240\u6709\u8005\u5b9e\u4f8bID\u3002” }
                                              \nrequest = ”’
                                              \nSELECT
                                              \ninst_id
                                              \nFROM
                                              \ngv$persistent_queues
                                              \nWHERE
                                              \nROWNUM < 2
                                              \n”’
                                              \n[[metric]]
                                              \ncontext = “teq”
                                              \nmetricsdesc = { curr_inst_id = “\u5f53\u524d\u5b9e\u4f8b\u7684ID” }
                                              \nrequest = “SELECT instance_number AS curr_inst_id FROM v$instance”<\/p>\n

                                              [[metric]]
                                              \ncontext = “teq”
                                              \nlabels = [“inst_id”]
                                              \nmetricsdesc = { total_queues = “\u961f\u5217\u7684\u603b\u6570” }
                                              \nrequest = ”’
                                              \nSELECT
                                              \ninst_id,
                                              \nCOUNT(*) AS total_queues
                                              \nFROM
                                              \n(
                                              \nSELECT DISTINCT
                                              \nt1.inst_id,
                                              \nt2.queue_name
                                              \nFROM
                                              \ngv$aq_sharded_subscriber_stat t1
                                              \nJOIN gv$persistent_queues t2 ON t1.queue_id = t2.queue_id
                                              \n)
                                              \nGROUP BY
                                              \ninst_id
                                              \n”’<\/p>\n

                                              [[metric]]
                                              \ncontext = “teq”
                                              \nlabels = [“inst_id”]
                                              \nmetricsdesc = { total_subscribers = “\u8ba2\u9605\u8005\u7684\u603b\u6570” }
                                              \nrequest = ”’
                                              \nSELECT
                                              \ninst_id,
                                              \nCOUNT(*) AS total_subscribers
                                              \nFROM
                                              \n(
                                              \nSELECT DISTINCT
                                              \ninst_id,
                                              \nsubscriber_id
                                              \nFROM
                                              \ngv$aq_sharded_subscriber_stat
                                              \n)
                                              \nGROUP BY
                                              \ninst_id
                                              \n”’<\/p>\n

                                              [[metric]]
                                              \ncontext = “teq”
                                              \nlabels = [“inst_id”, “queue_name”, “subscriber_name”]
                                              \nmetricsdesc = { enqueued_msgs = “\u5165\u961f\u6d88\u606f\u7684\u603b\u6570\u3002”, dequeued_msgs = “\u51fa\u961f\u6d88\u606f\u7684\u603b\u6570\u3002”, remained_msgs = “\u5269\u4f59\u6d88\u606f\u7684\u603b\u6570\u3002”, time_since_last_dequeue = “\u81ea\u4e0a\u6b21\u51fa\u961f\u4ee5\u6765\u7684\u65f6\u95f4\u3002”, estd_time_to_drain_no_enq = “\u5982\u679c\u6ca1\u6709\u5165\u961f\uff0c\u6392\u7a7a\u7684\u9884\u8ba1\u65f6\u95f4\u3002”, message_latency_1 = “\u8fc7\u53bb5\u5206\u949f\u7684\u6d88\u606f\u5ef6\u8fdf\u3002”, message_latency_2 = “\u8fc7\u53bb1\u5c0f\u65f6\u7684\u6d88\u606f\u5ef6\u8fdf\u3002”, message_latency_3 = “\u8fc7\u53bb5\u4e2a\u5c0f\u65f6\u7684\u6d88\u606f\u5ef6\u8fdf\u3002” }
                                              \nrequest = ”’
                                              \nSELECT DISTINCT
                                              \nt1.inst_id,
                                              \nt1.queue_id,
                                              \nt2.queue_name,
                                              \nt1.subscriber_id AS subscriber_name,
                                              \nt1.enqueued_msgs,
                                              \nt1.dequeued_msgs,
                                              \nt1.remained_msgs,
                                              \nt1.time_since_last_dequeue,
                                              \nt1.estd_time_to_drain_no_enq,
                                              \nt1.message_latency_1,
                                              \nt1.message_latency_2,
                                              \nt1.message_latency_3
                                              \nFROM
                                              \n(
                                              \nSELECT
                                              \ninst_id,
                                              \nqueue_id,
                                              \nsubscriber_id,
                                              \nSUM(enqueued_msgs) AS enqueued_msgs,
                                              \nSUM(dequeued_msgs) AS dequeued_msgs,
                                              \nSUM(enqueued_msgs – dequeued_msgs) AS remained_msgs,
                                              \nMIN(time_since_last_dequeue) AS time_since_last_dequeue,
                                              \nMAX(estd_time_to_drain_no_enq) AS estd_time_to_drain_no_enq,
                                              \nAVG(10) AS message_latency_1,
                                              \nAVG(20) AS message_latency_2,
                                              \nAVG(30) AS message_latency_3
                                              \nFROM
                                              \ngv$aq_sharded_subscriber_stat
                                              \nGROUP BY
                                              \nqueue_id,
                                              \nsubscriber_id,
                                              \ninst_id
                                              \n) t1
                                              \nJOIN gv$persistent_queues t2 ON t1.queue_id = t2.queue_id
                                              \n”’<\/p>\n

                                              Dockerfile
                                              \nFROM container-registry.oracle.com\/database\/observability-exporter:1.1.0
                                              \nCOPY txeventq-metrics.toml \/
                                              \nENTRYPOINT [“\/oracledb_exporter”, “–custom.metrics”, “\/txeventq-metrics.toml”]<\/p>\n

                                              \u6784\u5efa
                                              \ndocker build -t txeventq_exporter:1.0 .<\/p>\n

                                              docker images
                                              \nREPOSITORY TAG IMAGE ID CREATED SIZE
                                              \ntxeventq_exporter 1.0 8169e80d23bb 12 minutes ago 709MB<\/p>\n

                                              \u8fd0\u884c\u6d4b\u8bd5
                                              \ndocker run -it –rm –name exporter -e DB_USERNAME=MONITOR -e DB_PASSWORD=Welcome12345# -e DB_CONNECT_STRING=xxxx:1521\/pdb23c.xxxx.vcn1.oraclevcn.com -p 9161:9161 txeventq_exporter:1.0<\/p>\n

                                              \u5728\u672c\u5730(http:\/\/localhost:9161\/metrics)\u4e2d\u786e\u8ba4
                                              \n# HELP oracledb_up Oracle\u6570\u636e\u5e93\u670d\u52a1\u5668\u662f\u5426\u8fd0\u884c\u3002
                                              \n# TYPE oracledb_up gauge
                                              \noracledb_up 1<\/p>\n

                                              \u6709\u8bb8\u591a\u6307\u6807\u88ab\u8bb0\u5f55\u4e0b\u6765\uff0c\u4f46\u5176\u4e2d\u4e00\u4e2a\u6307\u6807oracledb_up\u7684\u503c\u4e3a1\uff0c\u8bf4\u660e\u5df2\u6210\u529f\u8fde\u63a5\u5230\u6570\u636e\u5e93\u670d\u52a1\u5668\u3002<\/p>\n

                                              \u666e\u7f57\u7c73\u4fee\u65af\u7684\u8bbe\u7f6e<\/h1>\n
                                                \n
                                              1. \n
                                                  \u521b\u5efa\u4f5c\u4e1a\u7528\u76ee\u5f55<\/ol>\n<\/li>\n<\/ol>\n

                                                   <\/p>\n

                                                    \n
                                                  1. \n
                                                      mkdir -p monitoring\/prometheus<\/ol>\n<\/li>\n<\/ol>\n

                                                       <\/p>\n

                                                        \n
                                                      1. \n
                                                          cd monitoring\/prometheus<\/ol>\n<\/li>\n<\/ol>\n

                                                          \u521b\u5efaPrometheus\u7684\u914d\u7f6e\u6587\u4ef6prometheus.yaml<\/p>\n

                                                          prometheus.yaml
                                                          \nglobal:
                                                          \nscrape_interval: 15s
                                                          \nscrape_timeout: 10s
                                                          \nevaluation_interval: 15s
                                                          \nscrape_configs:
                                                          \n– job_name: prometheus
                                                          \nhonor_timestamps: true
                                                          \nscrape_interval: 15s
                                                          \nscrape_timeout: 10s
                                                          \nmetrics_path: \/metrics
                                                          \nstatic_configs:
                                                          \n– targets:
                                                          \n– localhost:9090
                                                          \n– job_name: oracle-exporter
                                                          \nscrape_interval: 15s
                                                          \nscrape_timeout: 10s
                                                          \nmetrics_path: \/metrics
                                                          \nstatic_configs:
                                                          \n– targets:
                                                          \n– exporter:9161<\/p>\n

                                                          \u62c9\u53d6Prometheus\u5b98\u65b9\u955c\u50cf
                                                          \ndocker pull prom\/prometheus:v2.47.2<\/p>\n

                                                          Grafana\u7684\u8bbe\u7f6e<\/h1>\n
                                                            \n
                                                          1. \n
                                                              \u521b\u5efa\u4f5c\u4e1a\u76ee\u5f55<\/ol>\n<\/li>\n<\/ol>\n

                                                               <\/p>\n

                                                                \n
                                                              1. \n
                                                                  mkdir monitoring\/grafana<\/ol>\n<\/li>\n<\/ol>\n

                                                                  \u914d\u7f6edatasource.yaml
                                                                  \nmkdir monitoring\/grafana\/datasources<\/p>\n

                                                                  datasource.yaml
                                                                  \napiVersion: 1
                                                                  \ndatasources:
                                                                  \n– name: Prometheus
                                                                  \ntype: prometheus
                                                                  \nurl: http:\/\/prometheus:9090
                                                                  \nisDefault: true
                                                                  \naccess: proxy
                                                                  \neditable: true<\/p>\n

                                                                  \u914d\u7f6edashboard
                                                                  \n\u672c\u6b21\u5c06\u4f7f\u7528\u4e24\u4e2a\u9884\u5148\u521b\u5efa\u7684\u4eea\u8868\u677f\u8fdb\u884cDB\u5b9e\u4f8b\u548cTxEventQ\u7684\u76d1\u89c6\u3002\u5728dashboards\u76ee\u5f55\u4e0b\uff0c\u521b\u5efa\u4e24\u4e2ajson\u6587\u4ef6oracledb.json\u548ctxeventq.json\uff0c\u4ee5\u53ca\u4e00\u4e2a\u914d\u7f6e\u6587\u4ef6dashboard.yaml\u3002\u5176\u4e2d\uff0coracledb.json\u4f7f\u7528\u6b64\u5904\u7684\u6587\u4ef6\uff0ctxeventq.json\u4f7f\u7528\u6b64\u5904\u7684\u6587\u4ef6\u3002
                                                                  \nmkdir monitoring\/grafana\/dashboards<\/p>\n

                                                                  dashboard.yaml
                                                                  \napiVersion: 1
                                                                  \nproviders:
                                                                  \n– name: “Dashboard provider”
                                                                  \norgId: 1
                                                                  \ntype: file
                                                                  \ndisableDeletion: false
                                                                  \nupdateIntervalSeconds: 10
                                                                  \nallowUiUpdates: false
                                                                  \noptions:
                                                                  \npath: \/var\/lib\/grafana\/dashboards
                                                                  \nfoldersFromFilesStructure: true<\/p>\n

                                                                  \u62c9\u53d6Grafana\u5b98\u65b9\u955c\u50cf
                                                                  \ndocker pull grafana\/grafana:10.2.1<\/p>\n

                                                                  docker compose\u7684\u914d\u7f6e<\/h1>\n

                                                                  \u8fd9\u6b21\uff0c\u6211\u4eec\u4f7f\u7528\u4e86Docker Compose\u8fdb\u884c\u6267\u884c\u3002\u6211\u4eec\u5c06\u5728monitoring\u76ee\u5f55\u4e2d\u521b\u5efa\u4ee5\u4e0b\u7684docker-compose.yml\u6587\u4ef6\u3002<\/p>\n

                                                                  services<\/span>:<\/span>\r\n  prometheus<\/span>:<\/span>\r\n    image<\/span>:<\/span> prom\/prometheus:v2.47.2<\/span>\r\n    container_name<\/span>:<\/span> prometheus<\/span>\r\n    command<\/span>:<\/span>\r\n      -<\/span> '<\/span>--config.file=\/etc\/prometheus\/prometheus.yaml'<\/span>\r\n    ports<\/span>:<\/span>\r\n      -<\/span> 9090:9090<\/span>\r\n    restart<\/span>:<\/span> unless-stopped<\/span>\r\n    volumes<\/span>:<\/span>\r\n      -<\/span> .\/prometheus:\/etc\/prometheus<\/span>\r\n      -<\/span> prom_data:\/prometheus<\/span>\r\n\r\n  grafana<\/span>:<\/span>\r\n    image<\/span>:<\/span> grafana\/grafana:10.2.1<\/span>\r\n    container_name<\/span>:<\/span> grafana<\/span>\r\n    ports<\/span>:<\/span>\r\n      -<\/span> 3000:3000<\/span>\r\n    restart<\/span>:<\/span> unless-stopped<\/span>\r\n    environment<\/span>:<\/span>\r\n      -<\/span> GF_SECURITY_ADMIN_USER=admin<\/span>\r\n      -<\/span> GF_SECURITY_ADMIN_PASSWORD=grafana<\/span>\r\n    volumes<\/span>:<\/span>\r\n      -<\/span> .\/grafana\/datasources:\/etc\/grafana\/provisioning\/datasources<\/span>\r\n      -<\/span> .\/grafana\/dashboards:\/var\/lib\/grafana\/dashboards<\/span>\r\n      -<\/span> .\/grafana\/datasources\/datasource.yaml:\/etc\/grafana\/provisioning\/datasources\/datasource.yaml<\/span>\r\n      -<\/span> .\/grafana\/dashboards\/dashboard.yaml:\/etc\/grafana\/provisioning\/dashboards\/main.yaml<\/span>\r\n\r\n\r\n  exporter<\/span>:<\/span>\r\n    image<\/span>:<\/span> txeventq_exporter:1.0<\/span>\r\n    container_name<\/span>:<\/span> exporter<\/span>\r\n    ports<\/span>:<\/span>\r\n      -<\/span> 9161:9161<\/span>\r\n    environment<\/span>:<\/span>\r\n      -<\/span> DB_USERNAME=monitor<\/span>\r\n      -<\/span> DB_PASSWORD=Welcome12345#<\/span>\r\n      -<\/span> DB_CONNECT_STRING=xxxx.vcn1.oraclevcn.com:1521\/pdb23c.xxxx.vcn1.oraclevcn.com<\/span>\r\n    volumes<\/span>:<\/span>\r\n      -<\/span> .\/exporter:\/exporter<\/span>\r\n\r\nvolumes<\/span>:<\/span>\r\n  prom_data<\/span>:<\/span>\r\n<\/code><\/pre>\n
                                                                  \u8bf7\u6839\u636e\u9700\u8981\u9002\u5f53\u4fee\u6539DB\u8fde\u63a5\u5b57\u7b26\u4e32DB_CONNECT_STRING\u3002<\/p>\n
                                                                  \u6700\u7ec8\u7684\u76ee\u5f55\u7ed3\u6784\u5728\u8fd9\u91cc\u3002<\/p>\n
                                                                  [<\/span>opc@devinsrd monitoring]$ <\/span>tree\r\n.<\/span>\r\n\u251c\u2500\u2500 docker-compose.yml\r\n\u251c\u2500\u2500 exporter\r\n\u2502\u00a0\u00a0 \u251c\u2500\u2500 Dockerfile\r\n\u2502\u00a0\u00a0 \u2514\u2500\u2500 txeventq-metrics.toml\r\n\u251c\u2500\u2500 grafana\r\n\u2502\u00a0\u00a0 \u251c\u2500\u2500 dashboards\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 dashboard.yaml\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u251c\u2500\u2500 oracledb.json\r\n\u2502\u00a0\u00a0 \u2502\u00a0\u00a0 \u2514\u2500\u2500 txeventq.json\r\n\u2502\u00a0\u00a0 \u2514\u2500\u2500 datasources\r\n\u2502\u00a0\u00a0     \u2514\u2500\u2500 datasource.yaml\r\n\u2514\u2500\u2500 prometheus\r\n    \u2514\u2500\u2500 prometheus.yaml\r\n<\/code><\/pre>\n
                                                                  \u8fd0\u884c Docker Compose\u3002<\/p>\n
                                                                  docker compose up -d<\/span>\r\n\r\n[<\/span>+] Running 5\/5\r\n \u2714 Network monitoring_default     Created                                                0.2s\r\n \u2714 Volume \"monitoring_prom_data\"<\/span>  Created                                                0.0s\r\n \u2714 Container prometheus           Started                                                0.1s\r\n \u2714 Container grafana              Started                                                0.1s\r\n \u2714 Container exporter             Started                                                0.1s\r\n<\/code><\/pre>\n
                                                                  \u5728\u672c\u5730(http:\/\/localhost:3000)\u8fdb\u884c\u786e\u8ba4\u3002<\/p>\n
                                                                  \"image.png\"<\/div>\n
                                                                  \"image.png\"<\/div>\n
                                                                    \n
                                                                  • \n
                                                                      \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30b9\u30c6\u30fc\u30bf\u30b9<\/ul>\n<\/li>\n<\/ul>\n
                                                                       <\/p>\n
                                                                        \n
                                                                      • \n
                                                                          \u30a2\u30af\u30c6\u30a3\u30d6\u306a\u30bb\u30c3\u30b7\u30e7\u30f3\u6570(Background\u3001user)<\/ul>\n<\/li>\n<\/ul>\n
                                                                           <\/p>\n
                                                                            \n
                                                                          • \n
                                                                              \u5b9f\u884c\u6570<\/ul>\n<\/li>\n<\/ul>\n
                                                                               <\/p>\n
                                                                                \u5f85\u6a5f\u6642\u9593<\/ul>\n
                                                                                \"image.png\"<\/div>\n
                                                                                \u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u6765\u76d1\u89c6TxEventQ\u3002\u7531\u4e8e\u8fd8\u6ca1\u6709\u521b\u5efa\u961f\u5217\uff0c\u6240\u4ee5\u6211\u4eec\u5728\u4e0b\u9762\u8fdb\u884c\u521b\u5efa\u3002<\/p>\n
                                                                                declare<\/span>\r\n    subscriber<\/span> sys<\/span>.<\/span>aq$_agent<\/span>;<\/span>\r\nbegin<\/span>\r\n  -- \u30c8\u30d4\u30c3\u30af(\u30ad\u30e5\u30fc\u8868\u306e\u4f5c\u6210)<\/span>\r\n  dbms_aqadm<\/span>.<\/span>create_transactional_event_queue<\/span>(<\/span>\r\n    queue_name<\/span> =><\/span> '<\/span>my_topic<\/span>'<\/span>,<\/span>\r\n    multiple_consumers<\/span> =><\/span> true<\/span>  -- pub\/sub\u30c8\u30d4\u30c3\u30af\u306e\u4f5c\u6210<\/span>\r\n  );<\/span>\r\n\r\n  -- \u30c8\u30d4\u30c3\u30af\u306e\u958b\u59cb<\/span>\r\n  dbms_aqadm<\/span>.<\/span>start_queue<\/span>(<\/span>\r\n    queue_name<\/span> =><\/span> '<\/span>my_topic<\/span>'<\/span>\r\n  );<\/span>\r\n\r\n  -- \u30b5\u30d6\u30b9\u30af\u30e9\u30a4\u30d0\u306e\u767b\u9332<\/span>\r\n  dbms_aqadm<\/span>.<\/span>add_subscriber<\/span>(<\/span>\r\n    queue_name<\/span> =><\/span> '<\/span>my_topic<\/span>'<\/span>,<\/span>\r\n    subscriber<\/span> =><\/span> sys<\/span>.<\/span>aq$_agent<\/span>(<\/span>\r\n      '<\/span>my_subscriber<\/span>'<\/span>,<\/span>    -- \u30b5\u30d6\u30b9\u30af\u30e9\u30a4\u30d0\u540d<\/span>\r\n      null<\/span>,<\/span>               -- \u901a\u77e5\u306b\u4f7f\u7528\u3055\u308c\u308b\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/span>\r\n      0<\/span>                   -- \u30d7\u30ed\u30c8\u30b3\u30eb<\/span>\r\n    ),<\/span>\r\n    rule<\/span> =><\/span> '<\/span>correlation = <\/span>''<\/span>my_subscriber<\/span>''<\/span>'<\/span>\r\n  );<\/span>\r\nend<\/span>;<\/span>\r\n\/<\/span>\r\n<\/code><\/pre>\n
                                                                                \u5982\u679c\u521b\u5efa\u5931\u8d25\uff0c\u8bf7\u68c0\u67e5\u6743\u9650\u3002\u6b64\u5916\uff0cdbms_aqadm.create_transactional_event_queue\u4ec5\u9002\u7528\u4e8eOracle Database 21c\u548c23c\u3002<\/p>\n
                                                                                \u6211\u5df2\u7ecf\u521b\u5efa\u4e86\u4e00\u4e2a\u961f\u5217\u8868\uff0c\u63a5\u4e0b\u6765\u5c06\u5c1d\u8bd5\u5411\u961f\u5217\u8868\u53d1\u9001\u6d88\u606f\uff08\u5165\u961f\uff09\u3002<\/p>\n
                                                                                declare<\/span>\r\n    enqueue_options<\/span>    dbms_aq<\/span>.<\/span>enqueue_options_t<\/span>;<\/span>\r\n    message_properties<\/span> dbms_aq<\/span>.<\/span>message_properties_t<\/span>;<\/span>\r\n    message_handle<\/span>     raw<\/span>(<\/span>16<\/span>);<\/span>\r\n    message<\/span>            SYS<\/span>.<\/span>AQ$_JMS_TEXT_MESSAGE<\/span>;<\/span>\r\nbegin<\/span>\r\n    -- \u30e1\u30c3\u30bb\u30fc\u30b8\u30fb\u30da\u30a4\u30ed\u30fc\u30c9\u306e\u4f5c\u6210<\/span>\r\n    message<\/span> :=<\/span> SYS<\/span>.<\/span>AQ$_JMS_TEXT_MESSAGE<\/span>.<\/span>construct<\/span>;<\/span>\r\n    message<\/span>.<\/span>set_text<\/span>(<\/span>'<\/span>{\"orderid\": 12345, \"username\": \"Jessica Smith\"}<\/span>'<\/span>);<\/span>\r\n\r\n    -- \u30b3\u30f3\u30b7\u30e5\u30fc\u30de\u540d\u306e\u767b\u9332<\/span>\r\n    message_properties<\/span>.<\/span>correlation<\/span> :=<\/span> '<\/span>my_subscriber<\/span>'<\/span>;<\/span>\r\n    \r\n    -- \u30e1\u30c3\u30bb\u30fc\u30b8\u306e\u30a8\u30f3\u30ad\u30e5\u30fc<\/span>\r\n    dbms_aq<\/span>.<\/span>enqueue<\/span>(<\/span>\r\n        queue_name<\/span>           =><\/span> '<\/span>my_topic<\/span>'<\/span>,<\/span>\r\n        enqueue_options<\/span>      =><\/span> enqueue_options<\/span>,<\/span>\r\n        message_properties<\/span>   =><\/span> message_properties<\/span>,<\/span>\r\n        payload<\/span>              =><\/span> message<\/span>,<\/span>\r\n        msgid<\/span>                =><\/span> message_handle<\/span>);<\/span>\r\n\r\n    -- \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u306e\u30b3\u30df\u30c3\u30c8<\/span>\r\n    commit<\/span>;<\/span>\r\nend<\/span>;<\/span>\r\n\/<\/span>\r\n<\/code><\/pre>\n
                                                                                \u56e0\u4e3a\u6211\u4eec\u5df2\u7ecf\u5b8c\u6210\u4e86Enqueue\uff0c\u6240\u4ee5\u6211\u4f1a\u5728Grafana\u4e0a\u8fdb\u884c\u786e\u8ba4\u3002\u6211\u4f1a\u67e5\u770b\u4eea\u8868\u677f\u4e0a\u7684TxEventQ Monitor\u3002
                                                                                \n\u4f60\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u6307\u6807\u8fdb\u884c\u786e\u8ba4\u3002<\/p>\n
                                                                                  \n
                                                                                • \n
                                                                                    TxEventQ\u306e\u30b9\u30c6\u30fc\u30bf\u30b9<\/ul>\n<\/li>\n<\/ul>\n
                                                                                     <\/p>\n
                                                                                      \n
                                                                                    • \n
                                                                                        \u30ad\u30e5\u30fc\u8868(\u30c8\u30d4\u30c3\u30af)\u306e\u6570<\/ul>\n<\/li>\n<\/ul>\n
                                                                                         <\/p>\n
                                                                                          \n
                                                                                        • \n
                                                                                            \u30b5\u30d6\u30b9\u30af\u30e9\u30a4\u30d0\u306e\u6570<\/ul>\n<\/li>\n<\/ul>\n
                                                                                             <\/p>\n
                                                                                              \n
                                                                                            • \n
                                                                                                \u30a8\u30f3\u30ad\u30e5\u30fc\/\u30c7\u30ad\u30e5\u30fc\u7387(\u6027\u80fd\u6307\u6a19)<\/ul>\n<\/li>\n<\/ul>\n
                                                                                                 <\/p>\n
                                                                                                  \u30a8\u30f3\u30ad\u30e5\u30fc\/\u30c7\u30ad\u30e5\u30fc\u3055\u308c\u305f\u30e1\u30c3\u30bb\u30fc\u30b8\u6570<\/ul>\n
                                                                                                  \"image.png\"<\/div>\n
                                                                                                  \u53e6\u5916\uff0c\u60a8\u8fd8\u53ef\u4ee5\u83b7\u53d6\u4ee5\u4e0b\u9488\u5bf9\u6bcf\u4e2a\u4e3b\u9898\u6216\u8ba2\u9605\u8005\u7684\u7279\u5b9a\u6307\u6807\u3002<\/p>\n
                                                                                                  \"image.png\"<\/div>\n
                                                                                                  \u6700\u540e\u4e00\u53e5<\/h1>\n
                                                                                                  \u672c\u6b21\u6211\u4eec\u5c1d\u8bd5\u4f7f\u7528Oracle Database Observability Exporter + Prometheus + Grafana\u6765\u76d1\u63a7Oracle Transactional Event Queues\u3002\u867d\u7136\u53ef\u4ee5\u4f7f\u7528Enterprise Manager\uff08EM\uff09\u6216\u4e91\u7aef\u7684Database Management\u7b49\u670d\u52a1\u6765\u76d1\u63a7Oracle Database\uff0c\u4f46\u5982\u679c\u8981\u5bf9\u7279\u5b9a\u961f\u5217\u8fdb\u884c\u6307\u6807\u76d1\u63a7\uff0c\u5219\u53ef\u4ee5\u7ed3\u5408\u8fd9\u4e9b\u5f00\u6e90\u5de5\u5177\u6765\u5b9e\u73b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
                                                                                                  \u9996\u5148 \u5728Oracle Database 23c(21c)\u4e2d\uff0c\u6709\u4e24\u4e2a\u514d\u8d39\u53ef\u7528\u7684\u529f\u80fd\uff0c\u4e00\u4e2a\u662f\u529f\u80fd\u5f3a\u5927\u7684\u6d88\u606f\u961f\u5217\u7cfb\u7edf […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-43169","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528prometheus-grafana\u76d1\u63a7oracle-transactional-event-queues\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues\" \/>\n<meta property=\"og:description\" content=\"\u9996\u5148 \u5728Oracle Database 23c(21c)\u4e2d\uff0c\u6709\u4e24\u4e2a\u514d\u8d39\u53ef\u7528\u7684\u529f\u80fd\uff0c\u4e00\u4e2a\u662f\u529f\u80fd\u5f3a\u5927\u7684\u6d88\u606f\u961f\u5217\u7cfb\u7edf […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528prometheus-grafana\u76d1\u63a7oracle-transactional-event-queues\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-23T08:06:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T20:09:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d511437434c4406cc89f1\/6-0.png\" \/>\n<meta name=\"author\" content=\"\u65b0, \u97f5\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u65b0, \u97f5\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/\",\"name\":\"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-10-23T08:06:55+00:00\",\"dateModified\":\"2024-04-29T20:09:23+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9\",\"name\":\"\u65b0, \u97f5\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g\",\"caption\":\"\u65b0, \u97f5\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528prometheus-grafana\u76d1\u63a7oracle-transactional-event-queues\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues","og_description":"\u9996\u5148 \u5728Oracle Database 23c(21c)\u4e2d\uff0c\u6709\u4e24\u4e2a\u514d\u8d39\u53ef\u7528\u7684\u529f\u80fd\uff0c\u4e00\u4e2a\u662f\u529f\u80fd\u5f3a\u5927\u7684\u6d88\u606f\u961f\u5217\u7cfb\u7edf […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528prometheus-grafana\u76d1\u63a7oracle-transactional-event-queues\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-10-23T08:06:55+00:00","article_modified_time":"2024-04-29T20:09:23+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d511437434c4406cc89f1\/6-0.png"}],"author":"\u65b0, \u97f5","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u65b0, \u97f5","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"6 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/","name":"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-10-23T08:06:55+00:00","dateModified":"2024-04-29T20:09:23+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528Prometheus + Grafana\u76d1\u63a7Oracle Transactional Event Queues"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/4ba4019495123db3038fd0809e6959c9","name":"\u65b0, \u97f5","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d484b6c6e4ae82e8a9efea989e1d2af46d9b6ef128101e63b18f559fca0ae627?s=96&d=mm&r=g","caption":"\u65b0, \u97f5"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunxin\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8prometheus-grafana%e7%9b%91%e6%8e%a7oracle-transactional-event-queues\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43169","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=43169"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43169\/revisions"}],"predecessor-version":[{"id":89591,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/43169\/revisions\/89591"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=43169"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=43169"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=43169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}