Re: stats gathering

On Thursday, April 9, 2015 at 4:26:01 AM UTC-7, chris..._at_coveainsurance.co.uk wrote:
> We just migrated to a new12c database on windows 2012
>
> Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
>
> Something is gathering stats & I don't know what!
> ( got this from last_analyzed timestamp in dba_tables )
>
> It always starts at 10pm
>
> I have disabled standard BLSN_MAINTAIN_STATS_JOB so it's a bit of a mystery!
>
> Anyone any ideas?
>
> regards
> Chris B
>
>
> MGMT_STATS_CONFIG_JOB 01-MAY-15 01.01.01.500000 +00:00 SCHEDULED
> ORA$AUTOTASK_CLEAN 10-APR-15 03.00.00.800000 EUROPE/LI SCHEDULED
> PURGE_LOG 10-APR-15 03.00.00.800000 EUROPE/LI SCHEDULED
> PMO_DEFERRED_GIDX_MAINT_JOB 10-APR-15 02.00.00.200000 EUROPE/LI SCHEDULED
> SM$CLEAN_AUTO_SPLIT_MERGE 10-APR-15 00.00.00.500000 EUROPE/LI SCHEDULED
> RSE$CLEAN_RECOVERABLE_SCRIPT 10-APR-15 00.00.00.500000 EUROPE/LI SCHEDULED
> CLEANUP_TRANSIENT_TYPE 09-APR-15 23.00.26.111000 +01:00 SCHEDULED
> CLEANUP_NON_EXIST_OBJ 09-APR-15 22.59.45.067000 +01:00 SCHEDULED
> CLEANUP_ONLINE_PMO 09-APR-15 11.33.16.100000 +00:00 SCHEDULED
> CLEANUP_TRANSIENT_PKG 09-APR-15 11.33.06.000000 +00:00 SCHEDULED
> CLEANUP_TAB_IOT_PMO 09-APR-15 11.32.46.000000 +00:00 SCHEDULED
> CLEANUP_ONLINE_IND_BUILD 09-APR-15 11.32.36.000000 +00:00 SCHEDULED
> BSLN_MAINTAIN_STATS_JOB 10-NOV-14 00.00.00.300000 +00:00 DISABLED
Looks like you've configured OCM (MGMT_STATS_CONFIG_JOB), which means "send a bunch of stuff to Oracle in the middle of the night." http://docs.oracle.com/cd/E49269_01/doc.12/e49552/discovery.htm#OCMTS144

jg

-- 
_at_home.com is bogus.
http://economictimes.indiatimes.com/tech/ites/it-giants-ibm-oracle-red-hat-and-others-racing-for-cloud-sales-specialists-to-tap-rising-demand/articleshow/46857370.cms