Excessive Trace Generation in Foreground and/or Background Trace Files

(Doc ID 2334195.1)

Last updated on NOVEMBER 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Database (RAC or Single Instance) is generating excessive trace file sizes for Foreground and/or Background trace files.  Many of these files will grow rapidly in size (particularly Shared Server and Foreground traces).  Review of the generated trace files show SQL_TRACE types of events in the trace. Keywords indicating SQL_TRACE or 10046 (event for SQL_TRACE) is enabled include:

PARSING IN CURSOR
PARSE
BINDS
EXEC
FETCH
WAIT
CLOSE

Here is an example of a foreground trace:

 <MOS Document 436036.1> (How To List All The Named Events Set For A Database) was reviewed and verified that NO EVENTS were set/enabled.

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