playbooks

home / skills / partme-ai / full-stack-skills / oracle

oracle skill

/skills/oracle

This skill helps you master Oracle databases, SQL, and PL/SQL with guided best practices for writing, optimizing, and administering Oracle systems.

npx playbooks add skill partme-ai/full-stack-skills --skill oracle

Review the files below or copy the command above to add this skill to your agents.

Files (2)
SKILL.md
648 B
---
name: oracle
description: Provides comprehensive guidance for Oracle database including SQL, PL/SQL, database administration, and Oracle-specific features. Use when the user asks about Oracle, needs to write Oracle SQL, work with PL/SQL, or manage Oracle databases.
license: Complete terms in LICENSE.txt
---

## When to use this skill

Use this skill whenever the user wants to:
- [待完善：根据具体工具添加使用场景]

## How to use this skill

[待完善：根据具体工具添加使用指南]

## Best Practices

[待完善：根据具体工具添加最佳实践]

## Keywords

[待完善：根据具体工具添加关键词]

Overview

This skill provides comprehensive guidance for Oracle Database, covering SQL, PL/SQL, performance tuning, backup and recovery, security, and Oracle-specific features. It helps developers and DBAs write correct queries, design stored procedures, optimize execution plans, and manage Oracle instances. Use it to resolve practical problems, generate example code, and follow recommended administration procedures.

How this skill works

The skill inspects user requests to determine whether they relate to Oracle SQL, PL/SQL, administration, performance, or configuration. It returns concise, actionable answers: example queries and procedures, execution-plan analysis tips, configuration recommendations, and step-by-step admin tasks. When needed it suggests Oracle-specific syntax, recommended parameters, and diagnostic commands.

When to use it

  • Writing or optimizing Oracle SQL queries and joins
  • Developing PL/SQL packages, procedures, triggers, or functions
  • Diagnosing slow queries using EXPLAIN PLAN, AUTOTRACE, or AWR
  • Planning backups, RMAN scripts, and recovery strategies
  • Configuring security: users, roles, privileges, and auditing
  • Tuning instance parameters and storage (tablespaces, indexes)

Best practices

  • Prefer bind variables in PL/SQL and SQL to avoid hard parsing and reduce CPU
  • Use EXPLAIN PLAN and AWR/ASH reports together for accurate performance diagnosis
  • Keep schema design normalized, then denormalize only for measured performance needs
  • Test RMAN backups and recovery procedures regularly in a staging environment
  • Apply least-privilege principle for user roles and enable auditing for sensitive operations
  • Use automatic statistics gathering but validate statistics after major data loads

Example use cases

  • Refactor a slow SELECT by adding appropriate indexes and rewriting subqueries
  • Write a PL/SQL procedure to batch-process records with exception handling and logging
  • Create an RMAN script to perform incremental backups and verify recoverability
  • Explain and tune a query by interpreting EXPLAIN PLAN output and recommending hints
  • Design a maintenance plan: tablespace growth monitoring, index rebuild schedules, and stats collection

FAQ

Can you convert generic SQL to Oracle-specific SQL?

Yes. I translate ANSI/other-dialect SQL to Oracle syntax, recommend Oracle functions, and suggest optimizations like analytic functions or MERGE statements.

Do you provide production-ready RMAN scripts and config changes?

I provide tested patterns and examples, plus explanations of risk and required adjustments, but always validate scripts in your environment before production use.