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

[jamal_asi]

The statement brconnect -c u / -f stats -t all -f collect -p 4 statement which is executed as part of the upgrade from oracle 9i to oracle 10g is taking about 10 hours to run. Did any of you have this problem? How did you go about solving this or shortening the time it takes to run this statement?

Any suggestions or advise is appreciated!

[fidel_vales]

Hi,

As mentioned it depends on the hardware and DB isze. The last option indicates the parallelizatiion level:

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

If you have more than 4 CPUs in the server (and nothing else running there) you can adapt it to use a higher parallelization (before you start it)

[former_member227600]

it's depend on your hardware & OS configuration you can increase parallel process . In one of my project scenario ,In quality box this script has run around 18 hours & in production it completed within 4 hour.

[Former Member]

I'm not sure, but it might help if you first run the system stats.

Kind regards,

Mark