Skip to Content
Former Member
Feb 22, 2017 at 04:12 AM

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 ?