The BSLN_MAINTAIN_STATS_JOB which runs weekly has Failed with below error.
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-04063: package body "SYS.DBMS_WORKLOAD_REPOSITORY" has errors
ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
ORA-06512: at line 1
How is if going to affect the database? How to resolve it?
try to investigate what error is in package body, without more information we can't tell you any advice or how to solve.
You should always post OS, database version (5digits), detailed problem (more details = better/faster answers), last 50 lines of alert.log,...
execute and post:
sql > alter package body BSLN_MAINTAIN_STATS_JOB compile;
sql > show errors;
post here the result
Database version is 184.108.40.206.0. The BSLN_MAINTAIN_STATS_JOB is a job which scheduled to run once in a week for collecting baseline statistics. It is not a package.
The SYS.DBMS_WORKLOAD_REPOSITORY is the package the got error ed out.
After recompiling I got
PLS-00753: malformed or corrupted wrapped unit