Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed

© Roger Cornejo 2018

Roger CornejoDynamic Oracle Performance Analyticshttps://doi.org/10.1007/978-1-4842-4137-0_9

9. Monitoring

Roger Cornejo¹ 

(1)

Durham, NC, USA

 

Sadly, and all too often, we learn of database performance problems as a complaint from database users. Most DBAs and managers would like to stay ahead of performance problems by monitoring their databases and taking peremptory action to avoid the types of performance complaints to which most of us have been accustomed. Some level of automated monitoring is or should be an integral and important task for DBAs, especially in environments with hundreds if not thousands of databases, where the sheer volume makes it impossible to monitor manually.

There are currently many approaches to and implementations ...