Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

stats gathering

306 views
Skip to first unread message

chris...@coveainsurance.co.uk

unread,
Apr 9, 2015, 7:26:01 AM4/9/15
to
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

joel garry

unread,
Apr 9, 2015, 1:22:12 PM4/9/15
to
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
--
@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

chris...@coveainsurance.co.uk

unread,
Apr 10, 2015, 11:05:06 AM4/10/15
to
thanks Joel

That caught me out ..I will look at disabling / enabling to confirm that it is the cause/culprit

cheers
Chris B

joel garry

unread,
Apr 10, 2015, 4:09:19 PM4/10/15
to
You might also want to check if maybe some 11g stuff is there, see https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1133388300346992024

jg
--
@home.com is bogus.
http://www.v3.co.uk/v3-uk/news/2403519/hps-public-cloud-confusion-ibm-s-army-deal-and-oracle-s-retail-push-the-week-in-cloud

chris...@coveainsurance.co.uk

unread,
Apr 23, 2015, 3:26:43 AM4/23/15
to
thanks again Joel will continue research

Chris B

Mark D Powell

unread,
Apr 23, 2015, 9:50:56 AM4/23/15
to
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 --
0 new messages