扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
来源:盖国强的博客 2009年12月28日
关键字: 进程 Oracle 10g ORACLE
SGA: MMAN sleep for component shrink在后台转储跟踪,可以看到MMAN进程的等待:
MMAN to wait and post itself for satisfying an auto-tuned memory request while trying to fully free a component's quiesced granules. In Release 10.1, the name of this event was 'wait for SGA component shrink'.
*** 2009-12-22 15:00:04.484然而在很多繁忙的环境中,自动的内存调整会成为一个负担,所以很多用户禁用了这一功能。
WAIT #0: nam='rdbms ipc message' ela= 2999944 timeout=300 p2=0 p3=0 obj#=-1 tim=9809590317
WAIT #0: nam='rdbms ipc message' ela= 2999773 timeout=300 p2=0 p3=0 obj#=-1 tim=9812737808
WAIT #0: nam='rdbms ipc message' ela= 2999664 timeout=300 p2=0 p3=0 obj#=-1 tim=9815814982
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10045 component id=6 current size=8 target size=7 obj#=-1 tim=9815936073
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10581 component id=6 current size=8 target size=7 obj#=-1 tim=9815946809
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10541 component id=6 current size=8 target size=7 obj#=-1 tim=9815957544
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10655 component id=6 current size=8 target size=7 obj#=-1 tim=9815968290
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10649 component id=6 current size=8 target size=7 obj#=-1 tim=9815979031
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10645 component id=6 current size=8 target size=7 obj#=-1 tim=9815989770
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10678 component id=6 current size=8 target size=7 obj#=-1 tim=9816000516
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10661 component id=6 current size=8 target size=7 obj#=-1 tim=9816011260
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10644 component id=6 current size=8 target size=7 obj#=-1 tim=9816022006
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10623 component id=6 current size=8 target size=7 obj#=-1 tim=9816032746
WAIT #0: nam='SGA: MMAN sleep for component shrink' ela= 10664 component id=6 current size=8 target size=7 obj#=-1 tim=9816043506
WAIT #0: nam='rdbms ipc message' ela= 2449387 timeout=245 p2=0 p3=0 obj#=-1 tim=9818925363
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。
现场直击|2021世界人工智能大会
直击5G创新地带,就在2021MWC上海
5G已至 转型当时——服务提供商如何把握转型的绝佳时机
寻找自己的Flag
华为开发者大会2020(Cloud)- 科技行者