on 02-25-2009 10:44 AM
Hi All
what is the program that we run to get the statistics of the database.
Hi Sudhakar,
RSDB_TDB is the report to get DB statistics in DB02.
Hope this is what you are looking for.
Regards,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you should have searched just a bit before asking such as basic question.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
11 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.