Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

BSLN_MAINTAIN_STATS_JOB

867656Mar 24 2013 — edited Mar 25 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2013

Added on Mar 24 2013

#general-database-discussions

3 comments

5,098 views