MANY TRACE FILES ARE GENERATED FOR PARALLEL RECOVERY IN BDUMP

(Doc ID 466859.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.1 [Release 10.1 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.
***Checked for relevance on 01-Sep-2017***

Symptoms

Many trace files are produced in the background_dump_dest by parallel slave processes named as <instance_name>_pXXX_<OSPID>.trc

Changes

Content of trace files:

*** SERVICE NAME:(SYS$BACKGROUND) 2007-11-07 10:43:07.969
*** CLIENT ID:() 2007-11-07 10:43:07.969
*** SESSION ID:(2577.1512) 2007-11-07 10:43:07.969
*** 2007-11-07 10:43:07.969
Start recovery for domain 0, valid = 0, flags = 0x1
*** 2007-11-07 10:43:40.642
KCRP: blocks claimed = 1964, eliminated = 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 3
Average hash chain = 1964/1902 = 1.0
Max compares per lookup = 2
Avg compares per lookup = 65/1964 = 0.0
----------------------------------------------

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