# 🔭 Performance Advisor Oracle Built-in Intelligence

ADDM findings, SQL Tuning Advisor output, and ranked recommendations — surfaced, translated, and prioritised by TuneVault. Requires Enterprise Edition + Diagnostics Pack.

Connection:
🔭
Select a connection to begin
Choose an Oracle connection above, then click Fetch from Oracle to load ADDM findings and SQL Tuning Advisor output.
Querying Oracle advisor views…
Running 4 queries against DBA_ADDM_TASKS, DBA_ADVISOR_FINDINGS, DBA_ADVISOR_RECOMMENDATIONS, DBA_ADVISOR_TASKS…
🔒 Oracle Diagnostics Pack required
Enterprise Edition + Oracle Diagnostics Pack license required to access ADDM views.
TuneVault still monitors your database through wait events, Top SQL, blocking sessions, and ASH-based active session analysis — available on the Performance tab.
⚠ Oracle connection failed
—
ℹ️
Oracle ADDM ran but found no significant load

ADDM analysed the recent AWR snapshots and reported no significant database activity. This usually means one of three things:

- Light workload — the snapshot window captured an idle or low-traffic period.
- Short AWR interval — if your AWR snapshot interval is under 30 minutes, individual windows may not capture enough activity to trigger findings.
- Genuinely healthy idle period — the database was running well during this window.

TuneVault is still monitoring wait events, top SQL, and ASH directly. For live signal, see Performance › Active Sessions.

You can also manually trigger a new ADDM analysis — click Fetch from Oracle during a busier window.

🔬 Diagnostic: Why is ADDM empty?
Running 4 Oracle diagnostic probes…
🤖 AI Summary
—
🔥 Active Findings 0
ADDM findings sorted by impact % of total DB time
No findings in the last 7 days.

| Type | Impact | Finding | Task
--- | --- | --- | --- | ---

⚡ Recommended Actions 0
ADDM recommendations sorted by performance benefit %
No recommendations for the last 7 days.

| Type | Benefit | Recommended Action
--- | --- | --- | ---

📅 ADDM Snapshot History 0
Recent ADDM analysis tasks (last 7 days), newest first
No ADDM tasks found in the last 7 days.
🧮 SQL Tuning Advisor 0
Automatic SQL Tuning Advisor tasks (last 7 days)
No SQL Tuning Advisor tasks found in the last 7 days.
Query Source
SQL Query