There are a lot of open Oracle sessions and connections created by Foglight which uses a lot of CPU on the monitored host.
Whenever the Oracle agent receives a socket timeout, the connection is disconnected automatically by the driver. It seems that the sessions remain open on the host instance.
If a firewall kills/interrupts a database session, the database session itself does not realize that the session has gone and the database agent receives a socket timeout. The database keeps the session open. Foglight will create a new session.
As a result the database runs out of session/processes.
Undetermined
Unidentified
Change the new ASP setting "Kill unexpected disconnected sessions".
If the following message appears, the Foglight user does not have permissions to kill its sessions
Failed to kill session with sid [3222] and serial number [9358]. error: [ORA-01031: insufficient privileges
Please set the following OS parameters to avoid the situation:
In one circumstance, a root cause for this issue was not identified by Development
© ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center