Finally, starting in Oracle 12, databases will automatically gather statistics when importing tables, if they were excluded from the export, and it also monitor and update statistics on a daily basis during its maintenance windows. If in doubt, you can check the LAST_ANALYZED column for view USER_TABLES while connected as the HPD Schema owner to check it the newly imported tables have them.
If needed and before allowing any users to connect to the newly restored HPD schema, you should collect statistics for tables/indexes in the HPD schema. This is done by executing the following procedures under the HPD Schema Owner user account:
SQL> exec dbms_stats.gather_schema_stats(user,cascade=>true) PL/SQL procedure successfully completed. |
This process takes several minutes, and it will take longer to complete if there is more data in the database schema. Additional information can be found here: |