{"id":355,"date":"2015-05-12T09:04:38","date_gmt":"2015-05-12T09:04:38","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=355"},"modified":"2015-05-12T09:04:38","modified_gmt":"2015-05-12T09:04:38","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-awr-%ec%9d%80-%eb%8f%88%ec%a3%bc%ea%b3%a0-%ec%82%ac%ec%95%bc-%ed%95%98%eb%8a%94-%ea%b8%b0%eb%8a%a5%ec%9e%85%eb%8b%88%eb%8b%a4","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=355","title":{"rendered":"\uc624\ub77c\ud074 AWR \uc740 \ub3c8\uc8fc\uace0 \uc0ac\uc57c \ud558\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4."},"content":{"rendered":"

AWR <\/span>\ubdf0 \uc790\uccb4\ub97c \uc870\ud68c\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc9c4\ub2e8&<\/span>\ud29c\ub2dd \ud329 \uc635\uc158\uc744 \ubcc4\ub3c4\ub85c \uad6c\ub9e4\ud574\uc57c
\n\ud569\ub2c8\ub2e4. <\/span>\uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ubd88\ubc95\uc785\ub2c8\ub2e4.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

\ub9ac\ud3ec\ud2b8\ub3c4 \ubdf0\ub97c \uae30\ubc18\uc73c\ub85c \uc0dd\uc131\ub418\uae30 \ub54c\ubb38\uc5d0 \ub77c\uc774\uc120\uc2a4\ub97c \uad6c\ub9e4\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

AWR <\/span>\ub370\uc774\ud130\ub97c \uc790\ub3d9 \uc218\uc9d1\ud558\ub294 \uac83\uc740 \ubd88\ubc95\uc774 \uc544\ub2c8\uc9c0\ub9cc \uc218\uc9d1\ub41c AWR <\/span>\ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub824\uba74
\n\ub77c\uc774\uc120\uc2a4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

\ubd88\ubc95 \uc0ac\uc6a9 \uc5ec\ubd80\ub294 dba_feature_usage_statistics<\/span>\ub97c
\n\ud1b5\ud574 \uc624\ub77c\ud074\uc5d0\uc11c \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/span><\/b><\/p>\n

 <\/span><\/p>\n

\ucc38\uace0\ub85c \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc5d0\ub514\uc158\ub9cc AWR<\/span>\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, <\/span>\uc2a4\ud0e0\ub2e4\ub4dc \uc5d0\ub514\uc158\uc774\uac70\ub098 \ub77c\uc774\uc120\uc2a4\uac00 \uc5c6\uc744
\n\uacbd\uc6b0 Statspack<\/span>\uc744 \ubb34\ub8cc\ub85c \uc0ac\uc6a9\ud558\ub77c\uace0 \ub418\uc5b4\uc788\ub124\uc694. <\/span><\/span><\/u><\/b><\/p>\n

\uc989, Statspack(<\/span>\uacf5\uc9dc), AWR(ADDM, ASH)<\/span>\ub294 \uc720\ub8cc.<\/span><\/span><\/u><\/b><\/p>\n

 <\/span><\/p>\n

\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 MOS<\/span>\uc758 \ub2e4\uc74c 2<\/span>\uac1c \ub178\ud2b8\ub97c \ucc38\uace0 \ubc14\ub78d\ub2c8\ub2e4. <\/span><\/span><\/p>\n

Licensing Requirements<\/span><\/b><\/p>\n

The Automatic Workload
\nRepository (AWR) is a feature that allows database information to be
\nrecorded for multiple purposes including detection and elimination of
\nperformance issues. By default AWR data collection is enabled collecting
\nvarious information on database activity. Many database features such as
\nAutomatic Segment Advisor and Undo Advisor need information captured by the
\nAWR. Use of these features, which implicitly access some AWR views, does NOT
\nrequire any Pack licenses. HOWEVER, direct access to AWR views and reports is
\nNOT permitted without the Diagnostic Pack license.<\/span><\/p>\n

 <\/span><\/p>\n

In order to produce reports,
\naccess AWR views or use the diagnostic information from any part of the
\nAutomatic Workload Repository the Diagnostic Pack License is required. This
\nincludes the production of AWR reports, ADDM reports and ASH reports even if
\nthese are requested by product support or other agencies. It is the user
\nresponsibility to comply with license requirements and not violate license
\nagreements.<\/span><\/b> For details of what is included in the Diagnostic Pack,
\nsee:<\/span><\/p>\n

 <\/span><\/p>\n

\uc790\ub3d9 \uc138\uadf8\uba3c\ud2b8 \uc5b4\ub4dc\ubc14\uc774\uc800\ub098 \uc5b8\ub450 \uc5b4\ub4dc\ubc14\uc774\uc800\uc5d0\uc11c \uc77c\ubd80 AWR<\/span>\ub97c \uc5b4\ub4dc\ubc14\uc774\uc800\uc5d0\uc11c
\n\uc790\ub3d9\uc73c\ub85c \uc561\uc138\uc2a4\ud558\ub294 \uac83\uc740 \ub77c\uc774\uc120\uc2a4\uac00 \ubd88\ud544\uc694\ud569\ub2c8\ub2e4. <\/span><\/span><\/p>\n

 <\/span><\/p>\n

\uadf8\ub7ec\ub098, AWR <\/span>\ubdf0\ub97c \uc9c1\uc811 \uc561\uc138\uc2a4\ud558\uac70\ub098 \ub9ac\ud3ec\ud305 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub294 \uac83\uc740
\n\uc9c4\ub2e8 \ud29c\ub2dd \ud329 \ub77c\uc774\uc120\uc2a4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

\uc989, <\/span><\/span>\uc0ac\uc6a9\uc790\uac00 \uba85\uc2dc\uc801\uc73c\ub85c \uc5b4\ub5a0\ud55c \ud615\ud0dc\ub85c\ub4e0 AWR <\/span>\ubdf0\uc5d0
\n\uc561\uc138\uc2a4\ud558\ub824\uba74 \ub77c\uc774\uc120\uc2a4\ub97c \uad6c\ub9e4<\/span><\/u><\/b>\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n

 <\/span>AWR Reporting – Licensing Requirements Clarification (<\/span><\/b>\ubb38\uc11c ID 1490798.1)<\/span><\/span><\/b><\/p>\n

<\/p>\n

Controlling
\nDiagnostic and Tuning Pack Usage and Disabling AWR (<\/span><\/b>\ubb38\uc11c ID 436386.1)<\/span><\/span><\/b><\/p>\n

 <\/span><\/p>\n

cfile1.uf.212BAF3A5551C16E2C2933.pdf<\/a><\/p>\n


<\/span><\/span><\/b><\/p>\n

cfile28.uf.2657123A5551C16F1C30E1.pdf<\/a><\/p>\n

<\/span><\/b><\/p>\n

 <\/span><\/p>\n

 <\/span><\/p>\n<\/p>\n

\uc8fc\uc758 \uc0ac\ud56d \ud558\ub098\ub354 \u2026. AWR <\/u><\/span>\uae30\ub2a5 \uc9c0\uc6d0\ud558\ub294 3-rd <\/span>\ud30c\ud2f0 \uc194\ub8e8\uc158(<\/span>\uc608\ub97c \ub4e4\uc5b4 BMT<\/span>\ubaa9\uc801\uc73c\ub85c \uc124\uce58\ud588\ub358???
\n) <\/span>\ub4e4\uc774 AWR <\/span>\ubdf0\ub97c SELECT <\/span><\/u>\ud560
\n\uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n

AWR <\/span>\ub808\ud3ec\ud2b8 \uc548\ubf51\uc544\ub3c4 AWR \ubdf0\ub9cc \uc870\ud68c \ud574\ub3c4 LMS \uc218\ud589\uc2dc \uac78\ub9bd\ub2c8\ub2e4. <\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n

\ud558\uc9c0\ub9cc \uc544\ub798\uc758 \ubdf0\uc5d0 \ud55c\ud574\uc11c\ub294 \uc635\uc158 \uae30\ub2a5 \uad6c\ub9e4 \uc5c6\uc5b4\ub3c4 \uacf5\uc9dc\ub85c \uc0ac\uc6a9 \uac00\ub2a5 \ud569\ub2c8\ub2e4.<\/font><\/p>\n


<\/font><\/p>\n

1.     <\/span><\/span>All data dictionary views beginning with the
\nprefix DBA_HIST_ are part of this pack, along with their underlying tables.The
\nonly exception are the views: <\/span><\/p>\n

DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE,
\nDBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ, and
\nDBA_HIST_UNDOSTAT.<\/span><\/p>\n


<\/span><\/u><\/b><\/p>\n

They can be
\nused without the Diagnostic Pack license.<\/span><\/u><\/b><\/p>\n


<\/span><\/p>\n

http:\/\/blog.tanelpoder.com\/2009\/05\/06\/free-dba_hist-awr-views-in-11g\/<\/span><\/p>\n


<\/span><\/p>\n


<\/span><\/u><\/b><\/p>\n


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

AWR \ubdf0 \uc790\uccb4\ub97c \uc870\ud68c\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc9c4\ub2e8&\ud29c\ub2dd \ud329 \uc635\uc158\uc744 \ubcc4\ub3c4\ub85c \uad6c\ub9e4\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \ubd88\ubc95\uc785\ub2c8\ub2e4.   \ub9ac\ud3ec\ud2b8\ub3c4 \ubdf0\ub97c \uae30\ubc18\uc73c\ub85c \uc0dd\uc131\ub418\uae30 \ub54c\ubb38\uc5d0 \ub77c\uc774\uc120\uc2a4\ub97c \uad6c\ub9e4\ud574\uc57c \ud569\ub2c8\ub2e4.   AWR \ub370\uc774\ud130\ub97c \uc790\ub3d9 \uc218\uc9d1\ud558\ub294 \uac83\uc740 \ubd88\ubc95\uc774 \uc544\ub2c8\uc9c0\ub9cc \uc218\uc9d1\ub41c AWR \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\ub824\uba74 \ub77c\uc774\uc120\uc2a4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.   \ubd88\ubc95 \uc0ac\uc6a9 \uc5ec\ubd80\ub294 dba_feature_usage_statistics\ub97c \ud1b5\ud574 \uc624\ub77c\ud074\uc5d0\uc11c \ud30c\uc545\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.   \ucc38\uace0\ub85c \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc5d0\ub514\uc158\ub9cc AWR\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, \uc2a4\ud0e0\ub2e4\ub4dc […]<\/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":[9],"tags":[69,70,71],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/355"}],"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=355"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/355\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}