Oracle 数据库性能监控全解析
1. ADDM 报告与 AWR SQL 报告
在 Oracle 数据库性能监控中，ADDM（Automatic Database Diagnostic Monitor）报告和 AWR（Automatic Workload Repository）SQL 报告是非常重要的工具。
1.1 ADDM 报告
ADDM 报告按对数据库时间的影响程度降序列出各项发现。例如，一个关于全局缓存消息传递的发现：
Finding 2: Global Cache Messaging Impact is 2.62 active sessions, 38.46% of total activity. --------------------------------------------------------- Inter-instance messaging was consuming significant database time on this instance. Recommendation 1: Application Analysis Estimated benefit is .72 active sessions, 38.46% of total activity. ------------------------------------------------------------------- Action Look at the "Top SQL Statements" finding for SQL stateme
