BRCONNECT for Database Statistics

[Former Member]

Hi,

We have oracle 9.2 database with SAP 4.6B. We use BRCONNECT (6.20) for updating database Statistics. This takes about 5 to 6 hours to complete.

Command used = brconnect -u / -c -f stats -t all -m +I -s P10 -f allsel,collect,method,precision -p 8

Could you please help, investigating the reason for such a long run?

Also, if any OSS notes need to applied.?

Please, let me know, if additional info needed..

Thanks,

Sam

[Former Member]

Hi SAM,

Our DB size=104 GB. it run ONLY 5 mins.

I think, may be you have to be upgrade the BRtool for fix some bugs.

Rgds,

SakolK.

[Former Member]

Many factors play here. Size of database, memory, dba parameters and CPU, plus OS (32 bit or 64). There are some more factors, but you get the idea here.

We have production with 37 GB of memory and 3 CPU on HP 64 bit system taking 2 hours for a 500 GB database, but the same size database takes 6 hours on a much slower sandbox.

We only run Statistics once a week, but on both tables and indices.

Hopes this helps you get your answer quicker.

[Former Member]

Thanks...

May be if some others postings on config. and time taken to run the BRConnect statistics could used as a bench mark to understand, where our system stands..

[Former Member]

my system which has 2 cpus and 4GB ram and DB size is of 35GB is taking 8 minutes for the statistics run.

Ofcourse the sysytem is not live yet.

[Former Member]

Hi,

Wondering if applying <u>OSS Note - 871455</u> could resolve this issue?

Is there any other command options, to avoid unnessary data collections by BRconnect could be thought of, to reduce the long runtime?

Command used:

brconnect -u / -c -f stats -t all -m +I -s P10 -f allsel,collect,method,precision -p 8

Thanks,

Sam

[Former Member]

We ran BRConnect in Dev system with 4.7 upgrade + Oracle 9.2.0.7 + Prod data , gives significant improvements. Now the runtime is approx 1.5 hours.. ( it was 7 hours earlier !!)

Thanks to all..

Sam

[kevshill]

Hi Sam,

So finally what was the difference between you dev system and your prod system?

Was it just the 4.6B and 4.7 or was there a difference in the oracle patchset as well?

Were there any differences in the brconnect parameters?

regards,

Kevin Hill

[Former Member]

Yep.. There was a Oracle Patch also..

In Prod sys - Oracle 9.2.0.4

In Dev Sys - Oracle 9.2.0.7

No changes in BRconnect Parameter.. we used the same command line.

I think, the oracle patch has improved the runtime.

Thanks,

Sam