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.
Dig Deeper on Oracle database performance problems and tuning
Related Q&A from Rick Greenwald
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata. Continue Reading
One reader asks whether Cache Fusion for Oracle RAC is implemented differently on Oracle Exadata compared to other platforms. Continue Reading