Oracle 12.2.0 on Microsoft Windows x86 64-bit crache ORA-00020: maximum number of processes (1200) e

Jul 27, 2021 2:01PM

Hi,

I had Oracle Restart (12.2.0.) with Active Dataguard Broker

after restart primary got this into alert.log

DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name

Additional information: hd=000001ECFC22A848 phd=000001ECFC22BA78 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0

2021-07-27T10:29:37.653197+02:00

----- PL/SQL Call Stack -----

object line object

handle number name

000001ECF5AA5E50 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION

000001ECE5955E58 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK

000001ECE5955E58 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS

000001ECE4D15C10 1 anonymous block

2021-07-27T10:29:45.613228+02:00

Database Administration (MOSC)