Home › Discussions › Questions & Answers › Reviewing Database Memory Configuration for EBS
Customer · · Questions & Answers · 7 replies
We are reviewing our database performance best practices. We need to confirm if our SGA and PGA are optimally sized according to available server RAM. Which Blitz Report should we use?
The DBA SGA+PGA Memory Configuration report is ideal for this. It displays the current SGA and PGA memory configuration in gigabytes, comparing it to the available hardware resources, which is crucial for identifying if you are fully utilizing physical RAM.
What is the general performance tuning recommendation regarding SGA and PGA sizing for maximum performance?
The goal is to configure the SGA and PGA aggregate target to use nearly all the physical memory on your server, leaving a few gigabytes for OS-level caching and process memory. Optimal sizing of the buffer cache and shared pool within the SGA is particularly critical.
We use Linux; does this report also help check if HugePages are configured correctly?
Yes, the description of this report outlines how to check if HugePages are configured using Linux commands (`grep Huge /proc/meminfo`) and provides guidance on configuring `vm.nr_hugepages`. Remember that only SGA allocation benefits from large/huge pages.
If I need guidance on resizing the SGA, is there a report that provides estimates of the impact?
Yes, the DBA SGA Target Advice report shows Oracle’s estimation of how resizing the SGA would affect overall database time and I/O.
Sign in with LinkedIn or Google to take part.
