标题: Space Management Secondary Process Wnnn highly uses the physical memory [打印本页] 作者: 郑全 时间: 2021-12-7 13:46 标题: Space Management Secondary Process Wnnn highly uses the physical memory Space Management Secondary Process Wnnn highly uses the physical memory (Doc ID 2467681.1)
In this Document
Symptoms
Cause
Solution
References
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 18.3.0.0.0 [Release 11.2 to 18]
Information in this document applies to any platform.
SYMPTOMS
The Space Management Secondary Process Wnnn highly uses the physical memory.
As per the OS command "smem", it is obvious that there are several databases running on the same server box. Each instance has multiple space secondary. The usage of a single secondary is around 270 MB which should not be considered to be high. This does not qualify to be considered as a memory leak as this space advisor feature is normally memory expensive one.
SOLUTION
First of all, the Space Management Secondary Process is designed to perform various background space management tasks, including proactive space allocation and space reclamation. These tasks could be inadequate if performed on several databases on the same server when this server box does not have considerably big physical memory.
Wnnn secondary processes perform work on behalf of Space Management and on behalf of the Oracle In-Memory Option.
- Wnnn processes are secondary processes dynamically spawned by SMCO to perform space management tasks in the background. These tasks include preallocating space into locally managed tablespace and SecureFiles segments based on space usage growth analysis, and reclaiming space from dropped segments. After being started, the secondary acts as an autonomous agent. After it finishes task execution, it automatically picks up another task from the queue. The process terminates itself after being idle for a long time.
- Wnnn processes execute in-memory populate and in-memory repopulate tasks for population or repopulation of in-memory enabled objects. For in-memory, both the IMCO background process and foreground processes will utilize Wnnn secondary for population and repopulation. Wnnn processes are utilized by the IMCO background process for prepopulation of in memory enabled objects with priority LOW/MEDIUM/HIGH/CRITICAL, and for repopulation of in-memory objects. In-memory populate and repopulate tasks running on Wnnn secondary are also initiated from foreground processes in response to queries and DMLs that reference in-memory enabled objects.
If that is the case, then it may be good going for one of the following approaches:
- Disable the space preallocation (default value is 3):
$ sqlplus / as sysdba
alter system set "_enable_space_preallocation"=0;
- or limit the number of the space background process secondary (default value is 1024):
$ sqlplus / as sysdba
alter system set "_max_spacebg_secondary"=&new_value;
- or disable the space management tasks completely (default state is enabled):
$ sqlplus / as sysdba
alter system set "_enable_spacebg"=false;
All the above hidden parameters can be set dynamically.