Super-Sizing PGA Workareas in Oracle 12c
By Martin | September 17th, 2017 | Category: 12cR1, Performance Tuning | No Comments »After a customer asked me for possibilities of super-sizing PGA workareas in version 12c, I took the chance to revisit the topic and perform some tests. Great material has already been posted by late Alex Fatkulin (Hotsos Symposium 2014) and Norbert Debes (Secrets of the Oracle Database, Apress), but I wanted to verify, how the current release is behaving and I found some interesting things.
Super-Sizing PGA Workareas in 12c