CTXSYS.SYS_IOT_TOP_% Object Is Growing Steadily In SYSAUX Tablespace
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Text - Version 18.104.22.168 and later
Information in this document applies to any platform.
- There is an IOT index segment that has started to grow steadily in the SYSAUX tablespace.
- It belongs to the CTXSYS user.
- Running the following query it can be seen that the base table is DR$PENDING and DR$PENDING contains a lot of rows:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms