DBA SGA SQL Performance Summary – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Database SQL performance summary from the SGA to give an overview of top SQL load and performance issues. The purpose of this report, compared to ‘DBA AWR SQL Performance Summary’ is to retrieve SQLs which are not in the AWR, either becasue they ran after the most recent snapshot or because their performance impact is too small to be written to the AWR (see topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). This is useful for example to: -Identify SQLs executed by a particular program or UI function without running a trace. Navigate to the UI functionality first, then directly after, execute this report and restrict to the module name in question. Sort by column ‘Last Active Time’ -Identify SQLs and example bind variables to reproduce a SQL execution in a DB access tool. Switch parameter ‘Show Bind Values’ to ‘Yes’ -Identify SQLs incorrectly using literals instead of binds. Set parameter ‘Literals Duplication Count’ to a value bigger than zero to show all SQLs which are at least duplicated this numer of times.

Report Parameters

SQL Text contains, Module Type, Module contains, SQL Id, Plan Hash Value, Show Bind Values, Schema, Package Name starts with, First Load Time From, Last Active from, Last Active to, Time Basis Days, Minimum Days Active in SGA, Minimum Executions in SGA, Literals Duplication Count, Examples per Duplicate, Command Type, Exclude Command Type, Using Index, Order By, Exclude PLSQL Code, Exclude SYS User

Oracle EBS Tables Used

obj$, v$parameter, gv$sqlarea, gv$sql_bind_capture

Report Categories

Enginatics

DBA AWR SQL Performance Summary, DBA SGA Active Session History, DBA SGA Blocking Session Summary, DBA AWR Blocking Session Summary, DBA AWR Active Session History, DBA Blocking Sessions, DBA SGA SQL Execution Plan History, DBA SGA+PGA Memory Configuration, FND Concurrent Requests 11i

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output DBA SGA SQL Performance Summary 11-May-2017 124450.xlsx
Blitz Report™ XML Import DBA_SGA_SQL_Performance_Summary.xml
Full SQL on Enginatics www.enginatics.com/reports/dba-sga-sql-performance-summary/

Case Study & Technical Analysis

Abstract

The DBA SGA SQL Performance Summary report provides a snapshot of the most resource-intensive SQL statements currently in the database memory. It fills the gap left by AWR reports, which only capture the “Top N” SQLs at hourly intervals. This report is essential for identifying “flash” performance issues—queries that run frequently or poorly for a short period but don’t sustain enough load to be persisted to AWR.

Technical Analysis

Core Features

Key Views

Operational Use Cases

© 2026 Enginatics