BSLN_MAINTAIN_STATS_JOB的作用

saup007

环境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. 
   
4. select * from dba_scheduler_programs where program_name='BSLN_MAINTAIN_STATS_PROG'
   
5. program_action：begin if prvt_advisor.is_pack_enabled('DIAGNOSTIC') then dbsnmp.bsln_internal.maintain_statistics; end if; end;
   
6. 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 编辑 ]

saup007

其实我是触发一个bug，建立测试环境，但是忘记装em组件，所以需要手工安装。

1. 参考：ID 1413756.1，在This issue is fixed in 11.2.0.4 and later，修复。
   
2. 
   
3. Applies to:
   
4. 
   
5. Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
   
6. Information in this document applies to any platform.
   
7. Symptoms
   
8. 
   
9. BSLN_MAINTAIN_STATS_JOB fails with the following error:
   
10. 
    
11. ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB"
    
12. ORA-06502: PL/SQL: numeric or value error
    
13. ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073
    
14. ORA-06512: at line 1
    
15. 
    
16. Cause
    
17. 
    
18. The same is being investigated in unpublished
    
19. BUG 13637859 - "BSLN_MAINTAIN_STATS_JOB FAILS WITH ORA-06502
    
20. which is suspected to be a duplicate of unpublished
    
21. Bug 10110625 - DBSNMP.BSLN_INTERNAL RECEIVES ORA-06502
    
22. 
    
23. 
    
24. 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.
    
25. 
    
26. 
    
27. 
    
28. Solution
    
29. 
    
30. 
    
31. As a workaround, the DBSNMP user can be dropped and re-created using the standard scripts.
    
32. Ensure you have Backed up your database.
    
33. 
    
34. 
    
35. -- Login as sys user.
    
36. 
    
37. 
    
38. SQL> sqlplus / as sysdba
    
39. 
    
40. 
    
41. -- From the sqlplus execute the following:
    
42. 
    
43. 
    
44. -- Drop the DBSNMP user by executing catnsnmp.sql script.
    
45. 
    
46. 
    
47. SQL> @$ORACLE_HOME/rdbms/admin/catnsnmp.sql
    
48. 
    
49. 
    
50. -- Create the DBSNMP user by executing catsnmp.sql
    
51. 
    
52. 
    
53. SQL> @$ORACLE_HOME/rdbms/admin/catsnmp.sql
    
54. 
    
55. 
    
56. 
    
57. 
    
58. 
    
59. 
    
60. 或者补丁程序：14780228

复制代码

Maclean Liu(刘相兵

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

saup007

这句我之前也有找到。

New 11g Default Jobs [ID 755838.1]       

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

上网搜搜关于baseline的知识

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