My Oracle Support Banner

Large number of trace files are generated in diagnostic dest directory (Doc ID 2740973.1)

Last updated on MARCH 04, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Large number of traces are generating in dump location of below format

*** CONTAINER ID:(3) 2020-12-28T19:52:55.990751+00:00

#Rows: 56704 SSZ: 0 LGR: 0 #Blks: 91558 AvgRowLen: 2766.00 NEB: 0 ChainCnt: 0.00 ScanRate: 0.00 SPC: 0 RFL: 0 RNF: 0 CBK: 0 CHR: 0 KQDFLG: 1
#IMCUs: 0 IMCRowCnt: 0 IMCJournalRowCnt: 0 #IMCBlocks: 0 IMCQuotient: 0.000000
Column (#12): TRAN_ID(VARCHAR2) Part#: 0
AvgLen: 18 NDV: 11807 Nulls: 0 Density: 0.000085 Min: 0.000000 Max: 0.000000
Histogram: HtBal #Bkts: 5530 UncompBkts: 5530 EndPtVals: 0 ActualVal: yes
#Rows: 70388 SSZ: 0 LGR: 0 #Blks: 356130 AvgRowLen: 169.00 NEB: 0 ChainCnt: 0.00 ScanRate: 0.00 SPC: 0 RFL: 0 RNF: 0 CBK: 0 CHR: 0 KQDFLG: 1
#IMCUs: 0 IMCRowCnt: 0 IMCJournalRowCnt: 0 #IMCBlocks: 0 IMCQuotient: 0.000000
Column (#17): TRAN_ID(VARCHAR2) Part#: 0
AvgLen: 18 NDV: 17815 Nulls: 0 Density: 0.000056 Min: 0.000000 Max: 0.000000
Histogram: HtBal #Bkts: 5500 UncompBkts: 5500 EndPtVals: 0 ActualVal: yes
#Rows: 824 SSZ: 0 LGR: 0 #Blks: 79474 AvgRowLen: 792.00 NEB: 0 ChainCnt: 0.00 ScanRate: 0.00 SPC: 0 RFL: 0 RNF: 0 CBK: 0 CHR: 0 KQDFLG: 1
#IMCUs: 0 IMCRowCnt: 0 IMCJournalRowCnt: 0 #IMCBlocks: 0 IMCQuotient: 0.000000
Column (#2): AGG_CTX_ID(VARCHAR2) Part#: 0
AvgLen: 17 NDV: 318 Nulls: 0 Density: 0.003142 Min: 0.000000 Max: 0.000000
Histogram: HtBal #Bkts: 826 UncompBkts: 826 EndPtVals: 0 ActualVal: yes

Changes

Upgrade to 12.1.0.1 or 12.2

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.