I’m sorry to polute my movie review blog with some Oracle stuff, but here’s a little something on AWR Baseline Enhancements in 11g.
I think the role of BSLN_MAINTAIN_STATS_JOB is to keep the default baseline’s statistics up-to-date, would you know what happnes if we dont run this job and what side effects would cause if the default baseline’s stats are not updated.
Disabling that job will stop the moving window baseline from being maintained. That’s kind-of important in 11g as a bunch of the automated tuning stuff uses that information. If this baseline is not progressed it will not reflect the current usage of your system.