DB statistics

[Former Member]

Hi All

what is the program that we run to get the statistics of the database.

[Former Member]

Hello,

I suggest to have a crontab job scheduled which runs on a regular basis, e.g. every Sunday night.

Also I suggest to run statistic updates on a regular basis using the monit option, see more informations about it below.

Oracle table monitoring

With this feature, the Oracle database system constantly updates information concerning record counts for database tables, entering the results in the DBA_TAB_MODIFICATION Stable. It only takes BRCONNECT a very short time to read this results table and determine whether update statistics is required for a given database table.

The activation of the table monitoring attribute is now automated with the monit option as follows:

brconnect u2013u / -c u2013f stats u2013t all u2013f monit

The advantages of this are:

X For tables with the monitoring attribute activated by BRCONNECT, new statistics are collected at the same time. This gives Oracle a good basis for collecting information about changes to the table.

X Tables that are dynamically created by the SAP system, such as in SAP BW, are automatically (that is, without any manual intervention) processed by BRCONNECT on the next processing run.

For more information, see brconnect u2013f stats and SAP Notes 408527 and 628590.

A coron entry could look like this:

su - <db_owner> -c brconnect -u <db_user>/<password> -c -f stats -t all -f monit -p 8 1>/dev/null 2>&1