Brconnect update statistics

[Former Member]

Hi mate

I have a doubt with respect to the following stats command

brconnect -u / -jid STATS20100612050000 -c -f stats -t ALL

When I checked the log for the past 3 weeks, I found that for few of the table stats was updated rarely,even though the command includes the term ALL .

How does this happens, will it calculate with anyother things

Regards

Subramani

[Former Member · Accepted solution]

Hi Subramani,

Before brconnect collects the statistical information, it checks whether the stats should be collected or not. By using -t ALL parameter, you are collecting stats for all tables, but only required stats will be updated.

Best regards,

Orkun Gedik

[Former Member]

Thanks a lot, your reply made things clear

[Former Member]

Hello Subramani,

per default the statistics are only updated if the number of rows has changed

by 50% (that is declined or increased by 50%). The brconnect parameter is

stats_change_threshold = 50

.

You can decrease this to 10% by changing your command to:

brconnect -u / -jid STATS20100612050000 -c -f stats -t ALL -c 10

Now you should see many tables receiving statistics updates.

Please note that this doesn't necessarily means that Oracle execution

plans improve. See [SAP note 1057511|https://service.sap.com/sap/support/notes/1057511].

Regards,

Mark