3 Replies Latest reply: Mar 24, 2013 11:25 PM by Salman Qureshi RSS

    BSLN_MAINTAIN_STATS_JOB

    867656
      Hi all,

      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

      Thank you / Jonu