I came across this situation in the 1st of this month. Suddenly one user informed me that one of his program ( Customised ABAP) which usually takes 8 hours to finish running almost three days and not finished yet. Neither did it got canceled.
Although I saw a single efficient SQL statement from this particular program is hitting database more than a few million times, only thing that is pinching….This program normally takes 8 hours to finish and executed everyday, suddenly what happened? Found primary key and indexes are fine…….
Trace of the process is showing that it is in the heap and the heap limit is also achieved….
The whole damn thing sent me back once again to my study desk….