{"id":1097,"date":"2016-01-02T13:19:46","date_gmt":"2016-01-02T13:19:46","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1097"},"modified":"2016-01-02T13:19:46","modified_gmt":"2016-01-02T13:19:46","slug":"awr-%ec%9e%ac%ea%b5%ac%ec%84%b1%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1097","title":{"rendered":"AWR \uc7ac\uad6c\uc131\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"

\uc624\ub77c\ud074\uc740<\/SPAN> \uae30\ubcf8\uc801\uc73c\ub85c<\/SPAN> AWR SNAPSHOT\uc744<\/SPAN> \uc8fc\uae30\uc801\uc73c\ub85c<\/SPAN> \uc0dd\uc131\ud569\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

SYSAUX Tablespace \uc758<\/SPAN> \uacf5\uac04\uc5d0\ub3c4<\/SPAN> \ubb38\uc81c\uac00<\/SPAN> \uc5c6\uc5c8\uace0<\/SPAN>, DB\uc790\uccb4\uc5d0\ub3c4<\/SPAN> \ubb38\uc81c\uac00<\/SPAN> \uc5c6\uc5c8\ub294\ub370<\/SPAN> Snapshot \uc774<\/SPAN> \uc0dd\uc131\uc774<\/SPAN> \ub418\uc9c0<\/SPAN> \uc54a\ub294<\/SPAN> \uacbd\uc6b0\uac00<\/SPAN> \ubc1c\uc0dd\ud558\uc600\ub358<\/SPAN> \uc801\uc774<\/SPAN> \uc788\uc2b5\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

\uc544\uc608<\/SPAN> \ubc1c\uc0dd\ud558\uc9c0<\/SPAN> \uc54a\uc740\uac8c<\/SPAN> \uc544\ub2c8\ub77c<\/SPAN> \ub4dc\ubb38\ub4dc\ubb38<\/SPAN> \uc0dd\uc131\uc774<\/SPAN> \ub418\uc9c0<\/SPAN> \uc54a\uc558\uace0<\/SPAN>, \uc218\ub3d9\uc73c\ub85c<\/SPAN> \uc0dd\uc131\uc2dc<\/SPAN> Hang \uc774<\/SPAN> \ubc1c\uc0dd\ud558\uc600\uc2b5\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

\ud574\ub2f9<\/SPAN> \uc774\uc288\uc5d0<\/SPAN> \ub300\ud574\uc11c<\/SPAN> MOS \uc5d0\uc11c\ub294<\/SPAN> AWR \ubc84\uadf8<\/SPAN> \ub77c<\/SPAN> \ub098\uc640<\/SPAN> \uc788\uc5c8\uc2b5\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

\uadf8\ub798\uc11c<\/SPAN> \ub098\uc628<\/SPAN> \ud574\uacb0\ucc45\uc740<\/SPAN> AWR\uc758<\/SPAN> \uc7ac\uad6c\uc131<\/SPAN> \uc774\uc5c8\uc2b5\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

   <\/P>
\n

$> sqlplus “\/as sysdba”<\/STRONG> <\/P>
\n

SQL)@?\/rdbms\/admin\/catnoawr.sql \uc744<\/SPAN> \uc774\uc6a9\ud574\uc11c<\/SPAN> AWR Table Clear<\/STRONG> <\/P>
\n

SQL)@?\/rdbms\/admin\/catawrtb.sql \uc744<\/SPAN> \uc774\uc6a9\ud574\uc11c<\/SPAN> AWR Table \uc744<\/SPAN> \uc0dd\uc131\ud574<\/SPAN> \uc90d\ub2c8\ub2e4<\/SPAN>.<\/STRONG> <\/P>
\n

\uadf8\ub9ac\uace0<\/SPAN> DB\ub97c<\/SPAN> \uc7ac\uae30\ub3d9<\/SPAN> \ud569\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

RAC \uac19\uc740<\/SPAN> \uacbd\uc6b0<\/SPAN> Instance \ubcc4\ub85c<\/SPAN> \uc7ac\uae30\ub3d9\ud558\uc2dc\uba74<\/SPAN> \ub429\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

   <\/P>
\n

\uc7ac\uae30\ub3d9<\/SPAN> \ud6c4<\/SPAN> \uc544\ub798\uc758<\/SPAN> \uba85\ub839\uc5b4\ub97c<\/SPAN> \uc774\uc6a9\ud574<\/SPAN> \uc218\ub3d9\uc73c\ub85c<\/SPAN> AWR Snapshot \uc0dd\uc131<\/SPAN> \ud14c\uc2a4\ud2b8<\/SPAN> \uc9c4\ud589\ud569\ub2c8\ub2e4<\/SPAN>. <\/P>
\n

   <\/P>
\n

SQL) exec dbms_workload_repository.create_snapshot; <\/P>
\n

   <\/P>
\n

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

\uc624\ub77c\ud074\uc740 \uae30\ubcf8\uc801\uc73c\ub85c AWR SNAPSHOT\uc744 \uc8fc\uae30\uc801\uc73c\ub85c \uc0dd\uc131\ud569\ub2c8\ub2e4. SYSAUX Tablespace \uc758 \uacf5\uac04\uc5d0\ub3c4 \ubb38\uc81c\uac00 \uc5c6\uc5c8\uace0, DB\uc790\uccb4\uc5d0\ub3c4 \ubb38\uc81c\uac00 \uc5c6\uc5c8\ub294\ub370 Snapshot \uc774 \uc0dd\uc131\uc774 \ub418\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud558\uc600\ub358 \uc801\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc544\uc608 \ubc1c\uc0dd\ud558\uc9c0 \uc54a\uc740\uac8c \uc544\ub2c8\ub77c \ub4dc\ubb38\ub4dc\ubb38 \uc0dd\uc131\uc774 \ub418\uc9c0 \uc54a\uc558\uace0, \uc218\ub3d9\uc73c\ub85c \uc0dd\uc131\uc2dc Hang \uc774 \ubc1c\uc0dd\ud558\uc600\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \uc774\uc288\uc5d0 \ub300\ud574\uc11c MOS \uc5d0\uc11c\ub294 AWR \ubc84\uadf8 \ub77c \ub098\uc640 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c \ub098\uc628 \ud574\uacb0\ucc45\uc740 AWR\uc758 \uc7ac\uad6c\uc131 \uc774\uc5c8\uc2b5\ub2c8\ub2e4.     […]<\/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":[14],"tags":[69,598,599,600,601],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1097"}],"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=1097"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1097\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1097"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1097"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1097"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}