V$SQL_MONITOR View Does not Return Rows When CPU_COUNT=1024
(Doc ID 1959699.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
On a system with CPU_COUNT=1024 the view V$SQL_MONITOR is always empty. (And there is no error message).
On a system with lower CPU_COUNT (for example, 512) and on the same platform and same RDBMS version - the view V$SQL_MONITOR is always populated as documented.
As a result of this, it's not possible to use the SQL monitor feature.
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