People ask what do I look for when monitoring an EBS instance for availability? Oracle Enterprise Manager (OEM) with the Applications Management Pack (AMS) gives a good starting point, but here is a condensed list of my general health check items for my production instance. It’s not everything possible, but it’s what I generally would check during a shake-down of a disaster-recovery exercise.
| Warning | Critical | ||||
| Oracle E-Business Suite | |||||
| Oracle Applications Infrastructure Service | |||||
| Database Instance | select SYSDATE from dual; | Up/Down | |||
| Tablespace Freespace Available | >80% | >90% | |||
| Temporary Tablespace Used | >80% | >90% | |||
| Undo Tablespace Used | >80% | >90% | |||
| Fast Recovery Area Utilization | >80% | >90% | |||
| Redo Log Switch Rate | > 10/hr. | >20/hr | |||
| Blocking Sessions | >1 | >5 | |||
| Database Listener | tnsping <ORACLE_SID> | Up/Down | |||
| TNSPing Response Time | > 25ms | > 100ms | |||
| Applications Listener | tnsping <FNDFS_ORACLE_SID> | Up/Down | |||
| Host Monitoring | |||||
| CPU Utilization | > 80% | > 95% | |||
| RAM Utilization | > 90% | > 99% | |||
| Mountpoint Free Space Available | <10% | <5% | |||
| Concurrent Processing Services | |||||
| Internal Manager | Up/Down | ||||
| Standard Manager | < 10 | ||||
| Output Post Processor | < 3 | ||||
| Receiving Transactions Manager | < 1 | ||||
| Document Approval Manager | < 1 | ||||
| Forms Applications Service | |||||
| Forms Listener Service | Up/Down | ||||
| Forms Runtime Processes | <1 | ||||
| Forms Response Time | >5 secs | >30 secs | |||
| Active Forms Sessions | > 100 | > 200 | |||
| Self-Service Applications Service | |||||
| HTTP Listener Service | Up/Down | ||||
| OPMN Processor | Up/Down | ||||
| OC4J Service | Up/Down | ||||
| WebLogic Deployed Services | Up/Down | ||||
| WebLogic AdminServer | Up/Down | ||||
| OA Framework Page Response Time | > 5 secs | > 10 secs | |||
| Oracle Applications JVM Usage | >80% | >90% | |||
| Workflow Serivce | OAM Dashboard | Up/Down | |||
| Workflow Agent Listener | Up/Down | ||||
| Workflow Background Engine | Up/Down | ||||
| Workflow Notification Mailer Services | Up/Down | ||||
| Oracle E-Business Suite Custom Objects | |||||
| Invalid Object Count | > 482 | > 500 | |||
| Oracle E-Business Suite Patch Information | |||||
| Patch Inventory | |||||
| ADOP Session Status | >1 Pending | >1 Failed | |||
Thoughts from James H. Lui 