We support an SAP system with oracle 11.2 as the DB, and a couple of days ago we got an alert for BSLN_MAINTAIN_STATS_JOB, and i wanted to know whats the purpose of this job , is this job for stats collection on tables as SAP has a separate method for collecting statistics and we disable the oracle default method.
this is what i got from metalink, The program BSLN_MAINTAIN_STATS_PROG will keep the default baseline's statistics up-to-date, but i did not understand what's default baseline's statistics, could anyone please let us know.
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
Thx Salman, the link does mention the role of job as "The program BSLN_MAINTAIN_STATS_PROG will keep the default baseline’s statistics up-to-date", what does default baseline’s statistics up-to-date mean, is it the stats for tables.