Excessive PGA memory usage by the Wnnn Background Process
(Doc ID 2685491.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
Each Wnnn Background Process is consuming around 140MB of pga ( can be more as well) and holding hundreds of opened cursors causing memory usage of instance to go high.
The sessions appear to remain open (session state ACTIVE), holding these cursors.
The Wnnn and SMCo processes appear to remain active for weeks at a time, as we can seen by logon time.
Example pga use of one affected instance:
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