6 Statistics Collection for FLEXCUBE Schema (Recommended Method)
Oracle 19c provides a default scheduled job to collect statistics for the entire database and is default scheduled to run every night. Given that the FLEXCUBE batch as well runs in the night it is critical that the statistics gathering is not run during the batch.
It is recommended to use the default database scheduled job that is shipped with Oracle Database to collect statistics for FLEXCUBE Schema.
Statisics collection recommendation is specific to FLEXCUBE schema. Other
available statistics like System statistics,Fixed table statistics, dictionary
statistics,etc. are not part of this recommendation and are required to be executed on
need basis.
Note:
This document assumes that there is no other tool or a program is scheduled to collect statistics for the Database.