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" />
Recent comments
2 years 51 weeks ago
3 years 11 weeks ago
3 years 15 weeks ago
3 years 16 weeks ago
3 years 21 weeks ago
3 years 42 weeks ago
4 years 10 weeks ago
4 years 40 weeks ago
5 years 24 weeks ago
5 years 24 weeks ago