Oracle Text (MOSC)

MOSC Banner

dr$pending and dr$waiting

edited Sep 16, 2013 4:59AM in Oracle Text (MOSC) 3 commentsAnswered

According to Note 104202.1, DML on a text indexed column will insert a row in dr$pending unless the rowid is already there, in which case it goes into dr$waiting.  The view CTX_USER_PENDING easily shows what's pending, but does not include what's waiting.  Is there any view that does show what's waiting?  Or even better, is there a view that shows what's pending AND what's waiting?

That note also says that an insert will put a row into dr$pending even if the value in the text index column is null. 

I have a multi_column_datastore text index on eight columns (each is varchar2(1000)).  When the data comes to the database, most but not all of these columns have a null value.  Users are allowed to update these columns later.  It seems that the sync of this index for the initial insert is taking a long time, even when all eight values are null.  What can be done to speed this up?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center