{"id":712,"date":"2015-11-24T05:27:42","date_gmt":"2015-11-24T05:27:42","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=712"},"modified":"2015-11-24T05:27:42","modified_gmt":"2015-11-24T05:27:42","slug":"%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%b3%84-io-%ed%99%95%ec%9d%b8-%ec%bf%bc%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=712","title":{"rendered":"\ud14c\uc774\ube14 \ubcc4 I\/O \ud655\uc778 \ucffc\ub9ac"},"content":{"rendered":"<p >Enterprise Edition \ud658\uacbd\uc5d0\uc11c&nbsp;\ud14c\uc774\ube14 \ubcc4<span > I\/O<\/span>\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ucffc\ub9ac \uc785\ub2c8\ub2e4<span >.<\/span><\/p>\n<p >\ud574\ub2f9\ud558\ub294<span > OWNER,<br \/>\nOBJECT_NAME<\/span>\uc73c\ub85c \ucffc\ub9ac \uc218\ud589\ud558\uc154\uc11c<span ><\/span><\/p>\n<p ><span >SNAP_TIME <\/span>\uceec\ub7fc\uc5d0\uc11c \ud574\ub2f9\uae30\uac04\uc744 \ud655\uc778\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4<span >.<\/span><\/p>\n<\/p>\n<p >\uc544\ub798 \ucffc\ub9ac\ub294<span > AWR<\/span>\ub97c \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ubdf0\ub97c \uc870\ud68c\ud558\uae30 \ub54c\ubb38\uc5d0<span > EE <\/span>\ubc84\uc804\uacfc<span > diagnostic pack<\/span>\uc774 \ud544\uc694\ud569\ub2c8\ub2e4<span >.&nbsp;<\/span><\/p>\n<p ><span ><\/span><\/p>\n<p >\uc774\uc5d0 \ud574\ub2f9\ud558\ub294\uc9c0 \ud655\uc778\ud558\uc2dc\uace0 \uc218\ud589 \ud558\uc154\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<div class=\"txc-textbox\" style=\"border: 3px double rgb(193, 193, 193); padding: 10px; background-color: rgb(238, 238, 238);\">\n<p ><span >select to_char(end_interval_time, &#8216;yyyy-mm-dd<br \/>\nhh24:mi:ss&#8217;) snap_time, a.OWNER,a.OBJECT_NAME,b.* from dba_hist_seg_stat_obj a<br \/>\n, dba_hist_seg_stat b, dba_hist_snapshot c where a.OWNER=&#8217;<\/span><b>\uc720\uc800\uba85<\/b><span >&#8216; and<br \/>\na.OBJECT_NAME=&#8217;<\/span><b>\ud14c\uc774\ube14\uba85<\/b><span >&#8216; and a.OBJ#=b.OBJ# and a.DATAOBJ#=b.DATAOBJ#<br \/>\nand b.snap_id=c.SNAP_ID ;<\/span><\/p>\n<p  align=\"left\" style=\"margin: 2pt 0cm; word-break: keep-all;\"><span ><\/span><\/p>\n<\/div>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enterprise Edition \ud658\uacbd\uc5d0\uc11c&nbsp;\ud14c\uc774\ube14 \ubcc4 I\/O\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ucffc\ub9ac \uc785\ub2c8\ub2e4. \ud574\ub2f9\ud558\ub294 OWNER, OBJECT_NAME\uc73c\ub85c \ucffc\ub9ac \uc218\ud589\ud558\uc154\uc11c SNAP_TIME \uceec\ub7fc\uc5d0\uc11c \ud574\ub2f9\uae30\uac04\uc744 \ud655\uc778\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798 \ucffc\ub9ac\ub294 AWR\ub97c \uc815\ubcf4\ub97c \uac00\uc9c0\uace0 \uc788\ub294 \ubdf0\ub97c \uc870\ud68c\ud558\uae30 \ub54c\ubb38\uc5d0 EE \ubc84\uc804\uacfc diagnostic pack\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.&nbsp; \uc774\uc5d0 \ud574\ub2f9\ud558\ub294\uc9c0 \ud655\uc778\ud558\uc2dc\uace0 \uc218\ud589 \ud558\uc154\uc57c \ud569\ub2c8\ub2e4. select to_char(end_interval_time, &#8216;yyyy-mm-dd hh24:mi:ss&#8217;) snap_time, a.OWNER,a.OBJECT_NAME,b.* from dba_hist_seg_stat_obj a , dba_hist_seg_stat b, dba_hist_snapshot c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[11],"tags":[398],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/712"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=712"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/712\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=712"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}