Post Installation Actions

After deployment of IFS Cloud database objects, following manual actions need to be done.

Gather Oracle Statistics

When there are many new of modified objects in the database, like after a fresh install or an upgrade, Oracle's recommendation is to gather statistics about objects in the SYS schema, fixed objects and data dictionary tables. This is automatically done in an Oracle maintenance window but since you do not know when it will be, it is recommended to do this manually directly after IFS Applications are installed. This is done by the following commands (executed as SYS user):

BEGIN   
    DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

DBMS_STATS.GATHER_DICTIONARY_STATS;

   DBMS_STATS.GATHER_SCHEMA_STATS ('SYS');   
 END;   
 /

For more input, see the Oracle Considerations