Home › Discussions › Questions & Answers › Reviewing Database Memory Configuration for EBS

Reviewing Database Memory Configuration for EBS

Avatar photoCustomer September 15, 2022 at 4:25 pm

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?

Viewing 6 reply threads
  • Author
    Replies
    • Support September 17, 2022 at 1:11 am  

      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.

    • Avatar photoCustomer September 18, 2022 at 4:49 am  

      What is the general performance tuning recommendation regarding SGA and PGA sizing for maximum performance?

    • Support September 18, 2022 at 10:07 pm  

      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.

    • Avatar photoCustomer September 20, 2022 at 6:43 pm  

      We use Linux; does this report also help check if HugePages are configured correctly?

    • Support September 22, 2022 at 1:34 am  

      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.

    • Avatar photoCustomer September 23, 2022 at 4:38 pm  

      If I need guidance on resizing the SGA, is there a report that provides estimates of the impact?

    • Support September 24, 2022 at 11:38 am  

      Yes, the DBA SGA Target Advice report shows Oracle’s estimation of how resizing the SGA would affect overall database time and I/O.

  • Author
    Replies
Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with:
Popular Posts
How to track master data changes using Oracle EBS Audit function and Blitz Report™ 123992

Oracle Enterprise Command Center Framework Release 12.2 installation and integration with Oracle EBS 12.2.8 20560

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14853

How to check if a patch is applied in Oracle EBS 12.2 14616

Oracle Discoverer 11.1.1.7 installation and integration with Oracle EBS R12.1.3 14264

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 12113

Migration to Java Web Start in Oracle EBS 12.2 instance 10115

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 10071

Securing sensitive data with Oracle VPD 8061

EBS 12.1.3 BI Publisher Excel templates generate XLS instead of XLSX and limit row number to 65,536 6638

Blog Archive
2026
2025
2024
2023
2022
2021
2020
2019
2018
2017
Recent Events
2026
2027
2036
2025
2024
2023
2022
2021
2020
2019
2018