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

Last updated on JUNE 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms