Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

133

积分

0

好友

17

主题
1#
发表于 2012-6-5 11:36:57 | 查看: 13102| 回复: 3
环境11.2.0.2 linux平台

现在打算问BSLN_MAINTAIN_STATS_JOB 这个job的作用,看是否可以disable。好像与em有关,在创建手工创建em前,是没有这个job的
  1. select * from dba_scheduler_jobs where job_name='BSLN_MAINTAIN_STATS_JOB';
  2. comments 注释:Oracle defined automatic moving window baseline statistics computation job

  3. select * from dba_scheduler_programs where program_name='BSLN_MAINTAIN_STATS_PROG'
  4. program_action:begin if prvt_advisor.is_pack_enabled('DIAGNOSTIC') then dbsnmp.bsln_internal.maintain_statistics; end if; end;
  5. comments 注释:Moving window baseline statistics maintenance program
复制代码

自动维护窗口基线统计信息?不是很懂啊。

BSLN_MAINTAIN_STATS_JOB (替换了10G的GATHER_STATS job)
This job replaces the old GATHER_STATS job. It is a compute statistics job. This job runs the BSLN_MAINTAIN_STATS_PROG program on the BSLN_MAINTAIN_STATS_SCHED schedule. The program BSLN_MAINTAIN_STATS_PROG will keep the default baseline’s statistics up-to-date.


BSLN_MAINTAIN_STATS_JOB 最近二周都是失败的,怎么收集统计信息的呢,dba_tables的last_analyzed字段表示统计信息是有收集的。

[ 本帖最后由 saup007 于 2012-6-5 18:50 编辑 ]
2#
发表于 2012-6-5 15:25:17
其实我是触发一个bug,建立测试环境,但是忘记装em组件,所以需要手工安装。
  1. 参考:ID 1413756.1,在This issue is fixed in 11.2.0.4 and later,修复。

  2. Applies to:

  3. Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
  4. Information in this document applies to any platform.
  5. Symptoms

  6. BSLN_MAINTAIN_STATS_JOB fails with the following error:

  7. ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
  8. ORA-06502: PL/SQL: numeric or value error
  9. ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
  10. ORA-06512: at line 1

  11. Cause

  12. The same is being investigated in unpublished
  13. BUG 13637859 - "BSLN_MAINTAIN_STATS_JOB FAILS WITH ORA-06502
  14. which is suspected to be a duplicate of unpublished
  15. Bug 10110625 - DBSNMP.BSLN_INTERNAL RECEIVES ORA-06502


  16. As in a specific customer's situation, the issue can occur when a Database is created with a template from the old database or created as a clone from another database. The existing records in table "DBSNMP.BSLN_BASELINES" conflict with new baseline information inserted in the cloned database, thereby containing inconsistent information.



  17. Solution


  18. As a workaround, the DBSNMP user can be dropped and re-created using the standard scripts.
  19. Ensure you have Backed up your database.


  20. -- Login as sys user.


  21. SQL> sqlplus / as sysdba


  22. -- From the sqlplus execute the following:


  23. -- Drop the DBSNMP user by executing catnsnmp.sql script.


  24. SQL> @$ORACLE_HOME/rdbms/admin/catnsnmp.sql


  25. -- Create the DBSNMP user by executing catsnmp.sql


  26. SQL> @$ORACLE_HOME/rdbms/admin/catsnmp.sql






  27. 或者补丁程序:14780228
复制代码

回复 只看该作者 道具 举报

3#
发表于 2012-6-5 22:19:53
BSLN_MAINTAIN_STATS_JOB
This job is a compute statistics job. This job runs the  BSLN_MAINTAIN_STATS_PROG program on the BSLN_MAINTAIN_STATS_SCHED schedule. The program BSLN_MAINTAIN_STATS_PROG will keep the default baseline’s statistics up-to-date.

一个维护 baseline的 JOB

回复 只看该作者 道具 举报

4#
发表于 2012-6-5 23:54:44

回复 3# 的帖子

这句我之前也有找到。

New 11g Default Jobs [ID 755838.1]       

https://supporthtml.oracle.com/e ... -state=sujr4o0pm_57

上网搜搜关于baseline的知识

(替换了10G的GATHER_STATS job) 这句话对吗???
如果维护baseline,就不能disable了吧?

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 11:35 , Processed in 0.048071 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569