skills.rest
MassimilianoPili
MassimilianoPiliCOMMUNITY
Explore all skills by this author →
GitHub

dba-oracle

Manage Oracle 19c+ database design, PL/SQL development, and performance tuning.

Updated Mar 7, 2026
Search Tags:#oracle#performance tuning#dba#ash#database administration#pl/sql#awr
One-click install
npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-oracle
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba-oracle
Source: https://github.com/MassimilianoPili/agent-framework/tree/main/.claude/agents/dba-oracle
Command: npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-oracle

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines complex Oracle database tasks, from initial design and PL/SQL development to performance tuning and high-availability configuration, ensuring robust and efficient database operations.

Core Features & Use Cases

  • Database Design & Development: Create schemas, write PL/SQL packages, procedures, and functions adhering to best practices.
  • Performance Tuning: Analyze AWR/ASH reports, optimize queries using execution plans, and implement indexing strategies.
  • High Availability & Disaster Recovery: Configure Data Guard, manage tablespaces, and implement backup/recovery solutions with RMAN.
  • Use Case: Optimize a slow-running reporting query by analyzing its execution plan, creating a function-based index, and rewriting the query with appropriate hints.

Quick Start

Use the dba-oracle skill to create a PL/SQL package for managing user audit trails.

Frequently Asked Questions about dba-oracle

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze AWR and ASH reports to tune Oracle database performance?▼

Oracle performance tuning analyzes AWR and ASH reports to identify bottlenecks, reviews execution plans, and applies indexing strategies or query hints to optimize slow-running queries. This ensures efficient database operations by adhering to Oracle best practices.

What's the best way to configure Data Guard and RMAN backups for Oracle 19c?▼

Configuring Data Guard and RMAN backups for Oracle 19c involves setting up high-availability configurations and implementing disaster recovery solutions. This approach manages tablespaces effectively and ensures robust database operations through structured backup and recovery processes.

How do I create PL/SQL packages for database administration tasks?▼

Creating PL/SQL packages for database administration involves writing procedures and functions that adhere to Oracle best practices. This process manages tasks like user audit trails by leveraging schema creation and robust PL/SQL development standards.

When do I need to use function-based indexes in Oracle query optimization?▼

Function-based indexes in Oracle query optimization are needed when optimizing slow-running reporting queries. By analyzing execution plans and rewriting queries with appropriate hints, you can implement indexing strategies that significantly improve database performance.

Does this approach support schema creation and tablespace management for Oracle 19c+?▼

Yes, managing Oracle 19c+ databases supports schema creation, tablespace management, and storage configuration. It ensures robust database design by adhering to Oracle best practices for partitioning, indexing, and overall storage structuring.

Why does partitioning and storage configuration matter in Oracle database design?▼

Partitioning and storage configuration matter in Oracle database design because they ensure efficient data retrieval and robust operations. Adhering to Oracle best practices for these elements optimizes performance tuning and maintains high-availability configurations.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
wfukatsuwfukatsu
12

migrate-oracle-sp-trigger-to-scalardb

Convert Oracle PL/SQL stored procedures and triggers to ScalarDB Java code.

Community
Advanced
carlopezzutocarlopezzuto
3

prometheus-configuration

Configure Prometheus scrape configurations, recording rules, and alerting for Kubernetes and Docker.

Community
Advanced
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-health

Audit Cloud SQL for PostgreSQL instance health and performance bottlenecks.

Official
Intermediate