{"id":73,"date":"2020-07-07T16:56:06","date_gmt":"2020-07-07T07:56:06","guid":{"rendered":"http:\/\/www.shamonabe.com\/?p=73"},"modified":"2020-07-07T16:56:07","modified_gmt":"2020-07-07T07:56:07","slug":"post-73","status":"publish","type":"post","link":"http:\/\/www.shamonabe.com\/?p=73","title":{"rendered":"UNDO\u8868\u9818\u57df\u9069\u6b63\u30b5\u30a4\u30ba\u898b\u7a4d\u3082\u308a"},"content":{"rendered":"<p>11.1.0.7.0 \u4ee5\u964d\u306e\u30ea\u30ea\u30fc\u30b9\u306b\u5bfe\u5fdc<br \/>\n<code>select (((UR * UPS +<br \/>\n(select 127 + (max(MAXCONCURRENCY)) * 2 from v$undostat)<br \/>\n) * DBS)\/1024)\/1024 AS\"UNDO SIZE(MB)\" from<br \/>\n(select value UR from v$parameter where name = 'undo_retention'),<br \/>\n(select (SUM(undoblks)\/SUM((end_time-begin_time) * 86400)) UPS from v$undostat),<br \/>\n(select value DBS from v$parameter where name = 'db_block_size');<\/code><\/p>\n<p><code>V$UNDOSTAT\u304b\u3089\u3001\u4ee5\u4e0b\u306e\u60c5\u5831\u3092\u53d6\u5f97\u3059\u308b\u3002<br \/>\n\u30fbundoblks<br \/>\n\u30fbmaxquerylen<br \/>\n\u305d\u308c\u304b\u3089\u3001\u4ee5\u4e0b\u306e\u5024\u3082\u3002<br \/>\n\u30fb\uff11\u30d6\u30ed\u30c3\u30af\u306e\u30d0\u30a4\u30c8\u6570<br \/>\n\u7279\u306b\u3044\u3058\u3063\u3066\u306a\u3051\u308c\u3070\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u306f8192\u30d0\u30a4\u30c8\u3002<\/code><\/p>\n<p><code>1\u79d2\u3042\u305f\u308aUNDO\u30d6\u30ed\u30c3\u30af\u751f\u6210\u6570 \u00d7\u3000UNDO\u4fdd\u5b58\u671f\u9593(\u79d2) \u00d7 \u30d6\u30ed\u30c3\u30af\u30b5\u30a4\u30ba<\/p>\n<p>\u3092\u8a08\u7b97\u3059\u308b\u3002<br \/>\nV$UNDOSTAT\u306f10\u5206\u3054\u3068\u306b\u66f4\u65b0\u3055\u308c\u308b\u304b\u3089\u30011\u79d2\u5f53\u305f\u308a\u306eUNDO\u30d6\u30ed\u30c3\u30af\u751f\u6210\u6570\u306f\u3001(undoblks \/ 600)\u3068\u306a\u308b\u3002<\/p>\n<p>\u306a\u306e\u3067\u3001\u4e0a\u8a18\u306e\u5f0f\u306b\u3042\u3066\u306f\u3081\u308b\u3068<br \/>\n(undoblks \/ 600)\u3000\u00d7\u3000maxquerylen\u3000\u00d7\u30008192<\/p>\n<p>\u3053\u3053\u3067\u6c42\u3081\u3089\u308c\u305f\u5024\u304c\u3001UNDO\u8868\u9818\u57df\u306b\u5fc5\u8981\u306a\u30b5\u30a4\u30ba\uff08\u6982\u7b97\uff09\u3068\u306a\u308b\u3002<br \/>\n\u5f53\u7136\u3001\u30d0\u30a4\u30c8\u306a\u3093\u30671024\u3067\u9069\u5ea6\u306b\u9664\u7b97\u3057\u3066MB\u3067\u3082GB\u3067\u3082\u6c42\u3081\u308c\u3070\u3088\u3044\u3002<\/p>\n<p><\/code><code><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>11.1.0.7.0 \u4ee5\u964d\u306e\u30ea\u30ea\u30fc\u30b9\u306b\u5bfe\u5fdc select (((UR * UPS + (select 127 + (ma<\/p>\n<p><a class=\"more-link\" href=\"http:\/\/www.shamonabe.com\/?p=73\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/73"}],"collection":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=73"}],"version-history":[{"count":1,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/73\/revisions"}],"predecessor-version":[{"id":74,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=\/wp\/v2\/posts\/73\/revisions\/74"}],"wp:attachment":[{"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=73"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=73"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.shamonabe.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=73"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}