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)?
Requires Free Membership to View
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

Join the conversationComment
Share
Comments
Results
Contribute to the conversation