Thank you for this information!
Our block buffers were 0 and we have set them to 32mb.
We were using auto memory, but have switched so we can play with the parameters.
The mem_max_target and mem_target are at 5gb ea.
I would be curious to see what we should set the other parameters to that you listed?
I have spooled our parameters to a text file.
If it would be helpful, I could send that to you if you wanted to take a look at them?
Appreciate all your help as we are lost on this one.