From tablespace pressure to SQL plan regressions — TuneVault runs comprehensive diagnostics across every layer of your Oracle stack and surfaces exactly what needs attention.
Tablespace utilization, autoextend health, segment growth patterns, temp space pressure, and undo configuration.
Percent-full flag with warn/crit thresholds per tablespace.
Identifies datafiles with autoextend off when tablespace is filling.
Top growing segments and projected days-to-full.
Current temp usage and sort-to-disk events.
UNDO_RETENTION setting vs. peak active transaction duration.
SYSAUX occupant inventory and top consumers.
Top wait events, latch contention, active session history (ASH), and resource saturation indicators.
Session wait events ranked by total wait time.
CPU vs. wait time breakdown from recent workload.
Top latches with sleep ratios and wait counts.
Logical vs. physical read efficiency.
Datafile I/O hotspots and response time outliers.
Library cache hit rate, parse-to-execute ratio.
Worst-performing SQL by elapsed time, CPU, and logical I/O. Full-table scan detection, cartesian join flags, and index suggestion.
Top 5 high-elapsed SQL with execution count and plan info.
Large FTS candidates with row count and missing index hints.
Plans containing MERGE JOIN CARTESIAN operations.
Statements with parse count > executions (unshared cursors).
Unused or rarely-used indexes that add DML overhead.
Tuning task results for top workload SQL (EE only).
Privileged user inventory, default passwords, audit trail health, role proliferation, and public grants.
All users with DBA role or ANY system privilege.
Oracle-supplied accounts that retain default credentials.
Audit trail enabled, trail size, and cleanup schedule.
Sensitive privileges granted to PUBLIC role.
UNLIMITED password lifetime and no complexity check profiles.
Custom roles with excessive privilege counts.
Backup job success rate, archive log gap, last successful full backup age, and RMAN catalog status.
Hours since last successful full or level-0 incremental backup.
Failed vs. completed backup jobs over the last 7 days.
Archivelog volume per hour and retention gap.
Fast Recovery Area space used vs. allocated.
Recovery catalog accessible and metadata current.
Backup window growth over 30 days — catches silent expansion.
SGA component sizes, shared pool fragmentation, PGA target adherence, and overallocation indicators.
Shared pool, buffer cache, redo buffer sizes vs. totals.
Free chunk count and largest contiguous free chunk ratio.
Actual PGA usage vs. PGA_AGGREGATE_TARGET.
DBMS_ADVISOR memory recommendations for SGA/PGA tuning.
Large pool usage and ORA-4031 risk indicator.
Java pool used vs. allocated (EBS and Java-heavy workloads).
Active session inventory, blocking lock chains, long-running queries, and deadlock history.
Lock chain depth, blocked session count, waiter SQL.
Sessions with estimated completion time and percent done.
ORA-00060 events in alert log over rolling 7 days.
Active vs. max sessions and processes parameter headroom.
Unusable indexes, stale statistics, invisible indexes, and index fragmentation candidates.
Indexes with UNUSABLE status requiring rebuild.
Tables with row churn > 10% since last analyze.
INVISIBLE indexes not visible to the optimizer.
Indexes with BLKS_GETS_PER_ACCESS ratio indicating need for coalesce.
Automatic Diagnostic Database Monitor findings, workload repository snapshots, and ADDM task recommendations.
Most impactful ADDM task recommendations from recent period.
AWR top SQL by DB time contribution from last snapshot pair.
Top segments by physical reads from AWR.
Hours since last successful AWR snapshot — alerts on collection gaps.
Auto optimizer stats tasks, SQL Tuning Advisor status, invalid objects, network latency, key parameter review, and OS-level resource indicators.
DBMS_STATS auto gather job status and last run time.
Automatic STA task completion, recommendations count.
Compiled invalid procedures, packages, triggers, views.
Foreign key and check constraints left disabled after load.
35 parameters reviewed: memory, security, undo, performance groups.
CPU, memory, swap, disk I/O signals from V$ views (proxy mode).
51 dedicated checks activate automatically when TuneVault detects an EBS environment. Non-EBS databases see none of these.
APPS.DUAL — if it resolves, EBS checks activate in your report. No flag to set, no separate connection.
Manager status, load, request backlogs, and long-running requests.
Workflow agent status, error log depth, notification backlog, and purgeable items.
Sign-on audit anomalies, sysadmin users, and password policy compliance.
ADOP session health, OACore services, Forms availability, and functional observability.
Load the demo to see a real Oracle diagnostic report — no sign-up, no credentials.