Skip to Content
author's profile photo
Former Member

Brconnect update statistics

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 04, 2011 at 09:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 07:04 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 08:30 AM

    Thanks a lot, your reply made things clear

    Add comment
    10|10000 characters needed characters exceeded