Questions regarding ctxsys.ctx_index_errors
Hi
Oracle 12.1.0.2.0
OEL 7.6
I have noticed that top sysaux occupant is TEXT
OCCUPANT_NAME SPACE_USAGE_MB------------------------------ --------------TEXT 1419.69
While checking closer, seems like it is domain index
CTXSYS DR$INDEX_ERROR
So, checking from table ctxsys.ctx_index_errors:
SQL> select err_index_name, min(err_timestamp), max(err_timestamp), count(1) as arv from ctxsys.ctx_index_errors group by err_index_name;ERR_INDEX_NAME MIN(ERR_T MAX(ERR_T ARV------------------------------ --------- --------- ----------LEIAMENET_NIMETUS_CTX 20-MAR-19 20-MAR-19 1LEIAMENETOSAL_K_NIMI_CTX 27-APR-18 16-DEC-19 3865587LEIAMENET_KOHT_PEALK_CTX 10-MAY-18 24-JUL-19 3
So there are nearly 4m rows for certain index. The error message for all of these is: