Long-Running Background Processes Like 'o00n'

Asset ID:	1-72-2226855.1
Update Date:	2017-05-10
Keywords:

Solution Type Problem Resolution Sure

Solution 2226855.1 : Long-Running Background Processes Like 'o00n'

Applies to:

Oracle SuperCluster M7 Hardware - Version All Versions and later
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

In all of the databases in SC, have background processes from normal users which are active for almost 7 days.

if we kill these session, they appear again after sometime.

Ex:

PID SPID PROGRAM PGA_USED_MEM PGA_ALLOC_MEM PGA_MAX_MEM
---- ------ ------------------------- ------------ ------------- -----------
52 12487 oracle@dbadm01 (O000) 1043654 1117038 1117038
63 14622 oracle@dbadm01 (O001) 1030302 1117038 1117038
306 22108 oracle@dbadm01 (O002) 1030302 1117038 1117038

Changes

none

Cause

these processes are used for send message from Database instance to ASM instance, it is expected bahavior.

Solution

Oracle Database instances need to run O-slave processes to send messages from Database instance to ASM instance.

Minimum number of processes is 1. Maximum number of processes is 30.

Please safely ignore these processes.

References

<BUG:24339892> - ACTIVE BG PROCESSES RUNNING SINCE LONG TIME ON SUPERCLUSTER,RE-APPEARING ON KILL

Attachments

This solution has no attachment