oracle-db

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Oracle DB Skills

Oracle数据库技能指南

A collection of 129 standalone reference guides for Oracle Database and Oracle Container Registry (OCR) database-category container images. Each file covers one topic with explanations, practical examples, best practices, and common mistakes.

这是一份包含129份独立参考指南的集合，覆盖Oracle数据库与Oracle容器注册表（OCR）数据库类容器镜像。每份文件针对一个主题，包含说明、实用示例、最佳实践及常见误区。

How to Use

使用方法

Find the right skill using the category routing table below.
Read only the file(s) relevant to the task — do not load all files at once.
Apply the guidance to answer questions, generate code, or review existing work.

Skill files are in:

D:\0. KCSI\Github\pandawa\skills\oracle-db\skills\

通过下方分类路由表找到合适的技能指南。
仅阅读与任务相关的文件——请勿一次性加载所有文件。
应用指南内容来解答问题、生成代码或审核现有工作。

技能文件路径：

D:\0. KCSI\Github\pandawa\skills\oracle-db\skills\

Category Routing

分类路由

User asks about…	Read from
Backup, recovery, RMAN, redo/undo logs, users	`skills/admin/`
JDBC, Python, Node.js, .NET, Go drivers; pooling, JSON, XML, spatial, full-text, transactions, property graphs	`skills/appdev/`
RAC, CDB/PDB, Exadata, In-Memory, OCI, ATP/ADW, Data Guard	`skills/architecture/`
ERD, data modeling, partitioning, tablespaces	`skills/design/`
Liquibase, Flyway, online operations, EBR, utPLSQL, git for SQL	`skills/devops/`
Advanced Queuing, DBMS_SCHEDULER, materialized views, DBLinks, APEX	`skills/features/`
Migrating from PostgreSQL, MySQL, SQL Server, MongoDB, Snowflake, Redshift, etc.	`skills/migrations/`
Alert log, ADR, adrci, space, top SQL, health checks	`skills/monitoring/`
ORDS, REST APIs, OAuth2, AutoREST, PL/SQL gateway	`skills/ords/`
AWR, ASH, explain plan, indexes, optimizer stats, wait events, memory	`skills/performance/`
Packages, cursors, collections, error handling, unit testing, debugging	`skills/plsql/`
Privileges, VPD, TDE, encryption, auditing, network security	`skills/security/`
SQL patterns, window functions, CTEs, dynamic SQL, injection	`skills/sql-dev/`
SQLcl commands, scripting, Liquibase CLI, MCP server, CI/CD	`skills/sqlcl/`
Oracle Container Registry images, container pull commands, tags	`skills/containers/`

用户咨询内容…	阅读路径
备份、恢复、RMAN、重做/撤销日志、用户	`skills/admin/`
JDBC、Python、Node.js、.NET、Go驱动；连接池、JSON、XML、空间数据、全文检索、事务、属性图	`skills/appdev/`
RAC、CDB/PDB、Exadata、内存数据库、OCI、ATP/ADW、Data Guard	`skills/architecture/`
ERD、数据建模、分区、表空间	`skills/design/`
Liquibase、Flyway、在线操作、EBR、utPLSQL、SQL版本控制（git）	`skills/devops/`
高级队列（Advanced Queuing）、DBMS_SCHEDULER、物化视图、数据库链接（DBLinks）、APEX	`skills/features/`
从PostgreSQL、MySQL、SQL Server、MongoDB、Snowflake、Redshift等迁移至Oracle	`skills/migrations/`
告警日志、ADR、adrci、空间管理、Top SQL、健康检查	`skills/monitoring/`
ORDS、REST API、OAuth2、AutoREST、PL/SQL网关	`skills/ords/`
AWR、ASH、执行计划、索引、优化器统计信息、等待事件、内存调优	`skills/performance/`
包、游标、集合、错误处理、单元测试、调试	`skills/plsql/`
权限、VPD、TDE、加密、审计、网络安全	`skills/security/`
SQL模式、窗口函数、CTE、动态SQL、注入防护	`skills/sql-dev/`
SQLcl命令、脚本、Liquibase CLI、MCP服务器、CI/CD	`skills/sqlcl/`
Oracle容器注册表镜像、容器拉取命令、标签	`skills/containers/`

Skills Directory

技能目录

skills/
├── admin/          (5)  backup-recovery, rman-basics, undo-management, redo-log-management, user-management
├── appdev/         (14) connection-pooling, json, xml, spatial, oracle-text, transactions, locking,
│                        sequences, sql-property-graph, python-oracledb, java-oracle-jdbc,
│                        nodejs-oracledb, dotnet-oracle, golang-oracle
├── architecture/   (6)  rac-concepts, multitenant, oracle-cloud-oci, exadata-features,
│                        inmemory-column-store, dataguard
├── containers/     (21) enterprise, free, adb-free, ords, rac, sqlcl, instantclient, private-ai,
│                        graph-quickstart, cman, gsm, operator, observability-exporter,
│                        microtx-ee-*, otmm, enterprise_ru, gsm_ru, rac_ru,
│                        container-selection-matrix, SKILLS.md
├── design/         (4)  erd-design, data-modeling, partitioning-strategy, tablespace-design
├── devops/         (5)  schema-migrations, online-operations, edition-based-redefinition,
│                        database-testing, version-control-sql
├── features/       (6)  advanced-queuing, dbms-scheduler, virtual-columns,
│                        materialized-views, database-links, oracle-apex
├── migrations/     (14) migrate-{postgres,mysql,sqlserver,db2,mongodb,snowflake,
│                        redshift,sqlite,teradata,sybase}-to-oracle,
│                        oracle-migration-tools, migration-assessment,
│                        migration-data-validation, migration-cutover-strategy
├── monitoring/     (5)  alert-log-analysis, adrci-usage, health-monitor,
│                        space-management, top-sql-queries
├── ords/           (10) ords-architecture, ords-installation, ords-auto-rest,
│                        ords-rest-api-design, ords-authentication, ords-pl-sql-gateway,
│                        ords-file-upload-download, ords-metadata-catalog,
│                        ords-security, ords-monitoring
├── performance/    (7)  awr-reports, ash-analysis, explain-plan, index-strategy,
│                        optimizer-stats, wait-events, memory-tuning
├── plsql/          (12) plsql-package-design, plsql-error-handling, plsql-performance,
│                        plsql-collections, plsql-cursors, plsql-dynamic-sql,
│                        plsql-security, plsql-debugging, plsql-unit-testing,
│                        plsql-patterns, plsql-compiler-options, plsql-code-quality
├── security/       (6)  privilege-management, row-level-security, data-masking,
│                        auditing, encryption, network-security
├── sql-dev/        (6)  sql-best-practices, sql-tuning, sql-injection-avoidance,
│                        pl-sql-best-practices, sql-patterns, dynamic-sql
└── sqlcl/          (8)  sqlcl-basics, sqlcl-scripting, sqlcl-liquibase, sqlcl-formatting,
                         sqlcl-ddl-generation, sqlcl-data-loading, sqlcl-cicd, sqlcl-mcp-server

skills/
├── admin/          (5)  backup-recovery, rman-basics, undo-management, redo-log-management, user-management
├── appdev/         (14) connection-pooling, json, xml, spatial, oracle-text, transactions, locking,
│                        sequences, sql-property-graph, python-oracledb, java-oracle-jdbc,
│                        nodejs-oracledb, dotnet-oracle, golang-oracle
├── architecture/   (6)  rac-concepts, multitenant, oracle-cloud-oci, exadata-features,
│                        inmemory-column-store, dataguard
├── containers/     (21) enterprise, free, adb-free, ords, rac, sqlcl, instantclient, private-ai,
│                        graph-quickstart, cman, gsm, operator, observability-exporter,
│                        microtx-ee-*, otmm, enterprise_ru, gsm_ru, rac_ru,
│                        container-selection-matrix, SKILLS.md
├── design/         (4)  erd-design, data-modeling, partitioning-strategy, tablespace-design
├── devops/         (5)  schema-migrations, online-operations, edition-based-redefinition,
│                        database-testing, version-control-sql
├── features/       (6)  advanced-queuing, dbms-scheduler, virtual-columns,
│                        materialized-views, database-links, oracle-apex
├── migrations/     (14) migrate-{postgres,mysql,sqlserver,db2,mongodb,snowflake,
│                        redshift,sqlite,teradata,sybase}-to-oracle,
│                        oracle-migration-tools, migration-assessment,
│                        migration-data-validation, migration-cutover-strategy
├── monitoring/     (5)  alert-log-analysis, adrci-usage, health-monitor,
│                        space-management, top-sql-queries
├── ords/           (10) ords-architecture, ords-installation, ords-auto-rest,
│                        ords-rest-api-design, ords-authentication, ords-pl-sql-gateway,
│                        ords-file-upload-download, ords-metadata-catalog,
│                        ords-security, ords-monitoring
├── performance/    (7)  awr-reports, ash-analysis, explain-plan, index-strategy,
│                        optimizer-stats, wait-events, memory-tuning
├── plsql/          (12) plsql-package-design, plsql-error-handling, plsql-performance,
│                        plsql-collections, plsql-cursors, plsql-dynamic-sql,
│                        plsql-security, plsql-debugging, plsql-unit-testing,
│                        plsql-patterns, plsql-compiler-options, plsql-code-quality
├── security/       (6)  privilege-management, row-level-security, data-masking,
│                        auditing, encryption, network-security
├── sql-dev/        (6)  sql-best-practices, sql-tuning, sql-injection-avoidance,
│                        pl-sql-best-practices, sql-patterns, dynamic-sql
└── sqlcl/          (8)  sqlcl-basics, sqlcl-scripting, sqlcl-liquibase, sqlcl-formatting,
                         sqlcl-ddl-generation, sqlcl-data-loading, sqlcl-cicd, sqlcl-mcp-server

Key Starting Points

核心入门指南

skills/sqlcl/sqlcl-mcp-server.md
— connecting Claude/AI assistants to Oracle via SQLcl MCP server

skills/migrations/migration-assessment.md
— start here for any migration project

skills/performance/explain-plan.md
— foundation for all SQL performance work
skills/plsql/plsql-package-design.md
— foundation for PL/SQL architecture
skills/devops/schema-migrations.md
— Liquibase/Flyway with Oracle in CI/CD

skills/containers/container-selection-matrix.md
— quick decision matrix for OCR images

skills/sqlcl/sqlcl-mcp-server.md
— 通过SQLcl MCP服务器连接Claude/AI助手与Oracle数据库

skills/migrations/migration-assessment.md
— 任何迁移项目的入门指南

skills/performance/explain-plan.md
— 所有SQL性能优化工作的基础指南
skills/plsql/plsql-package-design.md
— PL/SQL架构设计的基础指南
skills/devops/schema-migrations.md
— CI/CD环境中结合Oracle使用Liquibase/Flyway的指南

skills/containers/container-selection-matrix.md
— OCR镜像快速选择决策矩阵

Oracle Version Notes

Oracle版本说明

All skills use Oracle 19c as the baseline unless stated otherwise.
Features marked 21c, 23c, 23ai apply to Oracle 26ai — 19c-compatible alternatives are provided.

除非另有说明，所有技能指南均以Oracle 19c为基准版本。
标记为21c、23c、23ai的特性同样适用于Oracle 26ai——同时提供了兼容19c的替代方案。