My Oracle Support Banner

Top SQL Statement Missing from DBA_HIST_SQLSTAT View (Doc ID 1424839.1)

Last updated on JULY 22, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When examining V$SQL during a given hour, a certain SQL statement is consuming a very high amount of resources, so much so that it has dominated the resources provided to the instance for the majority of the hour.  Yet later on, when trying to examine the performance details for that particular hour within DBA_HIST_SQLSTAT, there is no record of it.  You may even locate SQL_ID and SQL_PLAN_HASH_VALUE information in view DBA_HIST_ACTIVE_SESS_HISTORY but cannot join them to their relevant columns within DBA_HIST_SQLSTAT for that hour.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.