DB statistics

[Former Member]

Hi All

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

[Former Member]

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