Excessive PGA memory usage by the Wnnn Background Process (Doc ID 2685491.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

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:

Changes

Cause

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