What Is Triggering The Delete statements From Ctxsys.dr$sqe,ctxsys.index_set,ctxsys.index_set_index. (Doc ID 2126120.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Text - Version 11.2.0.4 and later
Information in this document applies to any platform.

Goal

The Audit trail of a database is listing extra records in the aud$ table other then the audited statements executed by users such as SCOTT and APPS.
The extra statements referenced have an owner of CTXSYS and are statements like :

delete from ctxsys.dr$sqe
delete from ctxsys.dr$index_set
delete from ctxsys.dr$index_set_index

Why are these statements being generated?
 

Solution

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