My Oracle Support Banner

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.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.