oracle exec报错,Oracle 12C RAC报错ORA-20001: Statistics Advisor

最新推荐文章于 2023-12-01 09:11:05 发布

weixin_39548438

最新推荐文章于 2023-12-01 09:11:05 发布

阅读量136

点赞数

文章标签： oracle exec报错

ORA-06512: at "SYS.DBMS_STATS", line 46851

官方给我的问题原因：

Seed database was most likely not created right by package dbms_stats.init_package not being ran.

Dbms_stats.init_package creates statistics advisor. This procedure is executed during database creation. If something went wrong during database creation,(for example, init_package is not called for some reason), this kind of errors may be seen in alert log when auto job tries to execute.

解决方法：

Run dbms_stats.init_package() in the container database to create the tasks correctly:

$ sqlplus / as sysdba

EXEC dbms_stats.init_package();

column name format A35

set linesize 120

select name, ctime, how_created

from sys.wri$_adv_tasks

where owner_name = 'SYS'

and name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK');

Output of the query will look like this:

NAME CTIME HOW_CREATED