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

[Former Member]

We are are doing a simulation of upgrading our SAP instances from oracle 9 to 10 as per the SAP oracle upgrade guide for unix , we have reached the post upgrade steps where we have to run

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

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

The above statements take more than 2 days to finish, why do they take such a long time and how can we speed up their runs as we will have to run these when we do the real production upgrade meaning downtime

[Former Member]

you can specify the time in minutes you want to run the system stats..

[Former Member]

we cannot go to brtools 7 as our kernel is 640

brtools -version

BR0651I BRTOOLS 6.40 (52)

Patch Date Info

36 2006-01-11 Small functional enhancements in BR*Tools (note 914174)

38 2006-03-29 BR*Tools support for MDM databases (note 936665)

40 2006-08-30 Wrong message numbers in BR*Tools 6.40 (note 976755)

43 2007-04-26 BR*Tools failing with ORA-01455 for database > 16 TB (note 1050

329)

44 2007-05-31 New BR*Tools command options (note 1060696)

release note 680046

kernel release 640

patch date 2010-01-14

patch level 52

make platform hpia64

make mode OCI_920

make date Jan 30 2010

[anindya_bose]

Hi..

You can use brtools 700 I guess. For our system we have 640 Kernel with BRtools 700 patch level 41 ( OS=windows).

Check the note below Note 12741 - Current versions of BR*Tools and SAPDBA

Regards

Anindya

Edited by: Anindya Bose on May 19, 2010 2:18 PM

[Former Member]

Yes all of the mentioned items have been already completed succesfully. we are following the exact steps as per the SAP upgrade manual

[anindya_bose]

What is the BRTOOLS release version and patch level?

Are you using BRTOOL 700 and latest patch level.

This problem could be due to patch level also..Try to upgrade and see the result.

Regards

Anndya

[Former Member]

Have you installed the interim patches as well? And check the parameter recommendations for Oracle 10g in note 830576.

Also check if parameter RECYCLEBIN = OFF

Kind regards,

Mark