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.
- Bind Variable Capture: Retrieves values from
GV$SQL_BIND_CAPTURE, allowing developers to reproduce the issue in a separate session with actual data. - Literal Analysis: Includes a "Literals Duplication Count" to identify applications that are failing to use bind variables (hard parse storms), which can devastate CPU and Shared Pool performance.
- Granular Filtering: Allows filtering by module, user, or specific time windows (e.g., "Last Active Time").
GV$SQLAREA: Aggregated statistics for SQL statements (execution count, elapsed time, CPU time).GV$SQL_BIND_CAPTURE: Sampled bind values for the queries.
- Code Review: Identifying SQLs with high
DISK_READSorBUFFER_GETSper execution. - Ad-hoc Tuning: Quickly finding the SQL_ID for a query that a user complains is "slow right now."
- Security Audit: Checking for SQL injection patterns or unexpected queries from specific modules.