{"id":1165,"date":"2012-09-07T23:22:05","date_gmt":"2012-09-07T15:22:05","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1165"},"modified":"2012-10-14T22:25:36","modified_gmt":"2012-10-14T14:25:36","slug":"%e6%95%b0%e6%8d%ae%e6%b3%b5%e5%af%bc%e5%85%a5%e5%88%86%e5%8c%ba%e8%a1%a8%e9%95%bf%e6%97%b6%e9%97%b4hang%e4%bd%8f","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1165","title":{"rendered":"\u6570\u636e\u6cf5\u5bfc\u5165\u5206\u533a\u8868\u957f\u65f6\u95f4HANG\u4f4f"},"content":{"rendered":"<p>\u5ba2\u623710.2.0.3\u73af\u5883\u6570\u636e\u5e93\u5728\u4f7f\u7528\u6570\u636e\u5e93\u5bfc\u5165\u5206\u533a\u8868\u65f6\uff0c\u51fa\u73b0\u957f\u65f6\u95f4HANG\u4f4f\u7684\u60c5\u51b5\u3002<br \/>\n\u901a\u8fc710046\u8ddf\u8e2a\uff0c\u53d1\u73b0\u7b49\u5f85\u53d1\u751f\u5728\u7a7a\u95f2\u7b49\u5f85wait for unread message on broadcast channel\u4e0a\uff0c\u90e8\u520610046 TRACE\u6458\u5f55\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>=====================\r\nPARSING IN CURSOR #27 len=93 dep=2 uid=0 oct=3 lid=0 tim=1314162845109698 hv=3190910778 ad='5a938130'\r\nSELECT NVL(SUM(data_io),0) FROM \"SYS\".\"SEASHELL_ENTRY_P_20110126_88\" WHERE process_order = :1\r\nEND OF STMT\r\nPARSE #27:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162845109693\r\nBINDS #27:\r\nkkscoacd\r\nBind#0\r\n  oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=13 fl2=206001 frm=00 csi=00 siz=24 off=0\r\n  kxsbbbfp=2acd522c5888  bln=22  avl=03  flg=05\r\n  value=-42\r\nEXEC #27:c=0,e=121,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162845109900\r\nFETCH #27:c=999,e=91,p=0,cr=2,cu=0,mis=0,r=1,dep=2,og=1,tim=1314162845110019\r\n=====================\r\nPARSING IN CURSOR #36 len=46 dep=2 uid=0 oct=47 lid=0 tim=1314162845110264 hv=420667605 ad='594460a0'\r\nBEGIN :1 := sys.kupc$que_int.receive(:2); END;\r\nEND OF STMT\r\nPARSE #36:c=0,e=50,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162845110259\r\nBINDS #36:\r\nkkscoacd\r\nBind#0\r\n  oacdty=121 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=00 fl2=206001 frm=00 csi=00 siz=4000 off=0\r\n  kxsbbbfp=2acd51ff8e30  bln=4000  avl=00  flg=15\r\nBind#1\r\n  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=03 fl2=206001 frm=00 csi=00 siz=24 off=0\r\n  kxsbbbfp=2acd522c5888  bln=22  avl=02  flg=05\r\n  value=5\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 976833 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162846087749\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977485 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162847065320\r\n*** 2012-08-23 14:19:16.395\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977438 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162848042834\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977564 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162849020507\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977425 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162849997982\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977515 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162850975546\r\nEXEC #36:c=0,e=5865418,p=0,cr=4,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162850975764\r\nERROR #36:err=25228 tim=805377243\r\n=====================\r\nPARSING IN CURSOR #36 len=46 dep=2 uid=0 oct=47 lid=0 tim=1314162850975992 hv=420667605 ad='594460a0'\r\nBEGIN :1 := sys.kupc$que_int.receive(:2); END;\r\nEND OF STMT\r\nPARSE #36:c=0,e=60,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162850975987\r\nBINDS #36:\r\nkkscoacd\r\nBind#0\r\n  oacdty=121 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=00 fl2=206001 frm=00 csi=00 siz=4000 off=0\r\n  kxsbbbfp=2acd51ff8e30  bln=4000  avl=00  flg=15\r\nBind#1\r\n  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=03 fl2=206001 frm=00 csi=00 siz=24 off=0\r\n  kxsbbbfp=2acd522c5888  bln=22  avl=02  flg=05\r\n  value=5\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977489 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162851954175\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977604 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162852931835\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977468 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162853909360\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977445 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162854886930\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977462 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162855864477\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977665 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162856842219\r\nEXEC #36:c=1000,e=5866346,p=0,cr=4,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162856842423\r\nERROR #36:err=25228 tim=805377844\r\n=====================\r\nPARSING IN CURSOR #36 len=46 dep=2 uid=0 oct=47 lid=0 tim=1314162856842660 hv=420667605 ad='594460a0'\r\nBEGIN :1 := sys.kupc$que_int.receive(:2); END;\r\nEND OF STMT\r\nPARSE #36:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162856842654\r\nBINDS #36:\r\nkkscoacd\r\nBind#0\r\n  oacdty=121 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=00 fl2=206001 frm=00 csi=00 siz=4000 off=0\r\n  kxsbbbfp=2acd51ff8e30  bln=4000  avl=00  flg=15\r\nBind#1\r\n  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=03 fl2=206001 frm=00 csi=00 siz=24 off=0\r\n  kxsbbbfp=2acd522c5888  bln=22  avl=02  flg=05\r\n  value=5\r\n*** 2012-08-23 14:19:26.408\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977414 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162857820783\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977354 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162858798202\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977523 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162859775833\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977339 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162860753273\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977629 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162861730982\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977450 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162862708486\r\nEXEC #36:c=1000,e=5865927,p=0,cr=4,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162862708674\r\nERROR #36:err=25228 tim=805378444\r\n=====================\r\nPARSING IN CURSOR #36 len=46 dep=2 uid=0 oct=47 lid=0 tim=1314162862708909 hv=420667605 ad='594460a0'\r\nBEGIN :1 := sys.kupc$que_int.receive(:2); END;\r\nEND OF STMT\r\nPARSE #36:c=0,e=63,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162862708903\r\nBINDS #36:\r\nkkscoacd\r\nBind#0\r\n  oacdty=121 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=00 fl2=206001 frm=00 csi=00 siz=4000 off=0\r\n  kxsbbbfp=2acd51ff8e30  bln=4000  avl=00  flg=15\r\nBind#1\r\n  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00\r\n  oacflg=03 fl2=206001 frm=00 csi=00 siz=24 off=0\r\n  kxsbbbfp=2acd522c5888  bln=22  avl=02  flg=05\r\n  value=5\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977366 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162863686994\r\nWAIT #36: nam='wait for unread message on broadcast channel' ela= 977565 channel context=70113644704 channel handle=70314944608 p3=0 obj#=238136 tim=1314162864664610<\/pre>\n<p>\u663e\u7136\u8fd9\u79cd\u7a7a\u95f2\u7b49\u5f85\u7684\u51fa\u73b0\u662f\u4e0d\u6b63\u5e38\u7684\uff0c\u6839\u636e\u7b49\u5f85\u65f6\u95f4\u548c\u7b49\u5f85\u7684\u5177\u4f53PL\/SQL\u8bed\u53e5\uff0c\u53ef\u4ee5\u786e\u8ba4\u4e3aBug 7439689 &#8211; impdp worker process may spin [ID 7439689.8]\u3002\u8fd9\u4e2abug\u5f71\u54cd\u7684\u7248\u672c\u4e3a10.2.0.4\u6b63\u662f\u5f53\u524d\u7684\u7248\u672c\uff0c\u572810.2.0.5\u4e2d\u89e3\u51b3\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002\u6b64\u5916\u5728Solaris\u548cHP-UX\u73af\u5883\u4e0b\uff0c\u8fd8\u6709\u4e13\u95e8\u9488\u5bf9\u8fd9\u4e2abug\u7684\u8865\u4e01\u7a0b\u5e8f\u3002<br \/>\nOracle\u7ed9\u51fa\u7684\u4e34\u65f6\u89e3\u51b3\u65b9\u6848\u662f\u7528exp\/imp\u4ee3\u66ff\u6570\u636e\u6cf5\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623710.2.0.3\u73af\u5883\u6570\u636e\u5e93\u5728\u4f7f\u7528\u6570\u636e\u5e93\u5bfc\u5165\u5206\u533a\u8868\u65f6\uff0c\u51fa\u73b0\u957f\u65f6\u95f4HANG\u4f4f\u7684\u60c5\u51b5\u3002 \u901a\u8fc710046\u8ddf\u8e2a\uff0c\u53d1\u73b0\u7b49\u5f85\u53d1\u751f\u5728\u7a7a\u95f2\u7b49\u5f85wait for unread message on broadcast channel\u4e0a\uff0c\u90e8\u520610046 TRACE\u6458\u5f55\u5982\u4e0b\uff1a ===================== PARSING IN CURSOR #27 len=93 dep=2 uid=0 oct=3 lid=0 tim=1314162845109698 hv=3190910778 ad=&#8217;5a938130&#8242; SELECT NVL(SUM(data_io),0) FROM &#8220;SYS&#8221;.&#8221;SEASHELL_ENTRY_P_20110126_88&#8243; WHERE process_order = :1 END OF STMT PARSE #27:c=0,e=76,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=1,tim=1314162845109693 BINDS #27: kkscoacd Bind#0 oacdty=02 &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1165\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[172,496,534,460,1017],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-iN","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1165"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1165"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1165\/revisions"}],"predecessor-version":[{"id":1166,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1165\/revisions\/1166"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}