Solution:
Keep in mind that the agents themselves can't send emails if they are not responding. The Stat Central Agent and the Oracle Agent update the MERC_WAKE table approximately every 30 seconds.
There is an agent_type field on the table which is 'S' for the Central Agent and 'O' for the Oracle agent.
Mainly, those Status description are decoded by the diff time calculation. When it is greater than 30 seconds it is decoded as 'Not Responding' but in this status the agent cannot send any email.
The select statements executed during this time are below:
SELECT SD_CD, UPDATE_DT, AGENT_MODE, AGENT_MODE_UI,
SYSDATE, ( (SYSDATE - UPDATE_DT) * 24 * 60 * 60) AS SECONDS_DIF
FROM stat.MERC_WAKE
WHERE AGENT_TYPE = 'S' <---- Central Agent
ORDER BY SD_CD;
SELECT M.SD_CD, M.UPDATE_DT, M.AGENT_MODE, O.DB_CD,
O.SERVER_NAME, O.MERC_WAKE_MULTI,
SYSDATE, ( (SYSDATE - M.UPDATE_DT) * 24 * 60 * 60) AS SECONDS_DIF
FROM stat.MERC_WAKE M, stat.STAT_OAENV_DETAILS O
WHERE M.SD_CD = TO_CHAR (O.AGENT_ID)
AND M.AGENT_TYPE = 'O' <---- Oracle Agent
ORDER BY SD_CD;
Those Statements above are captured by dbtrace.log
- run editi.ini and check the trace flag then run Stat client and go to
Tools | Stat Central Agent Status (first time) / Oracle Agent Status (second time)
OR
- if Toad is used, activate Database | Monitor | SQL Tracker and do the same operation above from the Stat client.