Learned an interesting one today. I noticed that the nightly stats job was not running on any of our data guard logical standbys. It would not run despite running a complete remove/reset the scheduled maintenance window, resetting the parameters for the job, etc. A fellow DBA tipped me off to this issue which applies to [...]
Posts Tagged ‘statistics’
10.2.04 Data guard logical standbys and dbms_scheduler
Posted in Dataguard, Statistics, tagged Dataguard, dbms_scheduler, logical, standby, statistics on August 4, 2010 | Leave a Comment »