Question Re: DB statistics in Technology Q&A

DB statistics

Former Member — Wed, 25 Feb 2009 10:44:49 GMT

Hi All

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

Re: DB statistics

stefan_koehler — Wed, 25 Feb 2009 10:50:02 GMT

Hello Sudhakar,

to collect oracle database statistics you should use the BR*Tools (brconnect):

http://help.sap.com/saphelp_erp2004/helpdata/EN/88/fce73a86e99c77e10000000a114084/content.htm

To view the statistics you can use the PL/SQL Package DBMS_STATS:

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_stats.htm

If you have the SQL Developer you can also query it very easily via GUI.

Regards

Stefan

Re: DB statistics

Former Member — Wed, 25 Feb 2009 11:05:49 GMT

Hi,

You can also use DB13 for the same.

https://www.sdn.sap.com/irj/scn/wiki?path=/display/maxdb/howtoexecuteUpdateStatistics

Hope this helps.

Manoj

Re: DB statistics

Former Member — Wed, 25 Feb 2009 11:14:02 GMT

Hi Sudhakar,

Run TCode SA38 and enter RSSTAT* in the field Program then press F4 and then click execute ...you will find different Programs which are required for collecting statisics of DB and SAP along with their description.

Hope this will help you.

Regards,

Kalyan

Re: DB statistics

Former Member — Wed, 25 Feb 2009 11:32:13 GMT

Hi,

Please see below SAP Notes:-

588668 - FAQ: Database statistics.

403713 - BRCONNECT: Parallel updating of statistics

129252 - Oracle DB Statistics for BW Tables (if you are using a BW system)

You can run Update stats job from DB13 or BR*tools or just execute below command at OS level.

brconnect -u / -c -f stats -t ALL

DB stats should be uptodate or else it may give sever performance issues.

Hope this helps.

Thanks,

Sushil

Re: DB statistics

Former Member — Wed, 25 Feb 2009 12:58:25 GMT

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

Re: DB statistics

Former Member — Wed, 25 Feb 2009 16:05:24 GMT

you should have searched just a bit before asking such as basic question.

Re: DB statistics

Former Member — Thu, 26 Feb 2009 06:59:27 GMT

Hi Sudhakar,

RSDB_TDB is the report to get DB statistics in DB02.

Hope this is what you are looking for.

Regards,

Kalyan