Home › Discussions › Questions & Answers › Real-time SQL performance review via SGA

Real-time SQL performance review via SGA

Avatar photoCustomer July 9, 2020 at 1:37 pm

We noticed a sudden brief slowdown associated with a custom program, but the SQL executed hasn’t shown up in our standard AWR reports yet. How can I analyze this recent, potentially low-impact SQL?

Viewing 4 reply threads
  • Author
    Replies
    • Support July 11, 2020 at 10:50 am  

      You should use the DBA SGA SQL Performance Summary report. The purpose of this report is specifically to retrieve SQL statements from the Shared Global Area (SGA) that might not have been written to AWR because they ran too recently or their performance impact was too small.

    • Avatar photoCustomer July 13, 2020 at 2:01 am  

      That sounds useful. Can I restrict the results just to the SQL run by that specific custom program or UI function?

    • Support July 15, 2020 at 12:44 am  

      Yes. Navigate to the UI functionality or run the program first, and immediately after, execute the report. You can then restrict results by the ‘Module Name’ parameter and sort by the ‘Last Active Time’ column to find the recent executions associated with that module.

    • Avatar photoCustomer July 16, 2020 at 7:33 am  

      How do I ensure I capture the actual bind variable values used, which are critical for reproducing the issue?

    • Support July 17, 2020 at 2:05 pm  

      Set the parameter ‘Show Bind Values’ to ‘Yes’ in the DBA SGA SQL Performance Summary report. This will help you identify the SQL and example bind variables needed to reproduce the exact execution path in a database access tool.

  • Author
    Replies
Viewing 4 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™ 123751

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

Oracle Discoverer replacement – importing worksheets into Blitz Report™ 14617

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

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

Oracle E-Business Suite 12.2.8 upgrade to version 12.2.9 11966

Oracle E-Business Suite 12.2.7 upgrade to version 12.2.8 9900

Migration to Java Web Start in Oracle EBS 12.2 instance 9894

Securing sensitive data with Oracle VPD 7799

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

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