EM 18.104.22.168: EMCLI Inactive Sessions are not Closed in Repository Database
Last updated on AUGUST 08, 2017
Applies to:Enterprise Manager Base Platform - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms