My Oracle Support Banner

V$SQL_MONITOR View Does not Return Rows When CPU_COUNT=1024 (Doc ID 1959699.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 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

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