Oracle Alerts shows alerts for one monitored Oracle server. Use it for focused Oracle instance triage.
Oracle Alerts are useful when you want to focus on one Oracle server rather than the full estate. Start with high-severity alerts and alerts that are new, repeating, or tied to a known incident window. Then open the linked monitoring page to verify the evidence behind the alert.
Do not treat alerts as standalone proof of root cause. An alert can show that a threshold was crossed, but Oracle Activity, Oracle Queries, Oracle Waits, and Oracle Health Checks help explain why it happened. If several alerts fire at the same time, identify the earliest meaningful signal and the business service affected.
For operational follow-up, record the alert time, severity, affected database, owner, and action taken. This makes alert review useful for service reporting and reduces repeat investigations.
Use Copy, Export, And Import Alert Configuration when Oracle servers should share alert thresholds, notification settings, and custom alert behavior. Review recipient routing and Oracle-specific thresholds before copying between production, test, and customer estates.
This page focuses on one Oracle server. The global Alerts page is better for estate-wide triage.
Follow your team's process. At minimum, high-severity and repeating alerts should have an owner and outcome.
Check the related monitoring pages and the time window around the alert. If evidence is still unclear, review collection permissions and thresholds.
After selecting an Oracle alert, confirm whether the condition is current, repeating, or historical. Then open the relevant Oracle page to gather supporting evidence. Performance alerts usually need Activity, Queries, and Waits. Operational alerts may need Health Checks, Memory, or database inventory. Record the owner and outcome for repeating alerts.
The following Mini DBA Oracle alert detail pages explain why each alert is useful, when to enable it, how to tune thresholds, and what remediation steps to take when the alert is active. Custom Alert is included because each server Alerts page can also hold user-defined query alerts.
| Alert | Category | Detail |
|---|---|---|
| Custom Alert | Custom | Open detail |
| Database Off-line | Availability | Open detail |
| Maximum Sessions | Availability | Open detail |
| No Connection | Availability | Open detail |
| RMAN Backup Age | Availability | Open detail |
| Server Ping Latency | Availability | Open detail |
| Host CPU % | CPU | Open detail |
| Archive Log Destination Space | Disk | Open detail |
| Flash Recovery Area Usage | Disk | Open detail |
| Physical Reads Rate | Disk | Open detail |
| Redo Generation Rate | Disk | Open detail |
| Redo Log Switches Per Hour | Disk | Open detail |
| Tablespace Usage | Disk | Open detail |
| Temp Tablespace Usage | Disk | Open detail |
| User I/O Wait Time | Disk | Open detail |
| Alert Log Errors | General | Open detail |
| Expiring Passwords | General | Open detail |
| Failed Login Attempts | General | Open detail |
| Failed Scheduler Jobs | General | Open detail |
| Invalid Objects | General | Open detail |
| Buffer Cache Hit Ratio | Memory | Open detail |
| Library Cache Hit Ratio | Memory | Open detail |
| PGA Memory Pressure | Memory | Open detail |
| SGA Size | Memory | Open detail |
| Undo Tablespace Usage | Memory | Open detail |
| Alert Send Error | Monitoring | Open detail |
| Blocked Sessions | Query | Open detail |
| Blocking Sessions | Query | Open detail |
| Deadlocks Detected | Query | Open detail |
| Hard Parse Ratio | Query | Open detail |
| Long Running Sessions | Query | Open detail |
| Stale Table Statistics | Query | Open detail |