Sysman Username Has Over 400 Sessions once the DB Control is started
(Doc ID 727242.1)
Last updated on FEBRUARY 15, 2020
Applies to:Enterprise Manager for Oracle Database - Version 10.2.0.3 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Database control spawns over 400 sessions at startup. Eventually ORA-00020: maximum number of processes (%) errors will be displayed in the database alert log.
SQL> Select count(*) from v$session where username='SYSMAN';
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document