oracle-dba-performance-tuning-diagnosticslisted

USE THIS SKILL WHENEVER the user mentions database is slow / hung / high CPU, performance tuning, SQL tuning, execution plan / explain plan, AWR / ADDM / ASH, SQL Tuning Advisor, SQL profile, SQL plan baseline (SPM), SPA / SQL Performance Analyzer, optimizer statistics / DBMS_STATS / histograms / data skew, top SQL / resource consumers, blocking locks / runaway / kill session, wait event / wait class analysis, latch / mutex / "cursor: pin S" / "cache buffers chains" contention, SGA / PGA / memory tuning, optimizer parameters (optimizer_*, cursor_sharing, OFE), parallel execution / PX downgrades, real-time SQL monitoring, Database Replay (RAT / workload capture & replay), partitioning strategy, or any of the symptoms/errors ORA-04031 (shared pool), ORA-04030 (PGA), ORA-00060 (deadlock), ORA-01555 (snapshot too old), "log file sync", "db file sequential/scattered read", "library cache" / "row cache" lock — EVEN IF they do not name a specific task or tool. Covers L1 triage, L1/L2 read-only diagnostics (AWR/ADDM/
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · API & Backend · score 62

Install: claude install-skill Shreyas70773/oracle-dba-agentic-skills

# Oracle DBA - Performance Tuning & Diagnostics Diagnose and (within safe tiers) remediate Oracle performance problems on Oracle 19c and 23ai (EE; single-instance and Data Guard; on-prem). Everything that self-executes is **T1 (observe, read-only)** or **T2 (reversible, dry-run-default)**. Every change that alters an execution plan, an optimizer/instance parameter, memory sizing, or object structure is **T3** and lives only in `references/runbooks.md` — it PRINTS commands for a human operator and never self-executes. Routing: in-DB SQL/PLSQL runs as `sql/*.sql` through the SQLcl MCP `run-sql` on the saved connection `dba_ai_conn` (mechanism `sqlcl-mcp`). Host-side report drivers and gated mutators run as behaviour-equivalent `.sh`/`.ps1` (mechanism `script`). T3 remediation requires `require_approval_token` and a runbook. **When in doubt, runbook.** ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | Performance issue triage / first response | L1 | T1 | `scripts/checks/perf_triage.sh` / `.ps1` + `sql/perf_triage.sql` | yes — read-only snapshot; surfaces findings, never acts | | Scheduled optimizer stats gathering (autotask enable/disable) | L1 | T2 | `scripts/autotask_stats_set.sh` / `.ps1` + `sql/autotask_stats_set.sql` (`sql/autotask_stats_status.sql` audit) | yes — noop if already in desired state; flip via opposite `--state` | | Manual sta