企业官网建设流程全解析

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