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

Real-time SQL performance review via SGA

Avatar photoCustomer Questions & Answers 5 replies

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?

5 replies

  • Support Enginatics

    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

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

  • Support Enginatics

    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

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

  • Support Enginatics

    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.

  • You must be logged in to reply to this post.