My Oracle Support Banner

Some Rows Are Missing In $K Table After Manual Sync Of Index With SMALL_R_ROW Enabled (Doc ID 2368538.1)

Last updated on MARCH 26, 2018

Applies to:

Oracle Text - Version 12.2 BETA1 and later
Information in this document applies to any platform.

Symptoms

After synchronizing Oracle Text indexes, dr$pending and dr$waiting are empty, however, not all rows are in the $K table.
If some of the missing rows are updated, not all of them appear in dr$pending / dr$waiting. The rows are stuck in the $U table.

Additional syncing does not change the situation and rowids are stuck in $U forever preventing the part of new rows to be indexed.

 

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!


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