Re: stats gathering

From: Mark D Powell <markp28665_at_gmail.com>
Date: Thu, 23 Apr 2015 06:50:50 -0700 (PDT)
Message-ID: <3f36e439-c452-42b2-b583-f296b2b73984_at_googlegroups.com>


On Thursday, April 9, 2015 at 7:26:01 AM UTC-4, 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
Chris, just out of curiosity since Oracle has been automatically collecting statistics since version 10.x so what is the issue with Oracle continuing this process on 12? And with 11.x you also get the Diagnostic Repository clean up and maybe the audit cleanup.

HTH -- Mark D Powell -- Received on Thu Apr 23 2015 - 15:50:50 CEST

Original text of this message