My Oracle Support Banner

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 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.0.1 version, RDBMS

ACTUAL BEHAVIOR
---------------

Customer is running Oracle Replay, Capture 11.2.0.3.0, Replay 12.2.0.1.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.

eg:

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.