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):
DBMS_STATS.GATHER_SCHEMA_STATS ('SYS'); END; /
For more input, see the Oracle Considerations