My Oracle Support Banner

Database Ora_dia0_* Process Consumes High Memory Utilization (Doc ID 2787583.1)

Last updated on JUNE 29, 2021

Applies to:

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

Symptoms

Database ora_dia0_* process consumes High Memory utilization

<Instance>_dia0_21668_base_5.trc
==============================

*** 2021-06-07T23:02:45.794273-07:00 (CDB$ROOT(1))
2021-06-07 23:02:45.794 :kjzgrcfg_finalize(): Reconfig finished inc:31 state:5
2021-06-07 23:02:45.800 :kjzgrcfg_msghdlr(): Step 1 remote_inc:31 prop_inc:31 state:5 master:2
IPCLW:[0.124755339]{E}[WAIT]:PROTO: [1623132166001387]RETRANS DBG local acnh 0x7fe9aa139530 dump:
IPCLW:[0.124755340]{-}[WAIT]:UTIL: [1623132166001387]  ACNH 0x7fe9aa139530 State: 1 SMSN: 1655824697 PKT(1662191011.496113055) # Pending: 4096   >>>>>>>>>>>>>>>>>>>>>>>
IPCLW:[0.124755341]{-}[WAIT]:UTIL: [1623132166001387]   Peer: DIA0.KSXP_diag.30620 AckSeq: 496108959
IPCLW:[0.124755342]{-}[WAIT]:UTIL: [1623132166001387]   Flags: 0x20000000 IHint: 0x1d07ad590000001f THint: 0x52fe03630000001f
IPCLW:[0.124755343]{-}[WAIT]:UTIL: [1623132166001387]   Local Address: 192.xxx.xx.120:39061 Remote Address: 192.xxx.12.xxx:35575  >>>>>>>>>>>>>>>>>>>>>>>>>
IPCLW:[0.124755344]{-}[WAIT]:UTIL: [1623132166001387]   Remote PID: ver 0 flags 1 trans 2 tos 0 opts 0 xdata3 8227 xdata2 b8300501
IPCLW:[0.124755345]{-}[WAIT]:UTIL: [1623132166001387]             : mmsz 32768 mmr 4096 mms 4096 xdata b883f95f
IPCLW:[0.124755346]{-}[WAIT]:UTIL: [1623132166001387]   IVPort: 55103 TVPort: 63839 IMPT: 52824 RMPT: 33319   Pending Sends: Yes Unacked Sends: Yes   >>>>>>>>>>>>>>>>>>>>
IPCLW:[0.124755347]{-}[WAIT]:UTIL: [1623132166001387]   Send Engine Queued: Yes sshdl -1 ssts 0 rtts 1623132166002134 snderrchk 5 creqcnt 1 credits 0/8
IPCLW:[0.124755348]{-}[WAIT]:UTIL: [1623132166001387]   Unackd Messages 1662186915 -> 1662191010. SSEQ 496108959 Send Time: INVALID TIME SMSN # Xmits: 4227520 EMSN INVALID TIME   >>>>>>>>>
IPCLW:[0.124755349]{-}[WAIT]:UTIL: [1623132166001387]  Pending send queue:   >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
IPCLW:[0.124755350]{-}[WAIT]:UTIL: [1623132166001387]    [0] mbuf 0x7fe9aa178bf0 MSN 1662186915 Seq 496108959 -> 496108960 # XMits: 4227520
IPCLW:[0.124755351]{-}[WAIT]:UTIL: [1623132166001387]    [1] mbuf 0x7fe9aa1787d0 MSN 1662186916 Seq 496108960 -> 496108961 # XMits: 4227519
IPCLW:[0.124755352]{-}[WAIT]:UTIL: [1623132166001387]    [2] mbuf 0x7fe9aa1783b0 MSN 1662186917 Seq 496108961 -> 496108962 # XMits: 4227406
IPCLW:[0.124755353]{-}[WAIT]:UTIL: [1623132166001387]    [3] mbuf 0x7fe9aa177f90 MSN 1662186918 Seq 496108962 -> 496108963 # XMits: 4226663
IPCLW:[0.124755354]{-}[WAIT]:UTIL: [1623132166001387]    [4] mbuf 0x7fe9aa177b70 MSN 1662186919 Seq 496108963 -> 496108964 # XMits: 4226415
IPCLW:[0.124755355]{-}[WAIT]:UTIL: [1623132166001387]    [5] mbuf 0x7fe9aa177750 MSN 1662186920 Seq 496108964 -> 496108965 # XMits: 4225920
IPCLW:[0.124755356]{-}[WAIT]:UTIL: [1623132166001387]    [6] mbuf 0x7fe9aa177330 MSN 1662186921 Seq 496108965 -> 496108966 # XMits: 4225671
IPCLW:[0.124755357]{-}[WAIT]:UTIL: [1623132166001387]    [7] mbuf 0x7fe9aa176f10 MSN 1662186922 Seq 496108966 -> 496108967 # XMits: 4225423
IPCLW:[0.124755358]{-}[WAIT]:UTIL: [1623132166001387]    [8] mbuf 0x7fe9aa176af0 MSN 1662186923 Seq 496108967 -> 496108968 # XMits: 0
IPCLW:[0.124755359]{-}[WAIT]:UTIL: [1623132166001387]    [9] mbuf 0x7fe9aa1766d0 MSN 1662186924 Seq 496108968 -> 496108969 # XMits: 0
IPCLW:[0.124755360]{-}[WAIT]:UTIL: [1623132166001387]    [10] mbuf 0x7fe9aa1762b0 MSN 1662186925 Seq 496108969 -> 496108970 # XMits: 0
IPCLW:[0.124755361]{-}[WAIT]:UTIL: [1623132166001387]    [11] mbuf 0x7fe9aa175e90 MSN 1662186926 Seq 496108970 -> 496108971 # XMits: 0
IPCLW:[0.124755362]{-}[WAIT]:UTIL: [1623132166001387]    [12] mbuf 0x7fe9aa175a70 MSN 1662186927 Seq 496108971 -> 496108972 # XMits: 0
IPCLW:[0.124755363]{-}[WAIT]:UTIL: [1623132166001387]    [13] mbuf 0x7fe9aa175650 MSN 1662186928 Seq 496108972 -> 496108973 # XMits: 0

..
IPCLW:[0.124755336]{-}[WAIT]:UTIL: [1623132139996542]    [4094] mbuf 0x7fe9a135c880 MSN 1662191009 Seq 496113053 -> 496113054 # XMits: 0
IPCLW:[0.124755337]{-}[WAIT]:UTIL: [1623132139996542]    [4095] mbuf 0x7fe9a135c460 MSN 1662191010 Seq 496113054 -> 496113055 # XMits: 0
IPCLW:[0.124755338]{E}[WAIT]:PROTO: [1623132139996542]RETRANS DMP request sent to peer: 192.xxx.xx.122:35575, ret 1
2021-06-07 23:02:20.461 :kjzgrcfg_finalize(): Reconfig finished inc:31 state:5
2021-06-07 23:02:20.466 :kjzgrcfg_msghdlr(): Step 1 remote_inc:31 prop_inc:31 state:5 master:2

*** 2021-06-07T23:02:21.478679-07:00 (CDB$ROOT(1))
2021-06-07 23:02:21.478 :kjzgrcfg_finalize(): Reconfig finished inc:31 state:5
=======================

alert_<instane>.log
================

2021-06-07T23:22:56.603358-07:00
ARC0 (PID:32575): Archived Log entry 2513558 added for T-3.S-151972 ID 0x4018d74d LAD:1
2021-06-07T23:22:56.603531-07:00
ARC0 (PID:32575): Archived Log entry 2513559 added for T-3.S-151972 ID 0x4018d74d LAD:2
2021-06-07T23:22:58.599368-07:00
TT02 (PID:30778): SRL selected for T-3.S-151973 for LAD:3
2021-06-07T23:27:50.757489-07:00
Thread 3 advanced to log sequence 151974 (LGWR switch),  current SCN: 9809250001515
 Current log# 9 seq# 151974 mem# 0: +<LOCATION>/redo09a.log
 Current log# 9 seq# 151974 mem# 1: +<LOCATION>/redo09b.log
2021-06-07T23:27:51.051908-07:00
ARC1 (PID:1499): Archived Log entry 2513573 added for T-3.S-151973 ID 0x4018d74d LAD:1
2021-06-07T23:27:51.051979-07:00
ARC1 (PID:1499): Archived Log entry 2513574 added for T-3.S-151973 ID 0x4018d74d LAD:2
2021-06-07T23:27:52.987726-07:00
TT02 (PID:30778): SRL selected for T-3.S-151974 for LAD:3
2021-06-07T23:31:00.050230-07:00
Thread 3 advanced to log sequence 151975 (LGWR switch),  current SCN: 9809250018958
 Current log# 7 seq# 151975 mem# 0: +<LOCATION>/redo07a.log
 Current log# 7 seq# 151975 mem# 1: +<LOCATION>/redo07b.log
2021-06-07T23:31:00.292917-07:00
TT02 (PID:30778): SRL selected for T-3.S-151975 for LAD:3
2021-06-07T23:31:00.391543-07:00
ARC2 (PID:23145): Archived Log entry 2513589 added for T-3.S-151974 ID 0x4018d74d LAD:1
2021-06-07T23:31:00.391684-07:00
ARC2 (PID:23145): Archived Log entry 2513590 added for T-3.S-151974 ID 0x4018d74d LAD:2

============

<node>_netstat_21.06.07.2300.dat
=======================================

Line 70949: IpReasmFails                    354196662          0.0   >>>>>>>>>>>>>>>>IpReasmFails
Line 71267: IpReasmFails                    354196883          0.0
Line 71585: IpReasmFails                    354197120          0.0
Line 71903: IpReasmFails                    354197388          0.0
Line 72221: IpReasmFails                    354197637          0.0
Line 72539: IpReasmFails                    354197882          0.0
Line 72857: IpReasmFails                    354198184          0.0
Line 73175: IpReasmFails                    354198398          0.0
Line 73493: IpReasmFails                    354198662          0.0
Line 73811: IpReasmFails                    354198885          0.0
Line 74129: IpReasmFails                    354199141          0.0
Line 74447: IpReasmFails                    354199361          0.0
Line 74765: IpReasmFails                    354199601          0.0
Line 75083: IpReasmFails                    354199829          0.0
Line 75401: IpReasmFails                    354200076          0.0
Line 75719: IpReasmFails                    354200349          0.0

 

 

Changes

 No changes

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.