What is the overhead associated with the always on monitoring and its associated infrastructure (AWR , ASH, MMON etc) in 10g?
The complete Managability Infrastructure in 10g was targeted to have less than a 5% impact on performance. In extensive in-house testing and deployments, we see results of 3% or less. Of course, if one actions some of the ADDM’s findings & recommendations, there will be a big net positive, especially if your system is underperforming due to various bottlenecks.
