too many entries for one single session and serila# in V$Session_longops
you should review your query,  missing s.sid = sl.sid.  Besides, wher yout lokk at v$session_longops and find many rows, they all meet the other conditions - sl.elapsed_seconds > 25*60 and sofar&lt;>totalwork ?