Is SLOB AWR Generation Really, Really, Really Slow on Oracle Database 11.2.0.4? Yes, Unless…

If you are testing SLOB against 11.2.0.4 and find that the AWR report generation phase of runit.sh is taking an inordinate amount of time (e.g., more than 10 seconds) then please be aware that, in the SLOB/awr subdirectory, there is a remedy script rightly called 11204-awr-stall-fix.sql.

Simply execute this script when connected to the instance with sysdba privilege and the problem will be solved. 

https://kevinclosson.files.wordpress.com/2016/03/screen-shot-2016-03-08-... 1000w, https://kevinclosson.files.wordpress.com/2016/03/screen-shot-2016-03-08-... 150w, https://kevinclosson.files.wordpress.com/2016/03/screen-shot-2016-03-08-... 300w, https://kevinclosson.files.wordpress.com/2016/03/screen-shot-2016-03-08-... 768w" sizes="(max-width: 500px) 100vw, 500px" />