This discussion is archived
7 Replies Latest reply: Jun 6, 2013 1:54 AM by oelk0 RSS

XE11: BSLN_MAINTAIN_STATS_JOB

oelk0 Newbie
Currently Being Moderated
Hello,

saw the alert_XE.log and found the following:

Errors in file /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_j002_11344.trc:
ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
ORA-06550: line 1, column 807:
PLS-00201: identifier 'DBSNMP.BSLN_INTERNAL' must be declared
ORA-06550: line 1, column 807:
PL/SQL: Statement ignored

This is cause the schema DBSNMP is not installed? Right?

Is it necessary to install it:
sqlplus sys/****** as sysdba @?/rdbms/admin/catsnmp.sql

If i create it the messages disappear.

Or is it usefull to disable the job BSLN_MAINTAIN_STATS_JOB:
exec DBMS_SCHEDULER.disable (name => 'BSLN_MAINTAIN_STATS_JOB');

What is this good for? Do i need it?

Best regards
  • 1. Re: XE11: BSLN_MAINTAIN_STATS_JOB
    Udo Guru
    Currently Being Moderated
    Hello,

    this is a known bug in 11.2 XE. It concerns the database job that would regularly update your tables statistics to ensure the optimizer will always get a good execution plan for queries. Whether you need it or not depends on how you use your database. But it certainly won't harm to fix the issue. To do so, you can run the follwing command sequence
    cd $ORACLE_HOME/rdbms/admin
    sqlplus / as sysdba
    @catnsnmp
    @catsnmp
    shutdown immediate;
    startup;
    exit
    I integrated this snippet in my personal "post-install" script, among with some other adjustments for OS-specific settings, database parameters and the fix for the mixed up datafiles (sysaux and undo).

    -Udo
  • 2. Re: XE11: BSLN_MAINTAIN_STATS_JOB
    oelk0 Newbie
    Currently Being Moderated
    Thanks Udo for your reply,

    in the process of a scripting installation i do a shutdown and startup.

    Is there a listing and explanation of all scheduler jobs?

    Best regards
  • 3. Re: XE11: BSLN_MAINTAIN_STATS_JOB
    Udo Guru
    Currently Being Moderated
    Sure, you can query the corresponding dba-view dba_scheduler_jobs to get an overview.
    For just knowing what's there, you can run
    SELECT job_name,
           comments
      FROM dba_scheduler_jobs
     ORDER BY job_name;
    You'll see a short description for most predefined jobs in the comments section. If you want to know more, I recommend "RTFM" or your preferred search engine on the job name.

    -Udo
  • 4. Re: XE11: BSLN_MAINTAIN_STATS_JOB
    oelk0 Newbie
    Currently Being Moderated
    Thanks, i know that.
    I would like to have 'RTFM', where can i find?

    Best reagrds
  • 5. Re: XE11: BSLN_MAINTAIN_STATS_JOB
    Udo Guru
    Currently Being Moderated
    To be honest, there is no "all in one" view from Oracle directly. You either have to start with third-party sources (e. g. [url http://www.asktherealtom.ch/?p=147]Oracle 11g Default Jobs) or go through the docs based on their topic.
    For the latter, a good start would be the Oracle Database Administration Guide, e. g. in Part IV on [url http://docs.oracle.com/cd/E18283_01/server.112/e17120/part6.htm#i996746]Database Resource Management and Task Scheduling. Then, there is the documentation for the [url http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmintro.htm#CHDEBFCH]DRA (Data Recovery Advisor). And so on. I'm not sure a "everyday" XE-dba would want to dig deeper into that area, unless you have an actual call for it.

    -Udo
  • 6. Re: XE11: BSLN_MAINTAIN_STATS_JOB
    oelk0 Newbie
    Currently Being Moderated
    Hi Udo,

    does it concern only the linux-version or the windows-version also?
    The document ID 1413756.1 does not make any statement about the version.

    Best regards
  • 7. Re: XE11: BSLN_MAINTAIN_STATS_JOB
    oelk0 Newbie
    Currently Being Moderated
    Yes, it's missing in the windows-version also.

    Best regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points