Long-Running Background Processes Like 'o00n' (Doc ID 2226855.1)

Last updated on MAY 10, 2017

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms