All Products
Search

This Product

    ApsaraDB for OceanBase (Deprecated):View performance and SQL monitoring details

    Document Center

    ApsaraDB for OceanBase (Deprecated):View performance and SQL monitoring details

    Last Updated:Feb 25, 2026

    On the performance and SQL monitoring details page of a tenant, you can view basic information about the tenant and the monitoring data such as SQL execution status.

    View performance and SQL monitoring data

    By default, the Performance and SQL tab displays the number of sessions and the execution frequency and response time of general SQL statements in the last hour. You can specify a time period or click fields in a chart to filter the data to view.

    1

    The following table describes the performance metrics.

    Note

    You can click the question mark (?) next to a monitoring metric to view its details.

    Monitoring item

    Metric

    Unit

    Description

    QPS

    • sql_all_count

    • sql_delete_count

    • sql_insert_count

    • sql_other_count

    • sql_replace_count

    • sql_select_count

    • sql_update_count

    Times/s

    The number of a specific type of SQL statements processed per second.

    SQL Response Time

    • sql_all_rt

    • sql_delete_rt

    • sql_insert_rt

    • sql_other_rt

    • sql_replace_rt

    • sql_select_rt

    • sql_update_rt

    • p99_sql_all_rt

    μs

    The average time consumed in processing a specific type of SQL statements, and the average time consumed in processing SQL statements at the 99th percentile.

    TPS

    • transaction_count: TPS

    • transaction_commit_count

    • transaction_rollback_count

    • transaction_timeout_count

    Times/s

    The number of a specific type of transaction operations processed per second in the tenant database.

    Transaction Response Time

    transaction_rt: the response time of transactions.

    transaction_commit_rt: the average time consumed in committing a transaction.

    transaction_rollback_rt: the average time consumed in rolling back a transaction.

    μs

    The average time consumed in processing a specific type of transaction operations.

    Number of Sessions

    • all_session

    • active_session

    Sessions

    The number of all or active sessions in the tenant database.

    Number of SQL Execution Plans

    • sql_local_count

    • sql_distribute_count

    • sql_remote_count

    Times/s

    The number of executions of a specific type of execution plans.

    Events Waited per Second

    • wait_event_count

    Times/s

    The number of a specific type of wait events per second.

    Average Wait Time per Event

    μs

    The average wait time of a specific type of wait events.

    Requests Enqueued and Dequeued per Second

    Times/s

    The number of requests entering or exiting the queue per second.

    SQL Request Queue Time

    request_queue_time

    μs

    The time consumed by an SQL statement waiting in a queue.

    CPU Utilization of Tenant

    ob_cpu_percent

    %

    The CPU utilization of the tenant.

    Memory Usage of OceanBase Tenant

    ob_tenant_memory_percent

    %

    The memory usage of the tenant.

    MemStore Usage

    memstore_percent

    %

    The MemStore usage of the tenant.

    RPC Packet Transmission Time

    μs

    The average time consumed in sending or receiving an RPC packet.

    RPC packet throughput per unit time

    KiB

    The data amount of RPC packets that are sent and received per unit time.

    Open Cursor Count

    opened_cursors_count

    N/A

    The number of open cursors.

    Slow SQL Statements

    slow_sql_count

    N/A

    The number of slow SQL statements.

    Database Work Time

    • ob_worktime

    • ob_foreground_worktime

    • ob_background_worktime

    s

    • The total working time of the database.

    • The frontend working time of the database.

    • The backend working time of the database.

    Database Non-idle Waiting Time

    • ob_no_idle_waiting_time

    • ob_foreground_no_idle_waiting_time

    • ob_background_no_idle_waiting_time

    s

    • The total non-idle waiting time of the database.

    • The frontend non-idle waiting time of the database.

    • The backend non-idle waiting time of the database.

    Wait Events

    • ob_waitevent_count

    • ob_foreground_waitevent_count

    • ob_background_waitevent_count

    Events

    • The number of wait events in a specific state in the tenant database.

    • The number of wait events in a specific state in the frontend of the tenant database.

    • The number of wait events in a specific state in the backend of the tenant database.

    Execution Events in Specific State in Database

    • ob_sql_event

    • ob_sql_event_in_parse

    • ob_sql_event_in_pl_parse

    • ob_sql_event_in_plan_cache

    • ob_sql_event_in_sql_optimize

    • ob_sql_event_in_sql_execution

    • ob_sql_event_in_px_execution

    • ob_sql_event_in_sequence_load

    Events

    • The number of execution events in a specific state of the tenant.

    • The number of execution events in the PARSE state of the tenant.

    • The number of execution events in the PL PARSE state of the tenant.

    • The number of execution events in the PLAN CACHE state of the tenant.

    • The number of execution events in the SQL OPTIMIZE state of the tenant.

    • The number of execution events in the SQL EXECUTION state of the tenant.

    • The number of execution events in the PX EXECUTION state of the tenant.

    • The number of execution events in the SEQUENCE LOAD state of the tenant.

    Ob Clog Replayed Scn

    ob_clog_ls_max_replayed_scn

    ms

    The replica latency.