Sysman Username Has Over 400 Sessions once the DB Control is started
(Doc ID 727242.1)
Last updated on NOVEMBER 16, 2022
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.
Symptoms
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';
COUNT(*)
----------
420
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! |
In this Document
Symptoms |
Cause |
Solution |