My Oracle Support Banner

EM EMCLI Inactive Sessions are not Closed in Repository Database (Doc ID 2294916.1)

Last updated on JUNE 20, 2023

Applies to:

Enterprise Manager Base Platform - Version to [Release 12.1]
Information in this document applies to any platform.

Symptoms EM

Executing the following query in repository database shows many INACTIVE sessions which are not closed and they are created by EMCLI

SQL>select sid,serial#,username,status,action from v$session where action='/cli';

This can lead to Max Processes limit reached errors in the repository database over a period of time.




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

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