Yup, its a parallel query issue. You (probably) need more TEMP when operating with PQ. If you are not specifying your degree with a hint, you might look at the tables involved. They probably have a degree > 0. To turn PQ off, you can override the default degree with +PARALLEL(table_alias,1).