How often should we set up a Cron Task in Maximo to run Update Statistics?

Technote (FAQ)


Question

How often should we set up a Cron Task in Maximo to run Update Statistics?

Answer

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:

dbms_stats.gather_table_stats
(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:
DBMS_STATS package.

Document information


More support for:

Maximo Asset Management
Cron Task Setup

Software version:

7.1, 7.1.1, 7.1.2, 7.2, 7.2.1, 7.5

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows, z/OS

Reference #:

1623599

Modified date:

2015-07-14

Translate my page

Content navigation