RAT Replay Runs Too slow Waiting on WRR_ROOT_REPLAY_DATA While Running Query with many Timestamp Columns

(Doc ID 2361794.1)

Last updated on FEBRUARY 21, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

SQL_ID: 3d3vv7wkrahus

SQL_Text: Select call_ctr, rank, data_type, value from
WRR_ROOT_REPLAY_DATA where file_id = :file_id and call_ctr > :call_ctr order
by call_ctr, rank, data_type

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms