操作系统:linux RHEL 7.4
数据库:Oracle 12c R2
问题现象:生产中某个核心数据库升级至12cR2后,出现一些“class slave wait”等待事件,且发起用户是sys和customer user,program是后台进程,感觉很奇怪
问题原因:
查询MOS得知
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
SYMPTOMS
User Session shows ACTIVE with event "class slave wait". The session type shows BACKGROUND even though its a user session.
SID SERIAL# USERNAME PROGRAM TYPE
PID SPID WAIT_TIME STATE
---------- ---------- ------------------------------
------------------------------------------------ ----------
------------------------ ---------- -------------------
EVENT
----------------------------------------------------------------
10 1 user1 oracle@psdprod (O000)