Database Administration (MOSC)

MOSC Banner

Questions regarding ctxsys.ctx_index_errors

edited Dec 18, 2019 1:37PM in Database Administration (MOSC) 8 commentsAnswered ✓

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:

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