dr$pending and dr$waiting
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?