UK Oracle User Group

How Much Memory is Truly Used By My Oracle Instance?

Published: 17.03.2017

Oracle Scene - Issue 62

There are many articles about the amount of memory that is taken by the Oracle Database executables and the database SGA and PGA. The reason for the article is to answer the question "Can I set the SGA_MAX_SIZE parameter to a value higher than the SGA_TARGET parameter - without a penalty?"

We'd love to get your feedback on this; you'll need a UKOUG login to provide it, so if you don't have one, please click on 'create a web profile' first.