{"id":563,"date":"2012-02-12T23:30:09","date_gmt":"2012-02-12T15:30:09","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=563"},"modified":"2012-02-13T23:31:50","modified_gmt":"2012-02-13T15:31:50","slug":"statspack%e6%8a%a5%e5%91%8aredo-size%e5%87%ba%e7%8e%b0%e8%b4%9f%e5%80%bc","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=563","title":{"rendered":"STATSPACK\u62a5\u544aREDO SIZE\u51fa\u73b0\u8d1f\u503c"},"content":{"rendered":"<p>\u5ba2\u62379.2.0.8\u6570\u636e\u5e93\u7684STATSPACK\u62a5\u544a\u51fa\u73b0\u8d1f\u7684REDO SIZE\u3002<br \/>\n\u7c7b\u4f3c\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Load Profile\r\n~~~~~~~~~~~~                            Per Second       Per Transaction\r\n                                   ---------------       ---------------\r\n                  Redo size:           -263,339.94           -685,483.59<\/pre>\n<p>\u5176\u5b9e\u7ecf\u5e38\u51fa\u73b0\u7684\u8fd8\u5305\u62ec\u903b\u8f91\u8bfb\u4ee5\u53ca\u7269\u7406\u8bfb\u7b49\u3002\u5176\u5b9e\u4e0d\u67e5\u8be2MOS\u4e5f\u53ef\u4ee5\u786e\u5b9a\uff0c\u8fd9\u662fOracle\u7684bug\uff0c\u800c\u5bfc\u81f4bug\u7684\u539f\u56e0\u5e94\u8be5\u662f\u5e95\u5c42\u7684C\u4ee3\u7801\u4e2d\u6ca1\u6709\u4f7f\u7528UNSIGNED\u7c7b\u578b\uff0c\u4ee5\u81f3\u4e8e\u53d8\u91cf\u6ea2\u51fa\u540e\u51fa\u73b0\u4e86\u8d1f\u503c\u3002<br \/>\n\u5728MOS\u4e2d\u7684\u5bf9\u5e94\u63cf\u8ff0\u4e3a\uff1aRedo Size Negative In Statspack Report [ID 308414.1]\uff0cOracle\u572810g\u4e2d\u89e3\u51b3\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002\u786e\u8ba4\u5f71\u54cd\u7248\u672c\u4ece8.1.7.4\u52309.2.0.8\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u62379.2.0.8\u6570\u636e\u5e93\u7684STATSPACK\u62a5\u544a\u51fa\u73b0\u8d1f\u7684REDO SIZE\u3002 \u7c7b\u4f3c\u4fe1\u606f\u5982\u4e0b\uff1a Load Profile ~~~~~~~~~~~~ Per Second Per Transaction &#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212; Redo size: -263,339.94 -685,483.59 \u5176\u5b9e\u7ecf\u5e38\u51fa\u73b0\u7684\u8fd8\u5305\u62ec\u903b\u8f91\u8bfb\u4ee5\u53ca\u7269\u7406\u8bfb\u7b49\u3002\u5176\u5b9e\u4e0d\u67e5\u8be2MOS\u4e5f\u53ef\u4ee5\u786e\u5b9a\uff0c\u8fd9\u662fOracle\u7684bug\uff0c\u800c\u5bfc\u81f4bug\u7684\u539f\u56e0\u5e94\u8be5\u662f\u5e95\u5c42\u7684C\u4ee3\u7801\u4e2d\u6ca1\u6709\u4f7f\u7528UNSIGNED\u7c7b\u578b\uff0c\u4ee5\u81f3\u4e8e\u53d8\u91cf\u6ea2\u51fa\u540e\u51fa\u73b0\u4e86\u8d1f\u503c\u3002 \u5728MOS\u4e2d\u7684\u5bf9\u5e94\u63cf\u8ff0\u4e3a\uff1aRedo Size Negative In Statspack Report [ID 308414.1]\uff0cOracle\u572810g\u4e2d\u89e3\u51b3\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002\u786e\u8ba4\u5f71\u54cd\u7248\u672c\u4ece8.1.7.4\u52309.2.0.8\u3002<\/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":[455,454,272],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-95","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/563"}],"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=563"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/563\/revisions"}],"predecessor-version":[{"id":564,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/563\/revisions\/564"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=563"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=563"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=563"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}