I have an mview refresh job. I wish to have it repeat every 2 hrs. ie
first check the staleness - if not =FRESH then refresh it.
My question is what if run 2 wakes up while run 1 is not finished?
It's somewhat fussy in my memory now but i think I once read somewhere that if run 2 catches run 1 on the way, then run 2 would not run. Can anyone confirm?