{"id":1103,"date":"2016-01-02T16:19:26","date_gmt":"2016-01-02T16:19:26","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1103"},"modified":"2016-01-02T16:19:26","modified_gmt":"2016-01-02T16:19:26","slug":"automatic-shared-memory-management-asmm","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1103","title":{"rendered":"Automatic Shared Memory Management (ASMM)"},"content":{"rendered":"<ul>\n<li><span style=\"color:black\">\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uc911\uc694\ud55c \uacf5\uc720\uba54\ubaa8\ub9ac\uc758 \uad00\ub9ac\ub97c \uc790\ub3d9\ud654 \ud574\uc8fc\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc989, \ud574\ub2f9 \ud30c\ub77c\ubbf8\ud130\uc758 \uc9c0\uc815\uc774 \ud544\uc694 \uc5c6\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uac8c\ub2e4\uac00, \uac00\uc6a9\ud55c \uba54\ubaa8\ub9ac\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ud569\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:black\">\uc608\ub97c \ub4e4\uc5b4, OLTP \uc791\uc5c5\uc774 \ub0ae\uc5d0 \ubc1c\uc0dd\ud558\uace0 \ub300\uc6a9\ub7c9 \ubcd1\ub82c \uc77c\uad04\ucc98\ub9ac \uc791\uc5c5\uc774 \ubc24\uc5d0 \uc218\ud589\ub41c\ub2e4\uace0 \ud560 \ub54c, DBA\ub4e4\uc740 \uc774 \uc694\uad6c\uc0ac\ud56d\uc5d0 \ub9de\ucdb0 \ud574\ub2f9 \uba54\ubaa8\ub9ac \ud30c\ub77c\uba54\ud130\ub97c \uace0\ub824\ud574\uc57c \ud588\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:black\">Automatic Shared Memory Management\uc740 OLTP \uc791\uc5c5 \uc2dc, Buffer cache\uc5d0 \ub300\ubd80\ubd84\uc758 \uba54\ubaa8\ub9ac\ub97c \ud560\ub2f9\ud558\uc5ec \uc88b\uc740 I\/O \uc131\ub2a5\uc744 \ubcf4\uc7a5\ud558\uace0, \ubcd1\ub82c\uc77c\uad04\ucc98\ub9ac \uc791\uc5c5 \uc2dc\uc5d0\ub294 \uc774 \uba54\ubaa8\ub9ac\uac00 LARGE Pool \uc601\uc5ed\uc73c\ub85c \uc774\uc804\ub418\uc5b4 \ubcd1\ub82c\ucc98\ub9ac \uac00 \ud6a8\uc728\uc801\uc73c\ub85c \ucc98\ub9ac\ub418\uac8c\ub054 \uc870\uce58\ud569\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:black\">Automatic Shared Memory Management\uc740 SGA \uad6c\uc131\uc744 \uac04\ud3b8\ud558\uac8c \ud569\ub2c8\ub2e4. \uacfc\uac70\uc5d0\ub294, Buffer cache, shared pool, java pool \uadf8\ub9ac\uace0 large pool\uc5d0 \ub300\ud55c \uba54\ubaa8\ub9ac \uac12\uc744 \uc218\ub3d9\uc73c\ub85c \uc9c0\uc815\ud574\uc57c\ub9cc \ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098, \uc774\ub7ec\ud55c \uac12\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc9c0\uc815\ud558\ub294 \uac83\uc740 \uc0c1\ub2f9\ud788 \uc5b4\ub824\uc6b4 \uc77c\uc785\ub2c8\ub2e4. \uba54\ubaa8\ub9ac\ub97c \uc801\uac8c \ud560\ub2f9\ud55c \uacbd\uc6b0 \uc88b\uc9c0 \uc54a\uc740 \uc131\ub2a5\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uace0 \uba54\ubaa8\ub9ac \ubd80\uc871\ud604\uc0c1\uc744 \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\ub300\ub85c, \ud06c\uac8c \ud560\ub2f9\ud55c \uba54\ubaa8\ub9ac\ub294 \uac00\uc6a9 \uba54\ubaa8\ub9ac\ub97c \ub0ad\ube44\ud558\ub294 \uacb0\uacfc\ub97c \ub0b3\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:black\">Automatic Shared Memory Management\uc740 SGA \uad6c\uc131\uc744 \uac04\ud3b8\ud558\uac8c \ud569\ub2c8\ub2e4. \uacfc\uac70\uc5d0\ub294, Buffer cache, shared pool, java pool \uadf8\ub9ac\uace0 large pool\uc5d0 \ub300\ud55c \uba54\ubaa8\ub9ac \uac12\uc744 \uc218\ub3d9\uc73c\ub85c \uc9c0\uc815\ud574\uc57c\ub9cc \ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098, \uc774\ub7ec\ud55c \uac12\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uc9c0\uc815\ud558\ub294 \uac83\uc740 \uc0c1\ub2f9\ud788 \uc5b4\ub824\uc6b4 \uc77c\uc785\ub2c8\ub2e4. \uba54\ubaa8\ub9ac\ub97c \uc801\uac8c \ud560\ub2f9\ud55c \uacbd\uc6b0 \uc88b\uc9c0 \uc54a\uc740 \uc131\ub2a5\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uace0 \uba54\ubaa8\ub9ac \ubd80\uc871\ud604\uc0c1\uc744 \ucd08\ub798\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc18\ub300\ub85c, \ud06c\uac8c \ud560\ub2f9\ud55c \uba54\ubaa8\ub9ac\ub294 \uac00\uc6a9 \uba54\ubaa8\ub9ac\ub97c \ub0ad\ube44\ud558\ub294 \uacb0\uacfc\ub97c \ub0b3\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:black\">\uc774 \uae30\ub2a5\uc740 \uc804\uccb4 SGA \uad6c\uc131\uc694\uc18c\uc5d0\uc11c \uc0ac\uc6a9\ub420 \ucd1d MEMORY \ub97c \uc9c0\uc815\ud560 \uc218 \uc788\uac8c \ud569\ub2c8\ub2e4. \uc624\ub77c\ud074\uc740 \uc8fc\uae30\uc801\uc73c\ub85c \uc704 \uba54\ubaa8\ub9ac\ub97c \uc7ac \ubd84\ubc30\ud569\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li><span style=\"color:black\">\uc0c8\ub85c\uc6b4 SGA_TARGET \ud30c\ub77c\ubbf8\ud130\ub294 SGA \ub0b4\uc758 \ubaa8\ub4e0 MEMORY\uc744 \ub098\ud0c0\ub0c5\ub2c8\ub2e4. \uc774\ub294 \uc790\ub3d9\uc801\uc73c\ub85c \ud06c\uae30\uac00 \ubcc0\uacbd \uac00\ub2a5\ud55c \uc694\uc18c, \uc218\ub3d9\uc73c\ub85c \ubcc0\uacbd\ud560 \uc218 \uc788\ub294 \uc694\uc18c \uadf8\ub9ac\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ub3d9\uc2dc \ub0b4\ubd80\uc801\uc73c\ub85c \ud560\ub2f9\ub418\ub294 \uc694\uc18c\ub97c \ud3ec\ud568\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li><img src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile6.uf.236280365687F88C26ACB9.png?w=640\" data-recalc-dims=\"1\" \/><span style=\"color:black\"><br \/>\n\t\t\t<\/span><\/li>\n<li><span style=\"color:black\">\uc704 \ud654\uba74\uc758 \uc6b0\uce21 \uadf8\ub9bc\uc5d0\uc11c \ubcfc \uc218 \uc788\ub294 \ubc14\uc640 \uac19\uc774 \uc704 \uae30\ub2a5\uc740 SGA_TARGET \ud30c\ub77c\ubbf8\ud130\ub85c \uc9c0\uc815\ud569\ub2c8\ub2e4.<br \/>\n<\/span><\/li>\n<li>\n<div><span style=\"color:black\">SGA_TARGET \uac12\uc774 &#8216;0&#8217; \uc774 \uc544\ub2cc \uac12\uc73c\ub85c \uc9c0\uc815\ud558\uba74 \uc544\ub798 \ud30c\ub77c\uba54\ud130\ub4e4\uc740 \uc790\ub3d9\uc801\uc73c\ub85c \ub610\ud55c \ub3d9\uc801\uc73c\ub85c \uc9c0\uc815\ub418\ub294 \uac83\uc785\ub2c8\ub2e4.<br \/>\n<\/span><\/div>\n<ul style=\"margin-left: 54pt\">\n<li><span style=\"color:black\">Database buffer cache (Default pool)<\/span>\n\t\t\t\t<\/li>\n<li><span style=\"color:black\">Shared pool<\/span>\n\t\t\t\t<\/li>\n<li><span style=\"color:black\">Large pool<\/span>\n\t\t\t\t<\/li>\n<li><span style=\"color:black\">Java pool<\/span>\n\t\t\t\t<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \uc911\uc694\ud55c \uacf5\uc720\uba54\ubaa8\ub9ac\uc758 \uad00\ub9ac\ub97c \uc790\ub3d9\ud654 \ud574\uc8fc\ub294 \uae30\ub2a5\uc785\ub2c8\ub2e4. \uc989, \ud574\ub2f9 \ud30c\ub77c\ubbf8\ud130\uc758 \uc9c0\uc815\uc774 \ud544\uc694 \uc5c6\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uac8c\ub2e4\uac00, \uac00\uc6a9\ud55c \uba54\ubaa8\ub9ac\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, OLTP \uc791\uc5c5\uc774 \ub0ae\uc5d0 \ubc1c\uc0dd\ud558\uace0 \ub300\uc6a9\ub7c9 \ubcd1\ub82c \uc77c\uad04\ucc98\ub9ac \uc791\uc5c5\uc774 \ubc24\uc5d0 \uc218\ud589\ub41c\ub2e4\uace0 \ud560 \ub54c, DBA\ub4e4\uc740 \uc774 \uc694\uad6c\uc0ac\ud56d\uc5d0 \ub9de\ucdb0 \ud574\ub2f9 \uba54\ubaa8\ub9ac \ud30c\ub77c\uba54\ud130\ub97c \uace0\ub824\ud574\uc57c \ud588\uc2b5\ub2c8\ub2e4. Automatic Shared Memory Management\uc740 OLTP \uc791\uc5c5 \uc2dc, Buffer [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1104,"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":[612,577,122,300],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile6.uf.236280365687F88C26ACB9.png?fit=825%2C290","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1103"}],"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=1103"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1104"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1103"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}