\n
\n
\n
- \ud55c \ubc88\uc5d0 10\uac1c \uc815\ub3c4\uc758 \uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1\uc744 \uad8c\uace0 <\/SPAN><\/LI>
\n- ex: \ucd9c\uadfc \ud574\uc11c \uccb4\ud06c, \ud1f4\uadfc \uc2dc \uccb4\ud06c \ud6c4 \uc0ac\uc6a9 \ud55c \uc778\ub371\uc2a4\uac00 \uc788\uc73c\uba74 \ubaa8\ub2c8\ud130\ub9c1 \uc885\ub8cc, \ub2e4\ub978 \uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc791(10\uac1c \uc815\ub3c4\uc758 \uc778\ub371\uc2a4\ub97c \uc720\uc9c0) <\/SPAN><\/LI>
\n- alter index <index_name> monitoring usage ; <\/SPAN><\/LI>
\n- alter index <index_name> nomonitoring usage ; <\/SPAN><\/LI><\/UL><\/LI>
\n
\n\ucc38\uc870 \ubdf0 <\/SPAN><\/DIV>
\n- select * from v$object_usage ; <\/SPAN><\/LI><\/UL><\/LI>
\n- \uc0ac\uc6a9 \uc608 <\/SPAN><\/LI><\/UL>
\n(<\/SPAN>\ucc38\uace0<\/SPAN>) <\/SPAN>\ud2b9\uc815<\/SPAN> Index<\/SPAN>\uc758<\/SPAN> <\/SPAN>\uc0ac\uc6a9<\/SPAN> <\/SPAN>\uc5ec\ubd80\ub97c<\/SPAN> <\/SPAN>\ud310\ub2e8\ud558\ub294<\/SPAN> <\/SPAN>\ubc29\ubc95<\/SPAN><\/STRONG> <\/SPAN><\/SPAN><\/P>
\n
\n\ub2e4\uc74c<\/SPAN> <\/SPAN>\uba85\ub839\uc744<\/SPAN> <\/SPAN>\ud1b5\ud574<\/SPAN> index<\/SPAN>\uc758<\/SPAN> <\/SPAN>\uc0ac\uc6a9\uc5ec\ubd80\ub97c<\/SPAN> monitoring <\/SPAN>\ud558\uac70\ub098<\/SPAN> monitoring<\/SPAN>\uc744<\/SPAN> <\/SPAN>\ud574\uc81c\ud560<\/SPAN> <\/SPAN>\uc218<\/SPAN> <\/SPAN>\uc788\ub2e4<\/SPAN>. monitoring <\/SPAN>\uc124\uc815\uc740<\/SPAN> index owner <\/SPAN>\ub610\ub294<\/SPAN> admin <\/SPAN>\uad8c\ud55c\uc744<\/SPAN> <\/SPAN>\uac16\ub294<\/SPAN> user<\/SPAN>\uc5d0\uc11c<\/SPAN> <\/SPAN>\uc218\ud589<\/SPAN> <\/SPAN>\uac00\ub2a5\ud558\ub2e4<\/SPAN>. monitoring<\/SPAN>\uc744<\/SPAN> <\/SPAN>\uc911\ub2e8<\/SPAN> <\/SPAN>\ud560<\/SPAN> <\/SPAN>\ub54c\ub294<\/SPAN> nomonitoring usage <\/SPAN>\uad6c\ubb38\uc744<\/SPAN> <\/SPAN>\uc0ac\uc6a9\ud558\uba70<\/SPAN>, index owner <\/SPAN>\ub610\ub294<\/SPAN> admin <\/SPAN>\uad8c\ud55c\uc744<\/SPAN> <\/SPAN>\uac16\ub294<\/SPAN> user<\/SPAN>\uc5d0\uc11c<\/SPAN> <\/SPAN>\uc218\ud589\ud55c\ub2e4<\/SPAN>.<\/SPAN> <\/SPAN><\/SPAN><\/DIV>
\nalter index <index_name> <\/SPAN>monitoring<\/SPAN> usage;<\/SPAN> <\/SPAN><\/P>
\nalter index <index_name> <\/SPAN>nomonitoring<\/SPAN> usage;<\/SPAN> <\/SPAN><\/P><\/LI>
\n
\nv$object_usage<\/SPAN>\ub97c<\/SPAN> <\/SPAN>\uc870\ud68c\ud558\uc5ec<\/SPAN> Monitoring <\/SPAN>\uc0c1\ud0dc<\/SPAN> <\/SPAN>\ubc0f<\/SPAN> <\/SPAN>\uc0ac\uc6a9\uc5ec\ubd80\ub97c<\/SPAN> <\/SPAN>\uc54c<\/SPAN> <\/SPAN>\uc218<\/SPAN> <\/SPAN>\uc788\ub2e4<\/SPAN>. v$object_usage<\/SPAN>\ub294<\/SPAN> <\/SPAN>\ud574\ub2f9<\/SPAN> Index<\/SPAN>\uc758<\/SPAN> owner<\/SPAN>\uc5d0<\/SPAN> <\/SPAN>\uc811\uc18d\ud558\uc5ec<\/SPAN> <\/SPAN>\uc870\ud68c\ud574\uc57c\ub9cc<\/SPAN> Monitoring <\/SPAN>\uc0c1\ud0dc<\/SPAN> <\/SPAN>\ubc0f<\/SPAN> <\/SPAN>\uc0ac\uc6a9\uc5ec\ubd80\ub97c<\/SPAN> <\/SPAN>\uc870\ud68c\ud560<\/SPAN> <\/SPAN>\uc218<\/SPAN> <\/SPAN>\uc788\ub2e4<\/SPAN>.<\/SPAN> <\/SPAN><\/SPAN><\/DIV>
\nselect * from v$object_usage;<\/SPAN> <\/SPAN><\/P>
\n<\/P><\/LI>
\n
\n\uc0ac\uc6a9<\/SPAN> Sample<\/SPAN> <\/SPAN><\/SPAN><\/DIV>
\n<\/P>
\nSQL> alter index WHHH01_LCLIEXRT monitoring usage;<\/SPAN> <\/SPAN><\/P>
\n<\/P>
\nIndex altered. <\/SPAN><\/P>
\n<\/P>
\nSQL> select * from v$object_usage; <\/SPAN><\/P>
\n<\/P>
\nINDEX_NAME TABLE_NAME MON USE START_MONITORING END_MONITORING <\/SPAN><\/P>
\n—————————— —————————— — — ——————- ——————- <\/SPAN><\/P>
\nWHHH01_LCLIEXRT LCLIEXRT YES<\/SPAN> YES<\/STRONG><\/SPAN> 02\/20\/2006 14:42:57 <\/SPAN><\/SPAN><\/SPAN><\/P>
\n\uc0ac\uc6a9\uc5ec\ubd80\ub97c<\/SPAN> <\/SPAN>\uc54c\ub9ac\ub294<\/SPAN> USE <\/SPAN>\uceec\ub7fc\uc758<\/SPAN> <\/SPAN>\uac12\uc774<\/SPAN> YES<\/SPAN>\uc774\ubbc0\ub85c<\/SPAN> <\/SPAN>\uc0ac\uc6a9\ub418\ub294<\/SPAN> Index<\/SPAN>\uc774\ub2e4<\/SPAN>.<\/SPAN> <\/SPAN><\/SPAN><\/P>
\n<\/P>
\nSQL> alter index ocsdba.WHHH01_LCLIEXRT nomonitoring usage;<\/SPAN> <\/SPAN><\/P>
\n<\/P>
\nIndex altered. <\/SPAN><\/P>
\n<\/P>
\nSQL>select * from v$object_usage; <\/SPAN><\/P>
\n<\/P>
\nINDEX_NAME TABLE_NAME MON USE START_MONITORING END_MONITORING <\/SPAN><\/P>
\n—————————— —————————— — — ——————- ——————- <\/SPAN><\/P>
\nWHHH01_LCLIEXRT LCLIEXRT NO<\/SPAN> YES 02\/20\/2006 14:42:57 02\/20\/2006 14:45:28 <\/SPAN><\/P>
\n<\/P>
\n<\/P>
\nex) <\/SPAN><\/P>
\n# \uc0ac\uc6a9\uc5ec\ubd80 \uc870\ud68c <\/SPAN><\/P>
\nselect * from v$object_usage ; <\/SPAN><\/P>
\n![](\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.227E284A5688F40C23B78F.png?w=640\")
<\/SPAN><\/P>
\n<\/P>
\n# \uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 <\/SPAN><\/P>
\nalter index BONUS_IDX01 monitoring usage ; <\/SPAN><\/P>
\n![](\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile21.uf.2265E74D5688F40D169276.png?w=640\")
<\/SPAN><\/P>
\n<\/P>
\n# \uc778\ub371\uc2a4 \uc0ac\uc6a9 <\/SPAN><\/P>
\nselect \/*+INDEX(BONUS BONUS_IDX1)*\/ * from BONUS where ename=’AAA’ ; <\/SPAN><\/P>
\n![](\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile26.uf.236369395688F40E3AF53C.png?w=640\")
<\/SPAN><\/P>
\n<\/P>
\n# \uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \ud574\uc81c <\/SPAN><\/P>
\nalter index BONUS_IDX01 nomonitoring usage ; <\/SPAN><\/P>
\n![](\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile22.uf.246544445688F40E09C5D3.png?w=640\")
<\/SPAN><\/P>
\n<\/SPAN> <\/P><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"
\uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \ubc29\ubc95 \ud55c \ubc88\uc5d0 10\uac1c \uc815\ub3c4\uc758 \uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1\uc744 \uad8c\uace0 ex: \ucd9c\uadfc \ud574\uc11c \uccb4\ud06c, \ud1f4\uadfc \uc2dc \uccb4\ud06c \ud6c4 \uc0ac\uc6a9 \ud55c \uc778\ub371\uc2a4\uac00 \uc788\uc73c\uba74 \ubaa8\ub2c8\ud130\ub9c1 \uc885\ub8cc, \ub2e4\ub978 \uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc791(10\uac1c \uc815\ub3c4\uc758 \uc778\ub371\uc2a4\ub97c \uc720\uc9c0) alter index <index_name> monitoring usage ; alter index <index_name> nomonitoring usage ; \ucc38\uc870 \ubdf0 select * from v$object_usage ; \uc0ac\uc6a9 \uc608 (\ucc38\uace0) \ud2b9\uc815 Index\uc758 […]<\/p>\n","protected":false},"author":1,"featured_media":1192,"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":[3],"tags":[678,679,680],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.227E284A5688F40C23B78F.png?fit=590%2C115","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1191"}],"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=1191"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1191\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1192"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1191"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n - \uc0ac\uc6a9 \uc608 <\/SPAN><\/LI><\/UL>
\n - ex: \ucd9c\uadfc \ud574\uc11c \uccb4\ud06c, \ud1f4\uadfc \uc2dc \uccb4\ud06c \ud6c4 \uc0ac\uc6a9 \ud55c \uc778\ub371\uc2a4\uac00 \uc788\uc73c\uba74 \ubaa8\ub2c8\ud130\ub9c1 \uc885\ub8cc, \ub2e4\ub978 \uc778\ub371\uc2a4 \ubaa8\ub2c8\ud130\ub9c1 \uc2dc\uc791(10\uac1c \uc815\ub3c4\uc758 \uc778\ub371\uc2a4\ub97c \uc720\uc9c0) <\/SPAN><\/LI>
\n