Oracle Replay: "Common SQL By Total DB Time" of "Compare Period Report" - ORDER BY FORCE_MATCHING_SIGNATURE INSTEAD OF TOTAL_DB_TIME
(Doc ID 2585019.1)
Last updated on SEPTEMBER 06, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
On : 18.104.22.168 version, RDBMS
Customer is running Oracle Replay, Capture 22.214.171.124.0, Replay 126.96.36.199.0.
In "Common SQL By Total DB Time" part of "Compare Period Report", the top SQLs are not really top ones in their DB. It turned out that those SQLs are ordered by force_matching_signature.
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