Feature — SQL Tuning

# Find the SQL that's killing your database.

TuneVault ranks your top SQL consumers by CPU, elapsed time, and buffer gets — then uses AI to recommend indexes, rewrites, and plan fixes. No guesswork. No AWR reports to decipher.

View Sample Report → All Features
Top 10 SQL ranked per analysis
5 ranking dimensions
AI index & rewrite recommendations
V$SQL live cursor stats
What it surfaces

## 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.

AI-Powered Fixes

## 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.

AI recommendation sample

    -- 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

How it works

## 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.

01

#### Connect

Select your Oracle connection — Direct TCP or HTTP proxy

02

#### Analyze

TuneVault queries V$SQL for top consumers by 5 metrics

03

#### Plan Extract

Execution plans pulled from V$SQL_PLAN with cost breakdown

04

#### AI Fix

AI generates index DDL, query rewrites, and plan stability fixes

Compatibility

## 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.

## Stop guessing which SQL to fix.

See a real SQL tuning analysis — anonymized data, no sign-up, no credentials needed.

View Sample Report → Connect Your Database →