oracle-dba-advanced-featureslisted

USE THIS SKILL WHENEVER the user mentions Oracle Advanced Compression / OLTP / Advanced Row compression / ROW STORE COMPRESS ADVANCED, Hybrid Columnar Compression (HCC) / COLUMN STORE COMPRESS FOR QUERY|ARCHIVE / Exadata-qualified compression, Database In-Memory / INMEMORY / IM column store / INMEMORY_SIZE / V$IM_SEGMENTS / MEMCOMPRESS, Partitioning implementation / RANGE|LIST|HASH|INTERVAL|composite / partition add-drop- split-merge / heap-to-partitioned conversion / partitioning strategy, Oracle Sharding / GDSCTL / GSM / shard director / shardcatalog / sharded & duplicated tables / chunks, or Result Cache / RESULT_CACHE_MODE / RESULT_CACHE_MAX_SIZE / DBMS_RESULT_CACHE — EVEN IF they do not name the specific task. Covers (T1) compression/HCC/In-Memory/partition/ Result-Cache/sharding INVENTORY & advisor reports; (T2, --dry-run default) OLTP-compress enable/disable, HCC attribute set, In-Memory per-object enable/disable, partition add/ drop on an already-partitioned table, and Result Cache configure; and (T3,
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · AI & Automation · score 62

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

# Oracle DBA - Advanced Features Compression (Basic/OLTP/Advanced Row and HCC), Database In-Memory, Partitioning, Oracle Sharding, and server Result Cache for Oracle **19c and 23ai** (Enterprise Edition; single-instance and Data Guard; on-prem). One mechanism by design for in-DB work plus host-level runbooks for Sharding: - **In-DB** work (compression/In-Memory/partition/Result-Cache DDL and all reports) runs through the **SQLcl MCP** saved connection `dba_ai_conn` (wallet-backed) → `sql/*.sql`, driven by the `scripts/*.sh` / `*.ps1` wrappers that enforce the dry-run default. - **Host** work for **Sharding** (GDSCTL / `gsm` / `srvctl`, shard-director provisioning, chunk MOVE/SPLIT) **cannot** go through SQLcl MCP (restrict level 4) and is **T3 runbook-only**; only the read-only catalog INSPECTION runs in-DB via `dba_ai_conn`. Everything self-executing is **T1 (observe)** or **T2 (reversible, dry-run-default)**. Every **bulk segment rewrite**, **In-Memory pool sizing / instance restart**, **heap→partitioned conversion**, **partitioning strategy design**, and **all of Sharding setup/management** is **T3** and lives only in `references/runbooks.md` — it prints commands for a human and never self-executes. ## Scope & risk map Maps every task in section 21 ("Advanced Features") of `oracle_dba_task_level_map.md`. The T2 wrappers deliberately STOP at the safe/reversible boundary and point to the T3 runbook for the structural variant. | Task (map) | Level | Tier | Mecha