Originally posted by slimdave
You might get something useful from V_$SESSION_LONGOPS
Excellent...