Are you sure?? There might be sorting perofrmed by Oracle itself, if not by any other user. The only way to clean out the temp ts is to bounce the db.