How do I go about finding the plan that Oracle is using before and after the slowdown? I am aware that there are tools available but have never run them. Could you provide some guidance?

I have updated the DB_BLOCK_BUFFERS as you suggested. I'll see if this makes a difference.

Thanks again.