We have been getting a lot of ora-04030-out of process memory errors lately.
I installed statspack on our database that is 29 terabytes. I noticed a lot of pct misses in the dictionary cache, library cache, and latch activity.
I am of the assumption that this is pointing to SGA problems. My boss seems to the think that it is PGA problems. Here is a copy of my report:
negative logical reads seems suspicious, no? I would try that again with a shorter duration, 'cos I wonder whether your numbers "wrapped round" in the 2 hour window you're using