Did you analyze the table? How long did the process take? Did anything appear in V_$SESSION_LONGOPS for the process?