SQL to monitor (check status) of Workflow Notification Mailer (Java)

 SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS
where COMPONENT_ID=10006;