今天收到一些foglight的报警,说一些自动执行的dbms_stats.gather_schema_stats报这些错:
Fri Nov 23 13:47:29 2007 Errors in file c:oracleadminrcatudumprcat_j001_3928.trc: ORA-12012: error on auto execute of job 22 ORA-20000: Insufficient privileges to analyze an object in Schema ORA-06512: at "SYS.DBMS_STATS", line 9635 ORA-06512: at "SYS.DBMS_STATS", line 9800 ORA-06512: at "SYS.DBMS_STATS", line 9854 ORA-06512: at "SYS.DBMS_STATS", line 9831 ORA-06512: at "SYSTEM.DBA_TABLE_ANALYZE", line 12 ORA-06512: at line 1
到metalink查了一下,是一个bug,实际上很简单,如果用sys用户是没有问题的,如果用的是system用户,则需要用sys用户给system用户授权:
sql>grant select any table ,anylyze any to system;
这样就可以了。 |