mman trace文件高达20多G，一直在清，一直在写。
mman进程cpu很高
找到了类似的BUG，因为mmon trace文件中报错：
AUTO SGA: kmgs_parameter_update_timeout gen0 1 mmon alive 0
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1 Excessive Trace Files were generated on one node after Migration to 12.2 and MMON trace file grows (Doc ID 2298766.1)
暂时是设置了trace生成文件上限，该问题只出现在节点1，mman 文件中就是各种内存dump 数据。
准备把ASMM更改成AMM，不知道是不是无效举动，未找到对应BUG，不敢断定是BUG。
。。。。。。为啥我说类似，因为一个是MMON一个是MMAN，两个完全不同的进程，MMAN是涉及自动内存管理的进程。我觉得不能看的长得像就随便打补丁吧。我暂时怀疑要开SR，是不是要oracle官方确认是不是MMAN新BUG，也可能我孤陋寡闻，看不懂trace导致其实是别的问题，所以来看有没大神求助下。看了一天trace文件，没看出啥异常。
SO: 0xb798bca8, type: 109, owner: 0x15146c900, flag: INIT/-/-/-/0x00 if: 0x3 c: 0x3
proc=0x138ec93b8, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:9855, pg=0, conuid=0
LibraryObjectLock: Address=0xb798bca8 Handle=0xbd2826e8 Mode=N CanBeBrokenCount=1 Incarnation=1 ExecutionCount=0 Context=0x7f3dfc79d070 User=0x15146c900 Session=0x139497f10 ReferenceCount=1 Flags=[0000] SavepointNum=0 Time=01/14/2020 10:36:02 LibraryHandle: Address=0xbd2826e8 Hash=0 LockMode=N PinMode=0 LoadLockMode=0 Status=VALD Name: Namespace=SQL AREA(00) Type=CURSOR(00) ContainerId=0 Statistics: InvalidationCount=0 ExecutionCount=18 LoadCount=3 ActiveLocks=1 TotalLockCount=47 TotalPinCount=50 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=0 Version=0 BucketInUse=0 HandleInUse=0 HandleReferenceCount=0 Concurrency: DependencyMutex=0xbd282798(0, 0, 0, 0) Mutex=0xbf6a9b18(0, 13608, 0, 0) Flags=RON/PIN/PN0/EXP/CHD/[10012111] Flags2=[0000] WaitersLists: Lock=0xbd282778[0xbd282778,0xbd282778] Pin=0xbd282758[0xbd282758,0xbd282758] LoadLock=0xbd2827d0[0xbd2827d0,0xbd2827d0] LibraryObject: Address=0xbc8bc808 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000] NamespaceDump: Child Cursor: Heap0=0xbc8bc8d8 Heap6=0x7e0f6ee0 Heap0 Load Time=01-14-2020 02:05:55 Heap6 Load Time=01-14-2020 02:05:55 ---------------------------------------- SO: 0xb77869c8, type: 109, owner: 0x15146c900, flag: INIT/-/-/-/0x00 if: 0x3 c: 0x3 proc=0x138ec93b8, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:9855, pg=0, conuid=0 LibraryObjectLock: Address=0xb77869c8 Handle=0xbf6a99c8 Mode=N CanBeBrokenCount=1 Incarnation=1 ExecutionCount=1 User=0x15146c900 Session=0x139497f10 ReferenceCount=1 Flags=CNB/[0001] SavepointNum=1e4c59 Time=01/14/2020 10:36:02 LibraryHandle: Address=0xbf6a99c8 Hash=10b1638b LockMode=N PinMode=0 LoadLockMode=0 Status=VALD ObjectName: Name=select a.dbid, a.status_flag from wrm$_wr_control a, (select distinct dbid from wrm$_database_instance) b where a.dbid = b.dbid FullHashValue=392d46d76c595c16ef216f9f10b1638b Namespace=SQL AREA(00) Type=CURSOR(00) ContainerId=0 ContainerUid=0 Identifier=280060811 OwnerIdn=0 Statistics: InvalidationCount=0 ExecutionCount=231 LoadCount=22 ActiveLocks=1 TotalLockCount=231 TotalPinCount=1 Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=3 Version=0 BucketInUse=230 HandleInUse=230 HandleReferenceCount=0复制
User=0x15146c900 Session=0x139497f10 ReferenceCount=1
Flags=CNB/[0001] SavepointNum=1e4c59 Time=01/14/2020 10:36:02
LibraryHandle: Address=0xbf6a99c8 Hash=10b1638b LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
ObjectName: Name=select a.dbid, a.status_flag from wrm_database_instance) b where a.dbid = b.dbid
FullHashValue=392d46d76c595c16ef216f9f10b1638b Namespace=SQL AREA(00) Type=CURSOR(00) ContainerId=0 ContainerUid=0 Identifier=280060811 OwnerIdn=0
Statistics: InvalidationCount=0 ExecutionCount=231 LoadCount=22 ActiveLocks=1 TotalLockCount=231 TotalPinCount=1
Counters: BrokenCount=1 RevocablePointer=1 KeepDependency=3 Version=0 BucketInUse=230 HandleInUse=230 HandleReferenceCount=0
Concurrency: DependencyMutex=0xbf6a9a78(0, 144, 0, 0) Mutex=0xbf6a9b18(0, 13608, 0, 0)
Flags=RON/PIN/TIM/PN0/DBN/[10012841] Flags2=[0000]
WaitersLists:
Lock=0xbf6a9a58[0xbf6a9a58,0xbf6a9a58]
Pin=0xbf6a9a38[0xbf6a9a38,0xbf6a9a38]
LoadLock=0xbf6a9ab0[0xbf6a9ab0,0xbf6a9ab0]
Timestamp: Current=01-09-2020 16:02:38
HandleReference: Address=0xbf6a9c10 Handle=(nil) Flags=[00]
LibraryObject: Address=0xbf6a8878 HeapMask=0000-0001-0001-0000 Flags=EXS[0000] Flags2=[0000] PublicFlags=[0000]
ChildTable: size=‘16’
Child: id=‘0’ Table=0xbf6a96f8 Reference=0xbf6a91a0 Handle=0xbf6a85a0
Child: id=‘1’ Table=0xbf6a96f8 Reference=0xbf6a94e8 Handle=0xbd2826e8
Child: id=‘2’ Table=0xbf6a96f8 Reference=0xbc93e290 Handle=0xbc94a170
Child: id=‘3’ Table=0xbf6a96f8 Reference=0xbc93e5d0 Handle=0xbf73ad78
Child: id=‘4’ Table=0xbf6a96f8 Reference=0xbc93e978 Handle=0xbcee4d40
Child: id=‘5’ Table=0xbf6a96f8 Reference=0xbc93ecb8 Handle=0xbbdbaf28
Child: id=‘6’ Table=0xbf6a96f8 Reference=0xbe591888 Handle=0xbc853ce8
Child: id=‘7’ Table=0xbf6a96f8 Reference=0xbe591bc8 Handle=0xbdb922e0
Child: id=‘8’ Table=0xbf6a96f8 Reference=0xbe591f08 Handle=0xbca33130
Child: id=‘9’ Table=0xbf6a96f8 Reference=0xbe592248 Handle=0xbfd42520
Child: id=‘10’ Table=0xbf6a96f8 Reference=0xbc93ed70 Handle=0xbd3eaf18
Child: id=‘11’ Table=0xbf6a96f8 Reference=0xbf1fe6a8 Handle=0xbec68d18
NamespaceDump:
Parent Cursor: sql_id=fy8bgmw8b2swb parent=0xbf6a8948 maxchild=12 plk=y ppn=n prsfcnt=0 obscnt=0
CursorDiagnosticsNodes:
ChildNode: ChildNumber=0 ID=33 reason=Rolling Invalidate Window Exceeded(2) size=0x0 details=already_processed
ChildNode: ChildNumber=2 ID=33 reason=Rolling Invalidate Window Exceeded(3) size=2x4 invalidation_window=1578937284 ksugctm=1578938755
ChildNode: ChildNumber=0 ID=33 reason=Rolling Invalidate Window Exceeded(3) size=2x4 invalidation_window=1578861315 ksugctm=1578861334
ChildNode: ChildNumber=3 ID=33 reason=Rolling Invalidate Window Exceeded(3) size=2x4 invalidation_window=1578825575 ksugctm=1578827118
评论
有用 0
