Excessive Trace Generation in Foreground and/or Background Trace Files
(Doc ID 2334195.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!