If the package BSLN_MAINTAIN_STATS_JOB doesn't run, will that cause issues with the database?
Hi DBA Gurus,
I found the following error in the alert log of our UAT instance. Oracle Database version 11.2.0.3, OS : IBM AIX 64-bit Power systems version 7.1:
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
Oracle support has a metalink document on this which asks to apply a patch or as a workaround delete and recreate DBSNMP user.
I found the following entries from DBSNMP.BSLN_BASELINES:
My output:
DBID INSTANCE NAME STATUS LAST_COMPUTE DATE
3450607347 ccbtest ACTIVE 12-AUG-18
3450607347 CCBPROD ACTIVE 12-AUG-18