SQL Performance Analyzer Report Shows Only 100 SQL Statements
(Doc ID 795185.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199.0 [Release 11.1 to 11.2]
Information in this document applies to any platform.
- The SQL Performance Analyzer Graph in OEM for metric "SQL Statement Count" shows more than 100 unchanged SQL statements
- Clicking on the graph to get the list of all unchanged SQL statements only shows 100 or less queries.
- The "Plan Unchanged SQL Statements" section never shows more than 100 rows even though the bar graph shows more.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.