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 ?