DBA can investigation which objects are invalid and they can take necessary action for those object. Number of objects are invalid by object types SELECT object_type, COUNT ( * )...
/ Posted by KapilCheck file version in application through sql script & linux/sun os command. Enter file name in below script which provide file version with location. SELECT af.app_short_name "Application", af.filename "File Name",...
/ Posted by Kapil