Database Reference
In-Depth Information
Figure 9-47.
Advisor Central's database integrity checker options
The Performance section of each database target in the EM12c console offers incredible insight into the database,
along with optimizing options for its long-term health.
Emergency Monitoring
Emergency Monitoring enables you to monitor basic processing and database information of an unresponsive
database. The proprietary mechanism is available through EM12c and the Enterprise Manager Command Line
Interface (EMCLI) and allows the administrator to diagnose performance issues, conduct hang analysis, and kill
blocking sessions.
Emergency Monitoring requires SYSDBA access and DB Host access for the Oracle user to successfully
implement.
Real-Time ADDM
A troubling scenario for an administrator is a hung database. The conundrum of deciding whether to quickly bounce
the database—thereby removing the obstacle causing the hang situation but often losing all valuable data to diagnose
the cause—has resulted in Oracle offering Real-Time ADDM.
Real-Time ADDM offers real-time analysis of a slow or hung database system and diagnoses deadlocks,
performance impacts, and resource contention (see Table
9-3
). The Real-Time ADDM feature uses DB Time as the
basis for all performance measurements. It also identifies any configuration changes that have occurred, weighing
both sets of metrics to report and compare.
