Tune

Top SQL killers, wait event analysis, blocking sessions, and hot segment detection. Live data from V$SQL and V$SESSION.

Automatic Database Diagnostic Monitor — AWR-based root-cause analysis with AI commentary on the top performance findings.

CPU/PSU gap analysis — detect missing critical patches and generate an OPatch or ADOP runbook for your Oracle version.

AI-assisted SQL fix recommendations — identify high-load queries, analyze execution plans, and get concrete index or rewrite suggestions.

Index, materialized view, and partitioning recommendations from Oracle's SQL Access Advisor — surfaces access path improvements from real workload.

Space reclamation opportunities — Oracle's Segment Advisor findings for shrink and reorg candidates, plus all segments over 1 GB.

Right-size SGA, PGA, and overall memory — Oracle's sizing curves show the DB-time impact at each candidate memory target.

Find large uncompressed tables — estimated 3-5× savings with OLTP compression, 10×+ with HCC. Sorted by segment size.

Detect unused monitored indexes and prefix-redundant indexes — reclaim space and reduce DML overhead.

Tablespace fullness with autoextend flags, fragmentation hotspots, and 30-day AWR growth trend per tablespace.

Tables and indexes with stale or missing optimizer statistics — ready-to-run DBMS_STATS.GATHER_TABLE_STATS commands included.

Top 10 wait events and wait class breakdown from AWR last 7 days — flags high hard-parse ratio and disk-sort spills.