Explanation of DBMS_STAT_JOB & BSLN_MAINTAIN_STATS_JOB
As I understand the two, the second being introduced in 11g:
STATEMENTS:
1. They are setup out-of-the-box and run nightly against SYS tables and any application schema tables that have the "MONITOR" column in the underlying tables of the dba_tables view set to "yes"
2. The routines will only perform stats on a table if the table has expeienced enough change, i.e., inserts, updates, and deletes, to go above a threshold since the last time the table was analyzed.
3. Statistics for inserts, updates, and deletes performed on the monitored tables reside in the underlying SYS tables of the DBA_TAB_MODIFICATIONS view. And these stats are used to make the decisions in statement 2 above.
STATEMENTS:
1. They are setup out-of-the-box and run nightly against SYS tables and any application schema tables that have the "MONITOR" column in the underlying tables of the dba_tables view set to "yes"
2. The routines will only perform stats on a table if the table has expeienced enough change, i.e., inserts, updates, and deletes, to go above a threshold since the last time the table was analyzed.
3. Statistics for inserts, updates, and deletes performed on the monitored tables reside in the underlying SYS tables of the DBA_TAB_MODIFICATIONS view. And these stats are used to make the decisions in statement 2 above.
1