oracle database 升级后部分检查

1\
---select data dictionary version---
 COL version FOR A10
 COL comp_id FOR A8
 COL schema LIKE comp_id
 COL comp_name FOR A35
 COL status FOR A12
 SELECT comp_id, schema, status, version, comp_name
 FROM dba_registry
 ORDER BY 1;

2\
----select invalid object----
COL status FOR a9
COL object_type FOR a20
COL owner.object FOR a50
SELECT status, object_id, object_type, owner||'.'||object_name "OWNER.OBJECT"
FROM dba_objects
WHERE status != 'VALID' AND object_name NOT LIKE 'BIN$%'
ORDER BY 4,2;