alter session set sort_area_size = blal...

seemed to the job for now. Other ideas are welcome.