# Tune

AI-powered tuning, ADDM diagnostics, patch advisor, and performance analysis for Oracle databases.

🔥
Performance Lab
Top SQL killers, wait event analysis, blocking sessions, and hot segment detection. Live data from V$SQL and V$SESSION.
Open →
🧠
ADDM Analysis
Automatic Database Diagnostic Monitor — AWR-based root-cause analysis with AI commentary on the top performance findings.
Open →
🩹
Patch Advisor
CPU/PSU gap analysis — detect missing critical patches and generate an OPatch or ADOP runbook for your Oracle version.
Open →
⚡
SQL Tuning Advisor
AI-assisted SQL fix recommendations — identify high-load queries, analyze execution plans, and get concrete index or rewrite suggestions.
Open →
🗂️
SQL Access Advisor
Index, materialized view, and partitioning recommendations from Oracle's SQL Access Advisor — surfaces access path improvements from real workload.
Open →
🗜️
Segment Advisor
Space reclamation opportunities — Oracle's Segment Advisor findings for shrink and reorg candidates, plus all segments over 1 GB.
Open →
💡
Memory Advisor
Right-size SGA, PGA, and overall memory — Oracle's sizing curves show the DB-time impact at each candidate memory target.
Open →

## Space & Schema Advisors

🗃️
Compression Advisor
Find large uncompressed tables — estimated 3-5× savings with OLTP compression, 10×+ with HCC. Sorted by segment size.
Open →
📋
Index Usage Advisor
Detect unused monitored indexes and prefix-redundant indexes — reclaim space and reduce DML overhead.
Open →
💿
Space Advisor
Tablespace fullness with autoextend flags, fragmentation hotspots, and 30-day AWR growth trend per tablespace.
Open →
📊
Statistics Advisor
Tables and indexes with stale or missing optimizer statistics — ready-to-run DBMS_STATS.GATHER_TABLE_STATS commands included.
Open →
⏱️
AWR Wait Advisor
Top 10 wait events and wait class breakdown from AWR last 7 days — flags high hard-parse ratio and disk-sort spills.
Open →