{"id":377,"date":"2024-11-19T15:36:19","date_gmt":"2024-11-19T06:36:19","guid":{"rendered":"https:\/\/sejiwon.com\/?p=377"},"modified":"2024-11-19T15:36:19","modified_gmt":"2024-11-19T06:36:19","slug":"%ec%88%98%ec%a7%91%eb%90%9c-%ed%86%b5%ea%b3%84%ec%a0%95%eb%b3%b4-%ed%99%95%ec%9d%b8%eb%b0%a9%eb%b2%95%ec%98%a4%eb%9d%bc%ed%81%b4","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=377","title":{"rendered":"\uc218\uc9d1\ub41c \ud1b5\uacc4\uc815\ubcf4 \ud655\uc778\ubc29\ubc95(\uc624\ub77c\ud074)"},"content":{"rendered":"\n<p>QUERY\ub97c \uc791\uc131\ud558\ub2e4\ubcf4\uba74 \uc774 \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0\ub294 \ucd1d \uba87 \uac74\uc758 \ub808\ucf54\ub4dc\uac00 \uc874\uc7ac\ud558\ub294\uc9c0 \uad81\uae08\ud560 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uad81\uae08\ud55c \uac83\uc744 \ub118\uc5b4\uc11c \uaf2d \ud655\uc778\uc744 \ud558\uace0 \ub118\uc5b4\uac00\uc57c \uc88b\uc740 SQL\uc744 \uc791\uc131\ud560 \uc218 \uc788\ub2e4\uace0 \uc0dd\uac01\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc544\ub798 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc744 \uacf5\uc720\ud558\uace0\uc790 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\uc77c\ubc18\uc801\uc73c\ub85c \uac1c\ubc1c\uc790\ubd84\ub4e4\ud55c\ud14c\ub294 DBA\uac00 \ubcf4\ub294 \ud1b5\uacc4\uc815\ubcf4\ub294 \uacf5\uc720\uac00 \uc548\ub418\ub294 \uc0ac\uc774\ud2b8\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8\ub798\uc11c DBA\uac00 \ubcf4\ub294 \ud1b5\uacc4\uc815\ubcf4 \ub300\uc2e0\uc5d0 \ud574\ub2f9 TABLE OWNER\ub77c\uba74 \ud655\uc778 \uac00\ub2a5\ud55c \uac83\uc744 \uc54c\ub824\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>ALL_TAB_STATISTICS \uc5d0\uc11c \uac19\uc740 \uc815\ubcf4\ud655\uc778\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT OWNER\n      ,TABLE_NAME\n      ,NUM_ROWS      \/* \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub41c \ucd1d \ub808\ucf54\ub4dc \uac1c\uc218 *\/\n      ,BLOCKS        \/* \ud14c\uc774\ube14 \ube14\ub85d \uc218 (\ub370\uc774\ud130\uac00 \ud55c \uac74\uc774\ub77c\ub3c4 \uc785\ub825\ub41c \uc801 \uc788\ub294 \ubaa8\ub4e0 \uc775\uc2a4\ud150\ud2b8)\uc5d0  \n                        \uc18d\ud55c \ucd1d \ube14\ub85d \uc218 *\/\n      ,AVG_ROW_LEN   \/* \ub808\ucf54\ub4dc\ub2f9 \ud3c9\uade0\uae38\uc774(BYTES *\/\n      ,LAST_ANALYZED \/* \ud1b5\uacc4\uc815\ubcf4 \uc218\uc9d1\uc77c\uc2dc *\/\n  FROM ALL_TABLES\n WHERE TABLE_NAME = '\ud14c\uc774\ube14\uba85'\n;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-verse\">\uc5ec\ub7ec \ud14c\uc774\ube14\uc744 \uc870\uc778\ud558\ub294 \uacbd\uc6b0\ub77c\uba74 IN\uc73c\ub85c \ud14c\uc774\ube14\uba85\uc744 \uac80\uc0c9 \ud6c4 ORDER BY NUM_ROWS \ub97c \ucd94\uac00\ud558\uba74 \ud14c\uc774\ube14\uc5d0 \uac74\uc218\uac00 \uc801\uc740 \uac83\uc5d0\uc11c \ud070 \uc21c\uc73c\ub85c \uc815\ub82c\ub418\uc5b4 \ubcf4\uc774\ubbc0\ub85c \ud14c\uc774\ube14 \uc5f0\uacb0\uc5d0 \ucc38\uace0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>QUERY\ub97c \uc791\uc131\ud558\ub2e4\ubcf4\uba74 \uc774 \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0\ub294 \ucd1d \uba87 \uac74\uc758 \ub808\ucf54\ub4dc\uac00 \uc874\uc7ac\ud558\ub294\uc9c0 \uad81\uae08\ud560 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uad81\uae08\ud55c \uac83\uc744 \ub118\uc5b4\uc11c \uaf2d \ud655\uc778\uc744 \ud558\uace0 \ub118\uc5b4\uac00\uc57c \uc88b\uc740 SQL\uc744 \uc791\uc131\ud560 \uc218 \uc788\ub2e4\uace0 \uc0dd\uac01\ub429\ub2c8\ub2e4. \uc544\ub798 \ud1b5\uacc4\uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uc5ec \ud655\uc778\ud558\ub294 \ubc29\ubc95\uc744 \uacf5\uc720\ud558\uace0\uc790 \ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uac1c\ubc1c\uc790\ubd84\ub4e4\ud55c\ud14c\ub294 DBA\uac00 \ubcf4\ub294 \ud1b5\uacc4\uc815\ubcf4\ub294 \uacf5\uc720\uac00 \uc548\ub418\ub294 \uc0ac\uc774\ud2b8\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \uadf8\ub798\uc11c DBA\uac00 \ubcf4\ub294 \ud1b5\uacc4\uc815\ubcf4 \ub300\uc2e0\uc5d0 \ud574\ub2f9 TABLE OWNER\ub77c\uba74 \ud655\uc778 \uac00\ub2a5\ud55c \uac83\uc744 \uc54c\ub824\ub4dc\ub9bd\ub2c8\ub2e4. ALL_TAB_STATISTICS\u2026 <span class=\"read-more\"><a href=\"https:\/\/sejiwon.com\/?p=377\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/377"}],"collection":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=377"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/377\/revisions"}],"predecessor-version":[{"id":378,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/377\/revisions\/378"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}