{"id":374,"date":"2011-12-08T23:37:23","date_gmt":"2011-12-08T15:37:23","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=374"},"modified":"2011-12-09T14:39:07","modified_gmt":"2011-12-09T06:39:07","slug":"awr%e4%b8%ad%e5%87%ba%e7%8e%b0%e4%b8%a5%e9%87%8dkksfbc-child-completion%e7%ad%89%e5%be%85","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=374","title":{"rendered":"AWR\u4e2d\u51fa\u73b0\u4e25\u91cdkksfbc child completion\u7b49\u5f85"},"content":{"rendered":"

\u4e00\u4e2a\u5ba2\u6237\u538b\u529b\u6d4b\u8bd5\u7684AWR\u62a5\u544a\u4e2d\u51fa\u73b0\u4e86\u4e25\u91cd\u7684kksfbc child completion\u7b49\u5f85\u3002<\/p>\n

\u6570\u636e\u5e93\u7248\u672c\u4e3a10.2.0.5\uff0c\u5176TOP 5\u7b49\u5f85\u4e8b\u4ef6\u4e3a\uff1a<\/p>\n

\n\n\n\n\n\n\n\n\n
\n

Event<\/strong><\/p>\n<\/td>\n

\n

Waits<\/strong><\/p>\n<\/td>\n

\n

Time(s)<\/strong><\/p>\n<\/td>\n

\n

Avg
\nWait(ms)<\/strong><\/p>\n<\/td>\n

\n

%
\nTotal Call Time<\/strong><\/p>\n<\/td>\n

\n

Wait
\nClass<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

kksfbc
\nchild completion<\/p>\n<\/td>\n

\n

174,808<\/p>\n<\/td>\n

\n

8,678<\/p>\n<\/td>\n

\n

50<\/p>\n<\/td>\n

\n

27.2<\/p>\n<\/td>\n

\n

Other<\/p>\n<\/td>\n<\/tr>\n

\n

db
\nfile scattered read<\/p>\n<\/td>\n

\n

106,665<\/p>\n<\/td>\n

\n

6,807<\/p>\n<\/td>\n

\n

64<\/p>\n<\/td>\n

\n

21.3<\/p>\n<\/td>\n

\n

User
\nI\/O<\/p>\n<\/td>\n<\/tr>\n

\n

log
\nfile sync<\/p>\n<\/td>\n

\n

130,582<\/p>\n<\/td>\n

\n

6,592<\/p>\n<\/td>\n

\n

50<\/p>\n<\/td>\n

\n

20.6<\/p>\n<\/td>\n

\n

Commit<\/p>\n<\/td>\n<\/tr>\n

\n

cursor:
\npin S wait on X<\/p>\n<\/td>\n

\n

552,414<\/p>\n<\/td>\n

\n

5,982<\/p>\n<\/td>\n

\n

11<\/p>\n<\/td>\n

\n

18.7<\/p>\n<\/td>\n

\n

Concurrency<\/p>\n<\/td>\n<\/tr>\n

\n

CPU
\ntime<\/p>\n<\/td>\n

<\/td>\n\n

1,801<\/p>\n<\/td>\n

<\/td>\n\n

5.6<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u5bf9\u4e8ekksfbc
\nchild completion\u4e8b\u4ef6\uff0c\u8fd8\u662f\u7b2c\u4e00\u6b21\u770b\u5230\uff0c\u4e0d\u8fc7\u7cfb\u7edf\u4e2d\u51fa\u73b0\u8fd9\u4e2a\u4e8b\u4ef6\u80af\u5b9a\u4e0d\u6b63\u5e38\uff0c\u800c\u4e14\u8fd9\u4e2a\u4e8b\u4ef6\u6392\u5728\u7b2c\u4e00\u4f4d\u5c31\u66f4\u8bf4\u660e\u95ee\u9898\u4e86\u3002<\/p>\n

\u68c0\u67e5MOS\u540e\u53d1\u73b0\uff0c\u53d1\u73b0\u8fd9\u4e2a\u4e8b\u4ef6\u76f8\u5173\u7684bug\u8fdc\u6bd4\u60f3\u8c61\u4e2d\u7684\u591a\uff0c\u6392\u9664\u4e86\u591a\u4e2abug\u540e\uff0c\u611f\u89c9\u548c\u6587\u6863Processes Hang Waiting on ‘cursor: pin S wait on X'[ID 580273.1]\u63cf\u8ff0\u7684\u6bd4\u8f83\u7c7b\u4f3c\u3002<\/p>\n

\u8fd9\u4e2a\u95ee\u9898\u53ef\u80fd\u548c\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u7684\u5e95\u5c42\u8c03\u7528\u6709\u5173\u3002\u800c\u53ef\u80fd\u5f71\u54cd\u7684Oracle\u7248\u672c\u4ece9.2.0.1\u4e00\u76f4\u523011.1.0.6\u3002<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u4e00\u4e2a\u5ba2\u6237\u538b\u529b\u6d4b\u8bd5\u7684AWR\u62a5\u544a\u4e2d\u51fa\u73b0\u4e86\u4e25\u91cd\u7684kksfbc child completion\u7b49\u5f85\u3002 \u6570\u636e\u5e93\u7248\u672c\u4e3a10.2.0.5\uff0c\u5176TOP 5\u7b49\u5f85\u4e8b\u4ef6\u4e3a\uff1a Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class kksfbc child completion 174,808 8,678 50 27.2 Other db file scattered read 106,665 6,807 64 21.3 User I\/O log file sync 130,582 6,592 50 … Continue reading →<\/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":[270,269],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-62","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/374"}],"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=374"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/374\/revisions"}],"predecessor-version":[{"id":377,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/374\/revisions\/377"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}