Module: PERFPerformanceSeverity: CRITICAL
High CPU / Elapsed Time SQL Execution Plan Regression (AWR / ASH)
Enterprise troubleshooting playbook from the OAG ADK 5.0 knowledge base. Designed for Oracle Apps DBAs, techno-functional consultants, and support teams.
Recognized Error Signatures & Log Keywords
top sql regressionexecution plan regressionhigh cpu sqldba_hist_sqlstat elapsed time spikecartesian join detected
Root Cause Analysis
SQL statement {sqlId} flipped execution plan from {oldPlan} to {newPlan}, causing 10x elapsed time spike.
Diagnostic SQL Queries (Read-Only)
CHECK_AWR_SQLSTATQuery DBA_HIST_SQLSTAT for elapsed time per execution spikes across snapshots
SELECT sql_id, plan_hash_value, executions_delta,
elapsed_time_delta / NULLIF(executions_delta, 0) AS avg_elapsed_time
FROM dba_hist_sqlstat
WHERE sql_id = :sqlId
ORDER BY snap_id DESCRemediation Mode: MANUAL_UI
Verification Query
SELECT count(*) FROM dba_sql_plan_baselines WHERE origin = 'MANUAL-LOAD' AND signature = :sqlSignatureExecute This Fix Safely with OAG AI Consultant
OAG AI Consultant runs directly on your Windows desktop behind your corporate firewall, connecting to your Oracle TNS tier with zero cloud data exposure.