{"id":386,"date":"2024-11-22T09:29:02","date_gmt":"2024-11-22T00:29:02","guid":{"rendered":"https:\/\/sejiwon.com\/?p=386"},"modified":"2024-11-22T09:29:02","modified_gmt":"2024-11-22T00:29:02","slug":"db%ea%b0%80-%ec%84%a4%ec%b9%98%eb%90%9c-%ed%95%98%eb%93%9c%ec%9b%a8%ec%96%b4-resource-%ed%99%95%ec%9d%b8%ed%95%98%eb%8a%94-%eb%b0%a9%eb%b2%95%ec%98%a4%eb%9d%bc%ed%81%b4","status":"publish","type":"post","link":"https:\/\/sejiwon.com\/?p=386","title":{"rendered":"DB\uac00 \uc124\uce58\ub41c \ud558\ub4dc\uc6e8\uc5b4 Resource \ud655\uc778\ud558\ub294 \ubc29\ubc95(\uc624\ub77c\ud074)"},"content":{"rendered":"\n<p>\uc624\ub77c\ud074\uc744 \uc0ac\uc6a9\ud558\ub2e4\ubcf4\uba74 \uc624\ub77c\ud074\uc774 \uc124\uce58\ub41c \ud558\ub4dc\uc6e8\uc5b4 \ub9ac\uc18c\uc2a4\uac00 \uad81\uae08\ud560 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ub7f4 \ub54c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ucffc\ub9ac\ub97c 2\uac1c \uc18c\uac1c\ud574 \ubd05\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uba3c\uc800 OS\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\ub294 \uc0ac\ud56d \uac00\ub839, CPU\uac2f\uc218\ub4f1\uc744 \ud655\uc778\ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\n  FROM V$OSSTAT\n;\n<\/code><\/pre>\n\n\n\n<p>\uc774\uc640 \ub354\ubd88\uc5b4 \ub514\uc2a4\ud06c I\/O\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ucffc\ub9ac\ub3c4 \ud558\ub098 \uc18c\uac1c\ud574 \ubd05\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT *\n  FROM V$SYSSTAT\n WHERE NAME LIKE 'physical reads%'\n;\n<\/code><\/pre>\n\n\n\n<p>\uc704 \ub450\uac1c \ubdf0\ub97c \uc798 \ud65c\uc6a9\ud558\uc5ec \uc5ec\ub7ec \uc815\ubcf4\ub97c \uc54c\uc544\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub77c\ud074\uc744 \uc0ac\uc6a9\ud558\ub2e4\ubcf4\uba74 \uc624\ub77c\ud074\uc774 \uc124\uce58\ub41c \ud558\ub4dc\uc6e8\uc5b4 \ub9ac\uc18c\uc2a4\uac00 \uad81\uae08\ud560 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7f4 \ub54c \uc720\uc6a9\ud558\uac8c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ucffc\ub9ac\ub97c 2\uac1c \uc18c\uac1c\ud574 \ubd05\ub2c8\ub2e4. \uba3c\uc800 OS\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\ub294 \uc0ac\ud56d \uac00\ub839, CPU\uac2f\uc218\ub4f1\uc744 \ud655\uc778\ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4. \uc774\uc640 \ub354\ubd88\uc5b4 \ub514\uc2a4\ud06c I\/O\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ucffc\ub9ac\ub3c4 \ud558\ub098 \uc18c\uac1c\ud574 \ubd05\ub2c8\ub2e4. \uc704 \ub450\uac1c \ubdf0\ub97c \uc798 \ud65c\uc6a9\ud558\uc5ec \uc5ec\ub7ec \uc815\ubcf4\ub97c \uc54c\uc544\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/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\/386"}],"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=386"}],"version-history":[{"count":1,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions"}],"predecessor-version":[{"id":387,"href":"https:\/\/sejiwon.com\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions\/387"}],"wp:attachment":[{"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sejiwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}