Updating Database Statistics Taking Long Time

[Former Member]

Hi Gurus,

I am installing ECC5.0 using "System Copy/ Oracle Backup/Restore" method.

I have restored DB successfully.

But in Database Statistics Update stage it is taking long time. almost 15Hrs gone.

How much time it takes normally ?

Should i restart the installation ?

My database size is 570GB

Please advice.

Regards

Alim

[Former Member · Accepted solution]

Are you executing the brtools or from DB13. If you are executing using brtools it all depends what inputs you have given.

Generally using brttols if you follow below path -

7. Database statistics - 1. Update Database staistics - 6. Change Threshold - 1%

If you are giving these inputs then it willl take long time. On my system for database of approximately 350 GB it took 12-14 hours. So 570 GB 15 hours is fine. It all depends on how many large tables on your system.

Thanks and Regards,

Kedar

[Former Member · Accepted solution]

Hi Kader

Thanks for you ans.

I am not running any command.

SAPINST automatically running brconnect command , command is as follows

brconnect -u / -c -f crsysn -o <dbname>

So i have to wait to finish this right ?

Regards

Alim

[Former Member · Accepted solution]

Yes you have to wait till it finish. If you can login to SAP, then you can check its log in DB14. It will give you detail log about what it is doing.

Thanks and Regards,

Kedar

[former_member227283 · Accepted solution]

Hi AliM,

Login to OS and check any logs are getting updated or not.

Thanks

Anil

[JPReyes · Accepted solution]

As Anil mentioned check if its still writing to the logs...

Anyhow in the future when running brconnect you can use swith -p and set the number of parallel processes so it goes faster 😄

Also make sure that your redologs are not full

Regards

Juan

[Former Member]

Hi all

I have solved the problem.

Thanks to all of you.

Regards

Alim

[Former Member]

Hi, what was the solution? I have the same error message; brconnect failed with sapinst and the brconnect.log is empty; but if I call that from OS level it is running correctly.

[Former Member]

Hi ,

Try to run this command for os level with orasid.

brconnect -u system/password -c -f stats -t all -p 4

Check how much time it takes.

Thanks

Rishi Abrol

[Former Member]

Hi

I am not running the command .

SAPINST is running the command while installing.

As i mentioned, I am installing ECC5.0 using "System Copy/ Oracle Backup/Restore" method.

And it is now on " Updating Database statistics" phase

brconnect log is not updating.

1. tail -f brconnect.log

BR0801I BRCONNECT 6.40 (38)

Oracle Alert log

Regards

Alim

[Former Member]

Hi Alim,

What is the output of df -k on oraarch (archivelog directory)?

Also what about oracle alrt log ?

Regards.

Ruchit.

[Former Member]

Hi

I have checked brconnect.log adn sapinst.log and these logs are not updating.

What to do now.

Regards

Alim

[JPReyes]

Did you check that the redologs are not full?

Regards

Juan

[Former Member]

Hi

Its not full

Regards

Alim

[JPReyes]

check the last entry on the brconnect log and post it here

Regards

Juan

[Former Member]

Hello Alim,

Just to elaborate on Juan's suggestion hope you are checking offline re-do log directory (/oracle/<DBSID>/oraarch) provided it is a unix OS.

Also check the oracle alert log.

Regards.

Ruchit.