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.