You might get something useful from V_$SESSION_LONGOPS