We are trying to monitor the number of DB connection sessions for both event_demon and as_server.
How do you calculate the expected number of sessions.
Release : 11.3.6
Component : CA Workload Automation AE (AutoSys)
AutoSys uses the following:
DB_CONNECTIONS + DB_CONNECTIONS_SEND + DB_CONNECTIONS_RECV + DB_MONITOR(1) + HEART_BEAT(1)
HEART_BEAT = High Availabiltiy Checking for Scheduler
HEART_BEAT = Application Server HeartBeat
If you do not set any variables, then Scheduler will show 16 + 2 + 2 + 1 + 1 = 22.
Application Server and Scheduler make use of the dedicated connection to register the heartbeat. The application server updates the ujo_ma_process with the latest timestamp every 5 seconds. The Scheduler will update the ujo_ha_process table based on your HAPollInterval configuration.
Application Server and Scheduler make use of a dedicated connection for identifying any database connection problems (network or server unavailability or listener unavailability, etc.,).