GV$SQL_MONITOR Queries and SQLMON Generation Very Slow after Upgrade to 19c
(Doc ID 2792268.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
After upgrading to 19.10, this query is slow (takes almost an hour):
select * from gv$sql_monitor where username='<user>' and status like '%EX%'
The query without the predicate for STATUS runs without issue.
select * from gv$sql_monitor where username='<user>'
Upgrade to 19c.
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