Hi,
We occassionally - twice in last year have an etl job fail when it is trying to a refresh a materialized view against which constraints have been defined. No changes in etl jobs and no other etl jobs running at around this time.
Been suggested internally could be some automatic stats gathering job database does which occasionally takes ages ?
How can we identify exact cause of the lock and if foudn to be this auto stats gathring job database does, adjust the window this operates in.
Thanks