still i think what slimdave is saying is true ub query is getin executed 52128446 times so i have asked developer to change login probabily going for cursor or some thing with bulk collect