Oracle Alerts shows alerts for one monitored Oracle server. Use it for focused Oracle instance triage.
> Community Edition: If this Oracle server is monitored by a Community Edition engine, selecting Alerts shows an explanation instead of this alert-management page. Connect it through a trial or licensed engine to enable alert evaluation, history, configuration, and notifications. Licensed-engine servers remain fully enabled in mixed-engine Consoles. See Alert availability.
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 |
| Data Guard Apply Not Running | Availability | Open detail |
| Data Guard Destination Errors | Availability | Open detail |
| Data Guard Lag | Availability | Open detail |
| Data Guard Role/Open Mode | Availability | Open detail |
| Data Guard Stats Stale | Availability | Open detail |
| Database Off-line | Availability | Open detail |
| Maximum Sessions | Availability | Open detail |
| No Connection | Availability | Open detail |
| Process Limit Usage | Availability | Open detail |
| RMAN Backup Age | Availability | Open detail |
| RMAN Backup Failures | Availability | Open detail |
| Server Ping Latency | Availability | Open detail |
| Session Limit Usage | Availability | Open detail |
| Host CPU % | CPU | Open detail |
| Archive Log Destination Space | Disk | Open detail |
| ASM Disk Group Usage | Disk | Open detail |
| ASM Offline Disks | Disk | Open detail |
| Datafile Offline/Recover State | 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 |
| Redo Write Wait Pressure | Disk | Open detail |
| System I/O Wait Pressure | 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 |
| Library Cache Reload Pressure | Memory | Open detail |
| PGA Memory Pressure | Memory | Open detail |
| PGA Multipass Workarea | Memory | Open detail |
| SGA Size | Memory | Open detail |
| Undo Tablespace Usage | Memory | Open detail |
| Alert Send Error | Monitoring | Open detail |
| Application Wait Pressure | Query | Open detail |
| Blocked Sessions | Query | Open detail |
| Blocking Sessions | Query | Open detail |
| Concurrency Wait Pressure | Query | Open detail |
| Deadlocks Detected | Query | Open detail |
| Hard Parse Ratio | Query | Open detail |
| Long Running Sessions | Query | Open detail |
| Query Regression | Query | Open detail |
| Redo Commit Wait Pressure | Query | Open detail |
| Stale Table Statistics | Query | Open detail |
| Temp I/O Wait Pressure | Query | Open detail |