db

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Oracle Database Skills

Oracle Database 技能

This domain contains Oracle Database skills for administration, SQL and PL/SQL development, performance tuning, security, ORDS, SQLcl, migrations, frameworks, OCR container guidance, and agent-safe database workflows.

该领域涵盖Oracle Database管理、SQL与PL/SQL开发、性能调优、安全、ORDS、SQLcl、迁移、框架、OCR容器指导以及Agent安全数据库工作流相关技能。

How to Use This Domain

如何使用该领域

Start with the routing table below.
Read only the specific file or category you need.

从下方的路由表开始。
仅阅读你所需的特定文件或分类。

Directory Structure

目录结构

text

db/
├── admin/
├── agent/
├── appdev/
├── architecture/
├── containers/
├── design/
├── devops/
├── features/
├── frameworks/
├── migrations/
├── monitoring/
├── ords/
├── performance/
├── plsql/
├── security/
├── sql-dev/
└── sqlcl/

text

db/
├── admin/
├── agent/
├── appdev/
├── architecture/
├── containers/
├── design/
├── devops/
├── features/
├── frameworks/
├── migrations/
├── monitoring/
├── ords/
├── performance/
├── plsql/
├── security/
├── sql-dev/
└── sqlcl/

Category Routing

分类路由

Topic	Directory
Backup, recovery, RMAN, Data Guard, redo/undo logs, users	`db/admin/`
Safe DML, destructive operation guards, idempotency, schema discovery, ORA- error handling	`db/agent/`
JDBC, pooling, JSON, XML, spatial, Oracle Text, transactions, MLE, language drivers	`db/appdev/`
RAC, Multitenant, Exadata, In-Memory, OCI database services, Data Guard architecture	`db/architecture/`
OCR database-category container images and pull guidance	`db/containers/`
ERD, data modeling, partitioning, tablespaces	`db/design/`
Schema migrations, online operations, edition-based redefinition, testing, version control	`db/devops/`
AQ, DBMS_SCHEDULER, materialized views, DBLinks, APEX, vector search, SELECT AI	`db/features/`
SQLAlchemy, Django, Pandas, Spring JPA, MyBatis, TypeORM, Sequelize, Dapper, GORM	`db/frameworks/`
Migrations from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, and more	`db/migrations/`
Alert log, ADR, health monitor, space management, top SQL	`db/monitoring/`
ORDS architecture, installation, REST design, authentication, monitoring	`db/ords/`
AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory	`db/performance/`
Package design, error handling, performance, collections, cursors, debugging	`db/plsql/`
Privileges, VPD, masking, auditing, encryption, network security	`db/security/`
SQL tuning, SQL patterns, dynamic SQL, injection avoidance	`db/sql-dev/`
SQLcl basics, scripting, Liquibase, formatting, DDL generation, data loading, MCP server, scheduler daemon, AWR, background jobs	`db/sqlcl/`

主题	目录
备份、恢复、RMAN、Data Guard、重做/撤销日志、用户	`db/admin/`
安全DML、破坏性操作防护、幂等性、Schema发现、ORA-错误处理	`db/agent/`
JDBC、连接池、JSON、XML、空间数据、Oracle Text、事务、MLE、语言驱动	`db/appdev/`
RAC、多租户、Exadata、内存数据库、OCI数据库服务、Data Guard架构	`db/architecture/`
OCR数据库分类容器镜像及拉取指导	`db/containers/`
ERD、数据建模、分区、表空间	`db/design/`
Schema迁移、在线操作、基于版本的重定义、测试、版本控制	`db/devops/`
AQ、DBMS_SCHEDULER、物化视图、数据库链接、APEX、向量搜索、SELECT AI	`db/features/`
SQLAlchemy、Django、Pandas、Spring JPA、MyBatis、TypeORM、Sequelize、Dapper、GORM	`db/frameworks/`
从PostgreSQL、MySQL、SQL Server、MongoDB、Snowflake等数据库迁移	`db/migrations/`
告警日志、ADR、健康监控、空间管理、Top SQL	`db/monitoring/`
ORDS架构、安装、REST设计、认证、监控	`db/ords/`
AWR、ASH、执行计划、索引、优化器统计信息、等待事件、内存管理	`db/performance/`
包设计、错误处理、性能优化、集合、游标、调试	`db/plsql/`
权限、VPD、数据脱敏、审计、加密、网络安全	`db/security/`
SQL调优、SQL模式、动态SQL、注入防护	`db/sql-dev/`
SQLcl基础、脚本编写、Liquibase、格式化、DDL生成、数据加载、MCP服务器、调度守护进程、AWR、后台任务	`db/sqlcl/`

Key Starting Points

关键起始点

```
db/sqlcl/sqlcl-mcp-server.md
```
```
db/migrations/migration-assessment.md
```
```
db/performance/explain-plan.md
```
```
db/plsql/plsql-package-design.md
```
```
db/devops/schema-migrations.md
```
```
db/agent/schema-discovery.md
```

db/containers/container-selection-matrix.md

```
db/sqlcl/sqlcl-mcp-server.md
```
```
db/migrations/migration-assessment.md
```
```
db/performance/explain-plan.md
```
```
db/plsql/plsql-package-design.md
```
```
db/devops/schema-migrations.md
```
```
db/agent/schema-discovery.md
```

db/containers/container-selection-matrix.md

Common Multi-Step Flows

常见多步骤流程

Task	Recommended Sequence
Diagnose a slow query	`explain-plan` → `wait-events` → `optimizer-stats` → `awr-reports`
Plan a migration	`migration-assessment` → `oracle-migration-tools` → source-specific `migrate-*.md` → `migration-cutover-strategy`
Build RAG on Oracle Database	`ai-profiles` → `vector-search` → `dbms-vector`
Perform agent-safe schema change	`schema-discovery` → `destructive-op-guards` → `idempotency-patterns` → `schema-migrations`
Set up AI-driven database access via MCP	`sqlcl-basics` (save connections) → `security/privilege-management` (least-privilege user) → `sqlcl-mcp-server` (configure + start)

任务	推荐步骤
诊断慢查询	`explain-plan` → `wait-events` → `optimizer-stats` → `awr-reports`
规划迁移	`migration-assessment` → `oracle-migration-tools` → 对应源数据库的 `migrate-*.md` → `migration-cutover-strategy`
在Oracle Database上构建RAG	`ai-profiles` → `vector-search` → `dbms-vector`
执行Agent安全的Schema变更	`schema-discovery` → `destructive-op-guards` → `idempotency-patterns` → `schema-migrations`
通过MCP设置AI驱动的数据库访问	`sqlcl-basics` （保存连接）→ `security/privilege-management` （最小权限用户）→ `sqlcl-mcp-server` （配置并启动）