After some investigation I found that:
- cr_rev_content_index is in VALID state and SWS is working,
- DR$CR_REV_CONTENT_INDEX$I table has 15million rows in it (after indexing cr_revision with 10000 rows)
- ERROR on INSERT in News package (this was working before, and News package was not touched)
Errow in News on insert new item.
Error: ora8.c:3930:ora_tcl_command: error in`OCIStmtExecute ()':
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at "MYUSER.ACS_CONTENTS_SWS_UTR", line 6
ORA-04088: error during execution of trigger 'MYUSER.ACS_CONTENTS_SWS_UTR'
ORA-06512: at "MYUSER.CONTENT_REVISION_UTRG", line 5
ORA-04088: error during execution of trigger 'MYUSER.CONTENT_REVISION_UTRG'
ORA-06512: at "MYUSER.NEWS", line 208
ORA-06512: at line 4
SQL:
begin
news.set_approve(
approve_p => 't',
revision_id => :id,
publish_date => :publish_date_ansi,
archive_date => :archive_date_ansi,
approval_user => :approval_user,
approval_date => :approval_date,
approval_ip => :approval_ip,
live_revision_p => :live_revision_p
);
end;
this is a little too much for 4 o'clock in the morning,
what is domain index that is marked as FAILED? all indexes are shown as VALID in MYUSER schema.
Ideas?