How often should we set up a Cron Task in Maximo to run Update Statistics?
There is no out-of-the-box Cron Task in Maximo to run Update Statistics.
When running Update Statistics via the Select Action menu in Database Configuration, Maximo calls the following script behind the scene for each table:
Update statistics example:
(ownname => 'MAXIMO', tabname => 'ASSET', cascade => true)
Your Oracle DBA can schedule the job rather than doing it manually.
We highly recommend optimizing the statistics on your database once a week if your database is large.
For more details, please refer to: