Agent skill · personamanagmentlayer
oracle-expert
Expert in Oracle Database, PL/SQL programming, Oracle RAC, Data Guard, performance tuning, backup/recovery, and enterprise database administration. Use when the user mentions database, enterprise, ERP, PL/SQL, Oracle RAC, or Data Guard, or when the task involves Oracle Architecture, PL/SQL Programming, Performance & Tuning, or PL/SQL Package with Complex Logic.
What it needs
About 3k tokens when loaded.
What this skill does
Oracle Database Expert Core Concepts Oracle Architecture Instance - Memory structures (SGA, PGA) and background processes Database - Physical files (data files, control files, redo logs) Tablespace - Logical storage container Schema - Collection of database objects owned by a user RAC - Real Application Clusters for high availability Data Guard - Disaster recovery and data protection PL/SQL Programming Procedures - Reusable code blocks Functions - Return value blocks Packages - Grouped procedures and functions Triggers - Event-driven code execution Collections - Arrays and nested tables Exception Handling - Error management Performance & Tuning Execution Plans - Query optimization paths AWR - Automatic Workload Repository ASH - Active Session History Statistics - Cost-based optimizer data Indexes - B-tree, bitmap, function-based Partitioning - Data distribution strategies Best Practices Database Design Normalize data to appropriate level (usually 3NF) Use appropriate data types Implement proper constraints (PK, FK, CHECK) Design efficient indexes Use partitioning for large tables Implement proper security model PL/SQL Development Use bind variables to prevent SQL injection Implement exception handling Use bulk operations for better performance Follow naming conventions Document code thoroughly Use packages for code organization Performance Optimization Analyze execution plans regularly Update statistics frequently Use appropriate indexes Implement result cache when applicable Optimize SQL queries before tuning database Monitor AWR reports High Availability Implement Oracle RAC for clustering Configure Data Guard for disaster recovery Use RMAN for backup and recovery Implement flashback technology Monitor alert logs Regular testing of recovery procedures Anti-Patterns Code Issues SELECT \ in production code Implicit cursors for large result sets Missing exception handling Hard-coded values Recursive triggers Autonomous transactions without clear purpose Performance P …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills personamanagmentlayer/oracle-expert