暂无图片
分享
周勇
2020-01-14
12.2.0.1 mman进程占用很高cpu 并且持续写mman trace文件在alert目录下面

mman trace文件高达20多G,一直在清,一直在写。
mman进程cpu很高
image.png

找到了类似的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。

收藏
分享
3条回答
默认
最新
Moone

不是匹配到了bug吗?
打Patch 25415713: MMON TRACE FILE GROWS WHEN NO TRACES ARE ENABLED

暂无图片 评论
暂无图片 有用 0
周勇

。。。。。。为啥我说类似,因为一个是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 wrmwrcontrola,(selectdistinctdbidfromwrm_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
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
周勇
问题已关闭: 悬案
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏