This article highlights a bug (and fix) with the STATSPACK package, which reminds me of another bug we have encountered and are going to be fixing if it still exists after our upgrade to R12. Currently in our 11.2.0.3 environment, and the bug exists in 11.2.0.2 as well, we encounter the following entry in the database log file every week when a job tries to run:
ORA-12012: error on auto execute of job "PERFSTAT"."STATSPACK_PURGE_61"
ORA-04063: package body "PERFSTAT.STATSPACK" has errors
ORA-06508: PL/SQL: could not find program unit being called: "PERFSTAT.STATSPACK"
ORA-06512: at line 2
You can see with this script, that several objects are marked as INVALID:
select object_name, object_type, status from dba_objects where owner = 'PERFSTAT' and status = 'INVALID'
The document you want to see to fix this on My Oracle Support is 1337034.1, and if you want to apply the patch and fix it I'd be interested to hear from you!
No comments:
Post a Comment