This week I got a request to share a script I wrote years ago -- a script to generate AWR report automatically every hour and email it out to whoever is interested in it. Bascially it uses Oracle's script awrrpti.sql. As the comments in the SQL script say, once the following variables defined, running it … Continue reading Getting AWR report every hour automatically →