The SQL you need to fix — ranked by impact
TuneVault queries V$SQL and V$SQL_PLAN to identify the highest-cost statements in your database, then ranks them across five dimensions so you fix what matters most.
Elapsed Time Ranking
Top SQL ordered by total elapsed time — the queries that are consuming the most wall-clock time across all executions.
CPU Hogs
Statements burning the most CPU. Identifies parse-heavy SQL, inefficient PL/SQL, and compute-bound queries starving other sessions.
Buffer Gets (Logical I/O)
High buffer-get SQL reads the same blocks repeatedly. Usually a missing index or bad join order — the most actionable metric for tuning.
Disk Reads (Physical I/O)
Queries forcing physical reads bypass the buffer cache. Surfaces candidates for partition pruning or index-organized tables.
Executions & Parse Ratio
Statements parsed more than executed waste shared pool memory. Flags literal SQL that should use bind variables.
Full Table Scan Detection
Identifies large-table full scans in execution plans — candidates for indexes, partitioning, or query rewrites.
Not just diagnosis — actionable recommendations
For each problem SQL, TuneVault generates specific fix recommendations: CREATE INDEX statements, query rewrites, hint suggestions, and plan stability fixes.
Index Recommendations
AI analyzes predicates, join conditions, and access paths to suggest CREATE INDEX DDL — with column order and inclusion columns.
Query Rewrites
Suggests alternative SQL that achieves the same result with a better plan — subquery flattening, EXISTS conversion, analytic function substitution.
Plan Analysis
Execution plan summary with cost breakdown, cardinality estimates, and identified anti-patterns like nested loop on large rowsets.
-- SQL_ID: 4qx7z8n3k2p1f | Elapsed: 847s | Buffer Gets: 14.2M -- Diagnosis: Full table scan on ORDERS (12M rows) -- WHERE clause filters on customer_id + order_date but no covering index CREATE INDEX orders_cust_date_idx ON orders (customer_id, order_date) TABLESPACE idx_ts ONLINE NOLOGGING; -- Expected improvement: ~97% buffer get reduction -- Plan change: FULL → INDEX RANGE SCAN + TABLE ACCESS BY ROWID
From V$SQL to actionable fix in 30 seconds
Select a connection, click Analyze, and TuneVault handles the rest — querying live cursor stats, ranking SQL, extracting plans, and generating AI recommendations.
Connect
Select your Oracle connection — Direct TCP or HTTP proxy
Analyze
TuneVault queries V$SQL for top consumers by 5 metrics
Plan Extract
Execution plans pulled from V$SQL_PLAN with cost breakdown
AI Fix
AI generates index DDL, query rewrites, and plan stability fixes
Works on every Oracle edition
V$SQL analysis works on SE, SE2, and EE. DBMS_SQLTUNE advisor integration is available on Enterprise Edition with the Tuning Pack.
SE / SE2 / EE
Top SQL ranking, execution plan analysis, AI index & rewrite recommendations, full table scan detection, parse ratio analysis.
EE + Tuning Pack
Everything above plus DBMS_SQLTUNE advisor integration — automatic SQL Tuning Advisor tasks and SQL Profile recommendations.