OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase AI DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog ServiceOceanBase DataPilotOceanBase OAgent
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase OAgent

V2.2.0
  • Product overview
    • What is OAgent?
    • Key features
    • System architecture
    • Use cases
  • Quick start
  • Deployment
  • Overview
  • Sessions and diagnosis
    • Manage sessions
    • Switch dialogue models
    • Use @ to mention the analysis target
    • View the tool invocation process
    • Upload an attachment
    • Data visualization
    • FAQ
    • Export a report
  • Tools
  • Skill Management
  • Channel management
  • Knowledge base
    • Built-in knowledge base
    • Custom knowledge base
  • Scheduled tasks
    • Overview of scheduled tasks
    • Create a scheduled task
  • View usage
  • Model configuration
    • Manage model services
    • Model scoring
  • Settings and security
    • Product management
    • Experimental features
  • Best practices
    • Perform a cluster health inspection
    • Query cluster and topology information
    • Query resource metrics and task status
    • Read-only queries
    • Alert query and troubleshooting guide
    • Root cause analysis of exceptions
    • ASH diagnostic report
    • Analyze slow SQL, TopSQL, and abnormal SQL
    • SQL pre-analysis and tuning recommendations
    • Interpret execution plans
    • Diagnostic information statistics
    • Parameter check and change governance
    • Database change ticket
  • Appendix
    • Feature list
    • Built-in Skills
  • Release notes
    • OAgent V2.2.0 Release note
    • OAgent V2.1.0 Release note
    • OAgent V2.0.0 Release note
    • OAgent V1.8.0 Release note

Download PDF

Document Feedback
  1. Documentation Center
  2. OceanBase OAgent
  3. V2.2.0

Query resource metrics and task status

Last Updated:2026-11-20 07:25:11

When to use
Prerequisites
Procedure
What to do next

This topic describes how to query the resource capacity, performance metrics, key parameters, compaction status, and background tasks of a cluster or tenant through dialogue, to assist in capacity planning and troubleshooting.

When to use

  • Evaluate CPU/memory/disk usage to determine whether scaling up or unit specification adjustment is necessary.
  • Identify the cause of elevated CPU, I/O, or memory usage over a period, and confirm the source of high load.
  • Query the current values of cluster/tenant-level parameters to verify consistency with baselines.
  • Troubleshoot compaction exceptions such as ongoing compactions, compaction timeouts, or backlog of minor compactions.
  • Track the execution status of background tasks (such as major compactions, data completion, partition migration).

Prerequisites

  • You have configured an OCP connection for the target cluster's product; to query performance metrics, you need to configure an OAS connection. For details, see Create a product connection.

Procedure

  1. In the session, use @ to select the target cluster (or tenant).

  2. Enter your query based on your purpose, for example:

    What are the current CPU, memory, and disk usage rates of this cluster?
    Check the CPU and I/O trends of tenant xxx for the last hour.
    View the values of the cluster parameters memory_limit and ob_max_thread_number.
    Is the compaction status of this cluster normal? Are any stuck?
    What are the major compaction tasks running in the background and what is their progress?
    
  3. Press Enter to send the request and wait for the Agent to return the results.

    The Agent will call tools related to cluster/tenant resources, metrics, parameters, compaction, and background tasks.

  4. View the returned results.

    • Resource and metric results are rendered as line charts or tables for intuitive trend comparison; for display and download methods of charts, see Data visualization.
    • Parameter queries list the parameter name, current value, whether it can be dynamically modified, and its value range.
    • Compaction and background task status indicates whether there are exceptions and the duration.

Note

For parameter change operations, OAgent only generates suggestions for parameter check, change, validation, and rollback SQL statements; it does not directly execute changes without approval. For details, see Parameter check and change governance.

What to do next

  • If metric abnormalities require drilling down to the SQL level, refer to Slow SQL, TopSQL, and abnormal SQL analysis.

  • If you suspect that the abnormal water level is caused by a major compaction or background task, you can perform root cause analysis in conjunction with the exception. For more information, see Root cause analysis of exceptions.

  • To turn resource inspection into a periodic task, see Create a scheduled task.

Previous topic

Query cluster and topology information
Last

Next topic

Read-only queries
Next
on this page
When to use
Prerequisites
Procedure
What to do next