stats gathering
From: <chris.brown_at_coveainsurance.co.uk>
Date: Thu, 9 Apr 2015 04:25:53 -0700 (PDT)
Message-ID: <a5143e7e-efef-4668-b92e-12091061b8b1_at_googlegroups.com>
We just migrated to a new12c database on windows 2012
Date: Thu, 9 Apr 2015 04:25:53 -0700 (PDT)
Message-ID: <a5143e7e-efef-4668-b92e-12091061b8b1_at_googlegroups.com>
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 SCHEDULEDBSLN_MAINTAIN_STATS_JOB 10-NOV-14 00.00.00.300000 +00:00 DISABLED Received on Thu Apr 09 2015 - 13:25:53 CEST