oracle-dba-storagelisted

USE THIS SKILL for ANY Oracle space & storage request — tablespaces (create, add datafile, resize, bigfile), temp/undo sizing & retention, segment/table reorganization, tablespace defragmentation, ASM disk add/drop/rebalance, archive log / FRA / diag-trace / listener-log space reclamation, and segment/datafile shrink or storage-tiering (ILM/ADO) design. Invoke whenever the user mentions "out of space", ORA-01653/ORA-01654/ORA-01688/ORA-30036/ORA-39171, "tablespace full", "FRA full", "archive destination full", "shrink", "reclaim", "defrag", "rebalance", or capacity planning for storage. Follows oracle-dba-common contracts: SQLcl saved connection dba_ai_conn (wallet secrets — never plaintext), --dry-run default for all T2+ actions (--execute to act), full structured logging, and tier gating (T3 is runbook-only + human approval token). When in doubt, runbook.
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · AI & Automation · score 62

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

# Oracle DBA - Space & Storage Management Domain skill for capacity and storage operations. Loads `oracle-dba-common` first (`_common/scripts/lib.sh` / `lib.ps1`, `_common/references/conventions.md`). Max self-execute tier = **T2**. T3 is **runbook-only**. ## Scope & risk map Every task is listed with its level, tier, mechanism path, and idempotency. 15 tasks: 8 L1, 5 L2, 2 L3. | Task | Level | Tier | Mechanism (sql / script / runbook) | Idempotent? | |------|-------|------|------------------------------------|-------------| | Space & storage health report | L1 | T1 | `sql/space_overview.sql` | yes (read-only) | | Archive log status (cleanup precheck) | L1 | T1 | `sql/archivelog_status.sql` | yes (read-only) | | FRA usage report (reclaim precheck) | L1 | T1 | `sql/fra_usage.sql` | yes (read-only) | | ASM status report | L1 | T1 | `sql/asm_status.sql` via `scripts/asm_disk_manage.{sh,ps1} status` | yes (read-only) | | Reorg candidates report | L1 | T1 | `sql/reorg_candidates.sql` via `scripts/segment_reorg.{sh,ps1} candidates` | yes (read-only) | | Add datafile to tablespace | L1 | T2 | `scripts/add_datafile.{sh,ps1}` -> `sql/add_datafile.sql` | yes (tag-detected NOOP) | | Datafile / tempfile resize + autoextend | L1 | T2 | `scripts/datafile_resize.{sh,ps1}` -> `sql/datafile_resize.sql` | yes (grow-only; <=cur = NOOP) | | Temp tablespace management (addfile/autoextend/shrink/setdefault) | L1 | T2 | `scripts/temp_manage.{sh,ps1}` -> `sql/temp_manage.sql` | yes (tag/default N