Oracle Alerts


Oracle Alerts shows alerts for one monitored Oracle server. Use it for focused Oracle instance triage.

Mini DBA Oracle alerts

Workflow

  1. Open Alerts under the Oracle server.
  2. Review severity, message, and time.
  3. Open the related Oracle monitoring page for supporting evidence.
  4. Use Configure and Copy Config to edit or copy alert policy.
  5. Use global Alerts for estate-wide alert review.

How To Use Oracle Alerts

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.

Oracle Alert FAQ

Why do I see Oracle alerts in two places?

This page focuses on one Oracle server. The global Alerts page is better for estate-wide triage.

Should I acknowledge every alert?

Follow your team's process. At minimum, high-severity and repeating alerts should have an owner and outcome.

What if an alert has no obvious cause?

Check the related monitoring pages and the time window around the alert. If evidence is still unclear, review collection permissions and thresholds.

Next Steps After An Oracle Alert

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.

Alert Type Reference

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

Related Pages