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