From the course: Oracle Database 12c: Administration
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
SGA and PGA sizing - Oracle Database Tutorial
From the course: Oracle Database 12c: Administration
SGA and PGA sizing
- [Narrator] Let's put some theory into practice. Now that we know what's inside the Oracle SGA and what is the role of the PGA let's talk about how we can size both of them correctly. This is super important. As it's up to the database expert to decide how much memory will be allocated to Oracle and how much memory will be provided for the SGA compared to the PGA. We can control the size of the SGA using two parameters. SGA Target and SGA Max Size. Based on these parameters Oracle by itself will derive the sizing for other individual SGA components. Such as the Buffer Cache, the Shared Pool, and the Radio Log Buffer. As an example, we can configure an SGA Target for 64 GB and the SGA Max Size for 128 GB and have Oracle dynamically resize the SGA between 64 GB and 128 GB of memory depending on workload characteristics. On the other hand, when sizing the PGA we set the PGA Aggregate Target parameter to equal the total amount of memory. We want available 40 PGA but across all server…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.