Statistic

[Former Member]

Hi All,

During update statistic schedule in DB13, will it also regenerate locked statistics? If not, how is "regenerate locked statistics" being done?

Regards

Lauran

[Former Member]

Hello ,

You can update the statistics for tables with locked statistics with below command

For Oracle 10.1:

brconnect -u / -c -f stats -t locked -f unlock,lock

For Oracle 10.2:

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

Also you can Unlocking statistics for tables with locked statistics

brconnect -u / -c -f stats -t locked -f unlock

Regards,

Reema Verma

[JPReyes]

@Reema,

That information is contained on the notes above,

Also Oracle 10.1?.... That is certainly not supported by SAP

Regards

Juan

[JPReyes]

Read,

SAP Note 588668 - FAQ: Database statistics

SAP Note 892296 - Enhancements in update statistics in BRCONNECT 7.00/7.10

That should answer your question

Regards

Juan