SQL> select 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE ' from dba_objects where status 'VALID' It appears that SYNONYMS, an Oracle mechanism, were invalid, and that recompiling all SYNONYMS that were not "VALID" fixed the problem. But our production engine had another major outage last night. This is all based on a preliminary analysis, I am still looking at logs and other things.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |