Skip to Content
avatar image
Former Member

stat generation with brconnect

Hi Experts , I am running stat generation twice in a week with the following parameters in our production database,

brconnect -u / -c -f stats -f allsel,collect,method,keep -t ALL -p 6 -m CI

just wondering if it is standard practice twice weekly.

I found that DB is very slow during the stat generation

Is it possible that bigger table takes longer time to generate stat and table is locked for any update during the stat generation ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 22, 2017 at 01:34 PM

    Hi,

    Basically it is recommended to generate/update statistics at least once weekly or once daily. Creating statistics does not block any database objects, but it is an I/O-intensive database operation involves additional CPU and I/O load.

    For more details, you can also refer to the below SAP Notes:
    588668 - "FAQ: Database statistics"
    806554 - "FAQ: I/O-intensive database operations"

    Regards,
    Bíborka

    Add comment
    10|10000 characters needed characters exceeded