Skip to Content
0

stat generation with brconnect

Feb 22, 2017 at 04:12 AM

41

avatar image
Former Member

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Biborka Greta Toth
Feb 22, 2017 at 01:34 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded