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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM 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, AIX 64bit, HP-UX, Linux, Solaris, Windows, Windows 2000, Windows 2003 server, Windows 2008 server, Windows XP, z/OS

Reference #:

1623599

Modified date:

2014-01-02

Translate my page

Machine Translation

Content navigation