{"id":475,"date":"2012-01-12T23:54:01","date_gmt":"2012-01-12T15:54:01","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=475"},"modified":"2012-01-13T21:54:48","modified_gmt":"2012-01-13T13:54:48","slug":"%e7%94%b1%e4%ba%8edbtime%e6%97%b6%e9%97%b4%e5%a4%aa%e7%9f%ad%e5%af%bc%e8%87%b4awr%e5%87%ba%e7%8e%b0%e5%91%8a%e8%ad%a6%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=475","title":{"rendered":"\u7531\u4e8eDBTIME\u65f6\u95f4\u592a\u77ed\u5bfc\u81f4AWR\u51fa\u73b0\u544a\u8b66\u4fe1\u606f"},"content":{"rendered":"

\u4e00\u4e2a\u5ba2\u6237\u7684RAC\u73af\u5883\u7684AWR\uff0c\u7531\u4e8eDB TIME\u65f6\u95f4\u592a\u77ed\uff0c\u5bfc\u81f4\u51fa\u73b0\u544a\u8b66\u4fe1\u606f\u3002<\/p>\n

\u8fd9\u662f\u4e00\u4e2a10.2.0.5 RAC for Linux X86\u73af\u5883\uff0c\u7531\u4e8e\u5168\u90e8\u5e94\u7528\u90fd\u8fde\u63a5\u5230\u4e00\u4e2a\u8282\u70b9\u4e0a\uff0c\u56e0\u6b64\u53e6\u4e00\u4e2a\u8282\u70b9\u51fa\u73b0\u8fd9\u4e2a\u544a\u8b66\u3002<\/p>\n

\u5728AWR\u62a5\u544a\u4e2d\u7684\u6b63\u6587\u5f00\u59cb\u4e4b\u524d\u7684\u90e8\u5206\uff0c\u6709\u4e0b\u9762\u7684\u544a\u8b66\u4fe1\u606f\uff1a<\/p>\n

WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid.<\/p>\n

\u867d\u7136\u4ee5\u524d\u4e5f\u78b0\u5230\u8fc7\u8282\u70b9\u5f88\u95f2\u7684\u60c5\u51b5\uff0c\u4f46\u662f\u771f\u6ca1\u6709\u78b0\u5230\u8fc7\u8d1f\u8f7d\u8fd9\u4e48\u8f7b\u7684\u7cfb\u7edf\uff1a<\/p>\n\n\n\n\n\n\n\n
<\/td>\n\n

Snap Id<\/strong><\/p>\n<\/td>\n

\n

Snap Time<\/strong><\/p>\n<\/td>\n

\n

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

\n

Cursors\/Session<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Begin Snap:<\/p>\n<\/td>\n

\n

3609<\/p>\n<\/td>\n

\n

06-1\u6708 -12 10:00:22<\/p>\n<\/td>\n

\n

38<\/p>\n<\/td>\n

\n

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

\n

End Snap:<\/p>\n<\/td>\n

\n

3610<\/p>\n<\/td>\n

\n

06-1\u6708 -12 11:00:23<\/p>\n<\/td>\n

\n

39<\/p>\n<\/td>\n

\n

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

\n

Elapsed:<\/p>\n<\/td>\n

<\/td>\n\n

60.02 (mins)<\/p>\n<\/td>\n

<\/td>\n<\/td>\n<\/tr>\n
\n

DB Time:<\/p>\n<\/td>\n

<\/td>\n\n

0.01 (mins)<\/p>\n<\/td>\n

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

\u4ece\u8fd9\u4e2aDB TIME\u4e0a\u770b\uff0c\u7cfb\u7edf\u65f6\u95f4\u8fd8\u4e0d\u52301\u79d2\uff0c\u67e5\u770b\u6bcf\u79d2\u7684\u7edf\u8ba1\u503c\uff1a<\/p>\n

Load Profile <\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/td>\n\n

Per Second<\/strong><\/p>\n<\/td>\n

\n

Per Transaction<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

Redo size:<\/p>\n<\/td>\n

\n

196.38<\/p>\n<\/td>\n

\n

9,556.59<\/p>\n<\/td>\n<\/tr>\n

\n

Logical reads:<\/p>\n<\/td>\n

\n

4.62<\/p>\n<\/td>\n

\n

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

\n

Block changes:<\/p>\n<\/td>\n

\n

0.45<\/p>\n<\/td>\n

\n

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

\n

Physical reads:<\/p>\n<\/td>\n

\n

0.00<\/p>\n<\/td>\n

\n

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

\n

Physical writes:<\/p>\n<\/td>\n

\n

0.06<\/p>\n<\/td>\n

\n

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

\n

User calls:<\/p>\n<\/td>\n

\n

0.16<\/p>\n<\/td>\n

\n

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

\n

Parses:<\/p>\n<\/td>\n

\n

0.19<\/p>\n<\/td>\n

\n

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

\n

Hard parses:<\/p>\n<\/td>\n

\n

0.00<\/p>\n<\/td>\n

\n

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

\n

Sorts:<\/p>\n<\/td>\n

\n

0.40<\/p>\n<\/td>\n

\n

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

\n

Logons:<\/p>\n<\/td>\n

\n

0.03<\/p>\n<\/td>\n

\n

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

\n

Executes:<\/p>\n<\/td>\n

\n

0.74<\/p>\n<\/td>\n

\n

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

\n

Transactions:<\/p>\n<\/td>\n

\n

0.02<\/p>\n<\/td>\n

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

\u53ef\u4ee5\u770b\u5230\uff0c\u9664\u4e86\u903b\u8f91\u8bfb\u548cREDO\u5916\uff0c\u5176\u4f59\u7684\u503c\u6bcf\u79d2\u90fd\u5c0f\u4e8e1\uff0c\u5728\u770b\u770bTOP 5\u7b49\u5f85\uff1a<\/p>\n

Top 5 Timed Events <\/strong><\/p>\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 Wait(ms)<\/strong><\/p>\n<\/td>\n

\n

% Total Call \u00a0 Time<\/strong><\/p>\n<\/td>\n

\n

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

\n

control file \u00a0 sequential read<\/p>\n<\/td>\n

\n

9,928<\/p>\n<\/td>\n

\n

4<\/p>\n<\/td>\n

\n

0<\/p>\n<\/td>\n

\n

600.8<\/p>\n<\/td>\n

\n

System I\/O<\/p>\n<\/td>\n<\/tr>\n

\n

control file \u00a0 parallel write<\/p>\n<\/td>\n

\n

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

\n

2<\/p>\n<\/td>\n

\n

2<\/p>\n<\/td>\n

\n

354.8<\/p>\n<\/td>\n

\n

System I\/O<\/p>\n<\/td>\n<\/tr>\n

\n

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

<\/td>\n\n

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

<\/td>\n\n

81.0<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

os thread \u00a0 startup<\/p>\n<\/td>\n

\n

10<\/p>\n<\/td>\n

\n

0<\/p>\n<\/td>\n

\n

35<\/p>\n<\/td>\n

\n

52.2<\/p>\n<\/td>\n

\n

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

\n

CGS wait for IPC \u00a0 msg<\/p>\n<\/td>\n

\n

26,151<\/p>\n<\/td>\n

\n

0<\/p>\n<\/td>\n

\n

0<\/p>\n<\/td>\n

\n

40.2<\/p>\n<\/td>\n

\n

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

\u53ef\u4ee5\u770b\u5230\u63a7\u5236\u6587\u4ef6\u7684\u8bfb\u5199\u5206\u522b\u662f4\u79d2\u548c2\u79d2\uff0c\u5360\u7528\u4e86600%\u548c350%\u7684\u7cfb\u7edf\u65f6\u95f4\uff0c\u8fd9\u4e5f\u662f\u524d\u9762\u544a\u8b66\u4fe1\u606f\u63d0\u793a\u7684\u767e\u5206\u6bd4\u4e0d\u51c6\u786e\u7684\u539f\u56e0\u3002<\/p>\n

AWR\u62a5\u544a\u672c\u8eab\u6ca1\u6709\u592a\u591a\u6709\u610f\u4e49\u4fe1\u606f\uff0c\u53ea\u662f\u8fd9\u79cd\u60c5\u51b5\u6bd4\u8f83\u5c11\u89c1\uff0c\u7279\u6b64\u4e3a\u8bb0\u3002<\/p>\n

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

\u4e00\u4e2a\u5ba2\u6237\u7684RAC\u73af\u5883\u7684AWR\uff0c\u7531\u4e8eDB TIME\u65f6\u95f4\u592a\u77ed\uff0c\u5bfc\u81f4\u51fa\u73b0\u544a\u8b66\u4fe1\u606f\u3002 \u8fd9\u662f\u4e00\u4e2a10.2.0.5 RAC for Linux X86\u73af\u5883\uff0c\u7531\u4e8e\u5168\u90e8\u5e94\u7528\u90fd\u8fde\u63a5\u5230\u4e00\u4e2a\u8282\u70b9\u4e0a\uff0c\u56e0\u6b64\u53e6\u4e00\u4e2a\u8282\u70b9\u51fa\u73b0\u8fd9\u4e2a\u544a\u8b66\u3002 \u5728AWR\u62a5\u544a\u4e2d\u7684\u6b63\u6587\u5f00\u59cb\u4e4b\u524d\u7684\u90e8\u5206\uff0c\u6709\u4e0b\u9762\u7684\u544a\u8b66\u4fe1\u606f\uff1a WARNING: Since the DB Time is less than one second, there was minimal foreground activity in the snapshot period. Some of the percentage values will be invalid. \u867d\u7136\u4ee5\u524d\u4e5f\u78b0\u5230\u8fc7\u8282\u70b9\u5f88\u95f2\u7684\u60c5\u51b5\uff0c\u4f46\u662f\u771f\u6ca1\u6709\u78b0\u5230\u8fc7\u8d1f\u8f7d\u8fd9\u4e48\u8f7b\u7684\u7cfb\u7edf\uff1a Snap Id Snap Time … 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":[3],"tags":[371,372,370],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-7F","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/475"}],"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=475"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/475\/revisions"}],"predecessor-version":[{"id":477,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/475\/revisions\/477"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}