DB statistics can be done at the end of upgrade of Oracle10->11

[Former Member]

Hello

Might be a strange question but I guess executing DB statistics can be done at the end of upgrade of Oracle10->11

i.e.

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

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

and

brconnect -c -u / -f stats -t all -f
collect -p 4

Thank you as this takes too much time of beein attended

Kr

Jan

[ACE-SAP]

Hello

Yes of course, you should update the statistics this is part of the post upgrade tasks.

Do not forget also to:

- apply the latest version of the script from note 1020260 - Delivering Oracle statistics

- apply recommendations from note 974781 - Oracle internal maintenance jobs  to disable Oracle automatic job for statistics update.

Setting the here under option in Br*Tools configuration file (initSID.sap) you can make sure that system & DDIC statistics are compute during statistic update.

1235952 - Minor functional enhancements in BR*Tools (2)

To activate this update, set the following init<DBSID>.sap parameters:

stats_dict_cycle = <days>

stats_system_cycle = <days>

Regards,

[Reagan]

Hello Jan

Collecting statistics is one of the post upgrade tasks.

But when you start the DBUA for the upgrade and if it warns you about stale statistics then you can run the statistics collection.

Check the upgrade guide as it is clearly mentioned in it.

https://websmp210.sap-ag.de/~form/sapnet?_SHORTKEY=00200797470000089041&_SCENARIO=011000358700000002...

Regards

RB