Did you take trace of this session before killing it?
If yes analyze that, or take the sql, analyze the explain plan.