V$OB_QUERY_RESPONSE_TIME_HISTOGRAM|V5.0.1|OceanBase Database|docs|OceanBase Documentations

Column	Type	Nullable	Description
SVR_IP	VARCHAR2(46)	NO	The IP address of the node.
SVR_PORT	NUMBER(38)	NO	The port number of the node.
TENANT_ID	NUMBER(38)	NO	The tenant ID.
SQL_TYPE	VARCHAR2(128)	NO	The statement type of the query. Valid values: SELECT INSERT UPDATE DELETE REPLACE COMMIT OTHER INNER SQL TABLEAPI SELECT TABLEAPI INSERT TABLEAPI DELETE TABLEAPI UPDATE TABLEAPI REPLACE TABLEAPI QUERY AND MUTATE TABLEAPI OTHER HBASE SCAN HBASE PUT HBASE DELETE HBASE APPEND HBASE INCREMENT HBASE CHECK AND PUT HBASE CHECK AND DELETE HBASE HYBRID BATCH
RESPONSE_TIME	NUMBER	NO	The interval value of the response time, in seconds.
COUNT	NUMBER(38)	NO	The count of queries in the interval.
TOTAL	NUMBER	NO	The total time of queries in the interval, in seconds.

obclient [SYS]> SELECT * FROM SYS.V$OB_QUERY_RESPONSE_TIME_HISTOGRAM WHERE ROWNUM = 2\G

*************************** 1. row ***************************
       SVR_IP: xx.xx.xx.xx
     SVR_PORT: 2882
    TENANT_ID: 1002
     SQL_TYPE: SELECT
RESPONSE_TIME: 0.000001
        COUNT: 0
        TOTAL: 0.000000
*************************** 2. row ***************************
       SVR_IP: xx.xx.xx.xx
     SVR_PORT: 2882
    TENANT_ID: 1002
     SQL_TYPE: SELECT
RESPONSE_TIME: 0.000010
        COUNT: 0
        TOTAL: 0.000000
2 rows in set

obclient [SYS]> SELECT * FROM SYS.V$OB_QUERY_RESPONSE_TIME_HISTOGRAM WHERE SQL_TYPE = "TABLEAPI SELECT" AND ROWNUM = 2\G

*************************** 1. row ***************************
       SVR_IP: 172.xx.xxx.xxx
     SVR_PORT: 2882
    TENANT_ID: 1004
     SQL_TYPE: TABLEAPI SELECT
RESPONSE_TIME: 0.000001
        COUNT: 0
        TOTAL: 0.000000
*************************** 2. row ***************************
       SVR_IP: 172.xx.xxx.xxx
     SVR_PORT: 2882
    TENANT_ID: 1004
     SQL_TYPE: TABLEAPI SELECT
RESPONSE_TIME: 0.000010
        COUNT: 0
        TOTAL: 0.000000
2 rows in set

V$OB_QUERY_RESPONSE_TIME_HISTOGRAM

Note

Purpose

Columns

Sample query

References