Excessive Amount Of Tracefiles Being Generated in 11G (Doc ID 785642.1)

Last updated on APRIL 02, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 11.1.0.7

Checked for relevance on 21 June 2012


Symptoms

Excessive amount of trace files generated, about 15-20 trace files per minute, filling up the trace directory

The trace file contains entries as follows:
*** 2009-02-23 20:53:25.037
*** SESSION ID:(121.62063) 2009-02-23 20:53:25.037
*** CLIENT ID:() 2009-02-23 20:53:25.037
*** SERVICE NAME:(SYS$USERS) 2009-02-23 20:53:25.037
*** MODULE NAME:() 2009-02-23 20:53:25.037
*** ACTION NAME:() 2009-02-23 20:53:25.037

XS Users and Roles -- OCI Info
kzxupnamread error -- OCI No Data

.

May also see the second line of the error in the trace report errors:    e.g. kzxupnamread error -- 942: ORA-00942: table or view does not exist

Cause

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