How does Exadata change the SGA (system global area) caching dynamic? Can you explain in detail how it will affect SGA and PGA (program global area)?
The only real way that Exadata affects the SGA is that blocks returned from Smart Scan operations are returned to the PGA, rather than the SGA. The SGA and PGA are optimally configured to handle this scenario on installation.
This was first published in May 2011