OAgent comes with a preconfigured set of skills for OceanBase maintenance and diagnostic scenarios. You can view all skills and control their enable/disable status on the Skills page. For more information, see Overview of skill management.
Note
The skill list is updated with product version releases. For the actual available skills, refer to the content displayed on the Skills page.
Inspection and cluster management
Skill ID |
Feature Description |
|---|---|
cluster_inspection |
Perform multi-dimensional health inspections on a specified cluster and output risk items |
cluster_list |
Query the list of clusters and basic information under a product |
cluster_resource_stats |
Query resource usage statistics of clusters and tenants |
SQL diagnostics and tuning
Skill ID |
Feature Description |
|---|---|
slow_sql_analysis |
Analyze Slow Queries within a Specified Time Range |
sql_diagnose |
Comprehensively Diagnose the Execution Status of Specified SQL |
sql_pre_analysis |
Perform EXPLAIN pre-analysis on SQL statements to identify plan risks |
sql_tuning_advisor |
Output optimization suggestions such as index and rewrite |
sql_deep_tuning |
In-depth Tuning Analysis for Complex SQL Execution |
execution_plan_interpreter |
Interpret the execution plan by operator |
Performance and session analytics
Skill ID |
Feature Description |
|---|---|
ash_analysis |
Analyze active session history to identify wait events and bottleneck time points |
ash_report |
Trigger and obtain an ASH diagnostic report |
session_analysis |
Analyze Current or Historical Session Snapshots |
Alert and anomaly analysis
Skill ID |
Feature Description |
|---|---|
alarm_report |
Query active and historical alerts and summarize them by severity |
alarm_handbook |
Provide troubleshooting and remediation steps for specific alert types |
anomaly_analysis |
Analyze the manifestations and impact scope of the exception |
root_cause_analysis |
Output the possible root cause ranking and verification suggestions for the exception |
Statistical information and knowledge
Skill ID |
Feature Description |
|---|---|
statistics_diagnostics |
Diagnostic Tenant Statistics Collection Coverage and Time Limit |
ob_knowledge_qa |
Answer Based on the Built-in OceanBase Knowledge Base |
user_upload_md_qa |
Answer based on user-uploaded documents |
error_code_reference |
Query OceanBase error codes for definitions and troubleshooting suggestions |
Tasks and reports
Skill ID |
Feature Description |
|---|---|
create_scheduled_task |
Create a scheduled task via dialog |
report-export |
Export Analysis Results to a Report |
Related operations
View the capability overview by category. For more information, see Feature list.
Enable, disable, or create a new skill. For more information, see Overview of skill management.