Long-Running Background Processes Like 'o00n'
(Doc ID 2226855.1)
Last updated on APRIL 27, 2021
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle SuperCluster M7 Hardware - Version All Versions and later
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |