Excessive Trace Generation in Foreground and/or Background Trace Files
Last updated on NOVEMBER 30, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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
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.
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