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

Key features

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

Overview dashboard
Multi-session intelligent dialogue
Cluster health inspection
SQL diagnostics and tuning
Alert and exception analysis
Capacity and resource analysis
ASH diagnostic report
Read-only query
Reporting and visualization
Parameter and change governance
Statistic information diagnostics
Database Change Management
Knowledge Base Q&A
Scheduled Tasks
Platform Configuration and Expansion
Tool Management
Model Scoring
Multi-channel Access

OAgent provides the following features for the daily operation and maintenance of OceanBase Database.

Overview dashboard

The default homepage after login displays statistics overview at the top, showing the number of connections, clusters and tenants, as well as the trend of requests and token consumption in the last 7 days. The quick panel at the bottom aggregates recent sessions, recent reports, quick scenario entries, and an overview of scheduled tasks, enabling you to perform frequent operations on one screen. For more information, see Overview page.

Multi-session intelligent dialogue

Supports parallel management of multiple sessions and rewind of historical sessions. You can switch large language models at any time within a session. The tool invocation process is visually displayed on the interface, supporting expansion to view complete inputs and return results, and supports manual approval for sensitive operations. For more information, see Session dashboard.

Cluster health inspection

One-click inspection of key metrics of OceanBase clusters, such as basic information, resource utilization (CPU/memory/disk), active alerts, slow SQL, and Top SQL, and output of inspection summaries and risk prompts. Inspections can be initiated temporarily during a dialogue or configured as scheduled tasks to run automatically daily/weekly. For more information, see Cluster health inspection.

SQL diagnostics and tuning

Supports identification of TopSQL/slow SQL/abnormal SQL, execution plan interpretation, SQL pre-analysis (EXPLAIN), index and DDL viewing, and assessment of risks such as full table scans based on table statistics (number of rows, size, degree of parallelism), outputting executable tuning suggestions. For more information, see Slow SQL, TopSQL, and abnormal SQL analysis.

Alert and exception analysis

Supports querying active and historical alerts from OCP/OAS, summarizing and displaying them by alert level, and providing troubleshooting steps from the handling manual for specific alert types. For exceptional events such as instantaneous jitter or abnormal connection counts, root cause analysis (RCA) can be performed, outputting root cause rankings and validation suggestions. For more information, see Alert query and handling guide.

Capacity and resource analysis

Supports querying resource utilization, capacity levels, Zone/Server/Unit distribution, and compaction status for clusters/tenants, and interpreting capacity level risks and providing capacity planning suggestions. For more information, see Cluster and topology information query and Resource metrics and task status query.

ASH diagnostic report

Supports online creation, status polling, content retrieval, and interpretation of Active Session History (ASH) sampling reports. Also supports uploading existing ASH reports (HTML/text) for interpretation by the Agent, aiding in locating the time window where performance bottlenecks occurred, key wait events, and high-frequency SQL. For more information, see ASH diagnostic report.

Read-only query

Supports initiating read-only SQL queries against business tenants and the system tenant (sys), and viewing execution plans via EXPLAIN to assist in data verification and plan confirmation. Write operations are not performed here. For more information, see Read-only query.

Reporting and visualization

Inspection, alert, RCA, SQL, and ASH analysis conclusions can be exported as HTML/PDF reports for archiving and sharing. Time-series, percentage, and detailed data returned by the tool are automatically rendered into line charts, bar charts, pie charts, and tables, and support downloading. For more information, see Export reports and Data visualization.

Parameter and change governance

Supports completing parameter checking, changing, verification, and generation of rollback plans within a dialogue, and creating database change tickets and querying approval progress through ODC. Changes are executed directly without bypassing approval. For more information, see Parameter checking and change governance and Database change ticket.

Statistic information diagnostics

Supports querying the collection overview, task execution history, Top N table update counts, and automatic collection configuration of table/tenant-level statistic information, identifying risky tables with outdated statistics, and providing suggestions for manual/automatic collection. For more information, see Statistic information diagnostics.

Database Change Management

ODC supports creating, approving, rejecting, executing, and querying the results of database change tickets, integrating all change operations into a unified workflow. For more information, see Database change ticket.

Knowledge Base Q&A

ODC integrates with the official OceanBase/OCP documentation knowledge base, covering topics such as core database knowledge, deployment and maintenance guides, SQL performance optimization, troubleshooting, and error code references. You can also upload your enterprise-specific documentation to create a private knowledge base. For more information, see Built-in knowledge base.

Scheduled Tasks

You can configure scheduled tasks using Cron expressions (for example, daily inspections). Task results are recorded as execution history and reports, making it easy to review trends in cluster health over time. For more information, see Overview.

Platform Configuration and Expansion

ODC supports system configuration, usage statistics, and management of experimental features. It also extends platform capabilities through model services and skill configurations. For more information, see Experimental features.

Tool Management

ODC provides a dedicated tool management page where you can view the product to which each tool belongs, its capability description, and invocation method. You can also control its enablement scope to influence the set of capabilities available for Agent invocation. For more information, see Tool management.

Model Scoring

ODC supports evaluating models by scoring them automatically based on test case sets and enabling horizontal comparison of model options. The collected scores help optimize default models and prompt strategies. For more information, see Model scoring.

Multi-channel Access

In addition to the web interface, OAgent supports access via messaging channels such as DingTalk, Lark, WeCom, and Telegram. It provides channel configuration, connection verification, and task result push, facilitating integration with existing enterprise automation processes and duty groups. For more information, see Multi-channel access.

Previous topic

What is OAgent?
Last

Next topic

System architecture
Next
on this page
Overview dashboard
Multi-session intelligent dialogue
Cluster health inspection
SQL diagnostics and tuning
Alert and exception analysis
Capacity and resource analysis
ASH diagnostic report
Read-only query
Reporting and visualization
Parameter and change governance
Statistic information diagnostics
Database Change Management
Knowledge Base Q&A
Scheduled Tasks
Platform Configuration and Expansion
Tool Management
Model Scoring
Multi-channel Access