{"id":1154,"date":"2016-01-03T10:00:54","date_gmt":"2016-01-03T10:00:54","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1154"},"modified":"2016-01-03T10:00:54","modified_gmt":"2016-01-03T10:00:54","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-system-global-areasga","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1154","title":{"rendered":"\uc624\ub77c\ud074 System Global Area(SGA)"},"content":{"rendered":"<p><P style=\"MARGIN-LEFT: 21pt\"><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515; COLOR: black\">SGA <\/SPAN><\/P><br \/>\n<UL><br \/>\n<LI><SPAN style=\"COLOR: black\">SGA\ub294 \ud55c \uc624\ub77c\ud074\uc758 \uc778\uc2a4\ud134\uc2a4\uc5d0 \ub300\ud55c \ub370\uc774\ud130\uc640 \uc81c\uc5b4 \uc815\ubcf4\ub97c \uac00\uc9c0\ub294 \uacf5\uc720 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc785\ub2c8\ub2e4. SGA\uc640 \uc624\ub77c\ud074 \ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4\uac00 \uc624\ub77c\ud074 \uc778\uc2a4\ud134\uc2a4\ub97c \uad6c\ucd95\ud569\ub2c8\ub2e4. <SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"><\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc624\ub77c\ud074 \uc778\uc2a4\ud134\uc2a4\uac00 \uc2dc\uc791\ub420 \ub54c SGA\ub97c \ud560\ub2f9\ud558\uace0 \uc778\uc2a4\ud134\uc2a4\uac00 \uc885\ub8cc\ud558\uba74 \ud560\ub2f9\uc744 \ud574\uc81c\ud569\ub2c8\ub2e4. \uac01 \uc778\uc2a4\ud134\uc2a4\ub294 \uace0\uc720 SGA\ub97c \uac00\uc9d1\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc624\ub77c\ud074 \uc11c\ubc84\ub97c \ub3d9\uc2dc\uc5d0 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \uc0ac\uc6a9\uc790\ub294 SGA\uc758 \ub370\uc774\ud130\ub97c \uacf5\uc720\ud569\ub2c8\ub2e4. \uc804\uccb4 SGA\ub97c \uc2e4\uc81c \uba54\ubaa8\ub9ac \ud06c\uae30\uac00 \ud5c8\uc6a9\ud558\ub294 \ubc94\uc704\uc5d0\uc11c \uac00\uc7a5 \ud06c\uac8c \uc7a1\uc73c\uba74 \ub514\uc2a4\ud06c I\/O\ub97c \uc904\uc774\uace0 \uba54\ubaa8\ub9ac\uc5d0 \uac00\ub2a5\ud55c \ub9ce\uc740 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \ucd5c\uc801\uc758 \uc131\ub2a5\uc744 \ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">SGA\ud06c\uae30\ub294 \uc624\ub77c\ud074 \ub0b4\ubd80\uc5d0\uc11c \uc790\ub3d9\uc801\uc73c\ub85c \uad00\ub9ac\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\uc774 SGA\uc5d0\uc11c \uc800\uc7a5\ub41c \uc815\ubcf4\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc84\ud37c, \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c, \uacf5\uc720 \ud480 \uac19\uc740 \uc5ec\ub7ec \ud615\ud0dc\uc758 \uba54\ubaa8\ub9ac \uad6c\uc870\ub85c \ub098\ub204\uc5b4\uc9d1\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc84\ud37c(database buffer cache) <\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">SGA \uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc84\ud37c\ub294 \uac00\uc7a5 \ucd5c\uadfc\uc5d0 \uc0ac\uc6a9\ub41c \ub370\uc774\ud130 \ube14\ub7ed\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc774 \ubc84\ud37c\ub294 \uc544\uc9c1\uae4c\uc9c0 \ub514\uc2a4\ud06c\uc5d0 \uc644\uc804\ud788 \uc4f0\uc5ec\uc9c0\uc9c0 \uc54a\ub294 \uc218\uc815\ub41c \ub370\uc774\ud130\ub97c \ubcf4\uc720\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. LRU \uc54c\uace0\ub9ac\uc998\uc5d0 \uc758\ud558\uc5ec \uac00\uc7a5 \uc624\ub798\uc804\uc5d0 \uc0ac\uc6a9\ub41c \uac83\uc740 \ub514\uc2a4\ud06c\uc5d0 \uc800\uc7a5\ud558\uace0 \uba54\ubaa8\ub9ac\uc5d0\ub294 \uac00\uc7a5 \ucd5c\uadfc\uc5d0 \uc0ac\uc6a9\ub41c \ub370\uc774\ud130\ub97c \uc800\uc7a5 \ud558\ubbc0\ub85c\uc368, \ub514\uc2a4\ud06c \uc785\ucd9c\ub825\uc774 \uc904\uc5b4 \ub4e4\uace0, \ub530\ub77c\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc758 \uc131\ub2a5\uc740 \uc99d\uac00 \ub429\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">\uc778\uc2a4\ud134\uc2a4\uc640 SGA \uac00 \uc0dd\uc131\ub420 \ub54c, \uc778\uc2a4\ud134\uc2a4\uac00 \uc2dc\uc791\uc2dc\uc5d0 \uba85\uc2dc\ub41c \ud06c\uae30\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc84\ud37c \ub4e4\uc774 \ub9cc\ub4e4\uc5b4 \uc9d1\ub2c8\ub2e4. \uc774 \ubc84\ud37c\ub4e4\uc740 \uc778\uc2a4\ud134\uc2a4\uac00 \ub0a8\uc544 \uc788\ub294 \ud55c \uacc4\uc18d \uc874\uc7ac\ud569\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c(redo log buffer) <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">SGA\uc758 \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uac00\ud574\uc9c4 \ubcc0\ud654\ub97c \uae30\ub85d\ud558\ub294 \ubcc0\uacbd \ud56d\ubaa9\uc744 \uc800\uc7a5 \ud569\ub2c8\ub2e4. \ub9ac\ub450 \ub85c\uadf8 \ubc84\ud37c\uc5d0 \uc800\uc7a5\ub41c \ub9ac\ub450 \ud56d\ubaa9\ub4e4\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubcf5\uad6c\uc5d0 \uc0ac\uc6a9\ub418\ub294 \uc628\ub77c\uc778 \ub9ac\ub450 \ub85c\uadf8 \ud30c\uc77c\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">\uacf5\uc720 \ud480(shared pool) <\/SPAN><\/P><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uacf5\uc720 \ud480\uc740 \uacf5\uc720 SQL \uc601\uc5ed\uacfc \uac19\uc740 \uacf5\uc720 \uba54\ubaa8\ub9ac \uad6c\uc870\ub97c \ud3ec\ud568\ud558\ub294 SGA\uc5d0 \uc788\ub294 \ud55c \uad6c\uc5ed\uc73c\ub85c, library cache, dictionary cache, result cache \ub4f1\uc744 \ud3ec\ud568\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><SPAN style=\"COLOR: black\">\uc774 \uc911 library cache\ub294 shared SQL area, private SQL area, PL\/SQL procedure\uc640 package\ub4e4, lock \ub4f1\uacfc \uac19\uc740 \uc81c\uc5b4 \uad6c\uc870 \ub4e4\ub85c \ub098\ub258\uc5b4 \uc9c0\ub294\ub370, \uc774 \uc911 shared SQL area\ub294 \ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ud589\ud574\uc9c0\ub294 \ubaa8\ub4e0 SQL \ubb38\uc744 \ucc98\ub9ac\ud558\uae30 \uc704\ud558\uc5ec \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc774 \uc601\uc5ed\uc5d0\ub294 SQL \ubb38\uc7a5\uc744 \uc2e4\ud589\ud558\uae30 \uc704\ud574 \uadf8 \ubb38\uc7a5\uacfc \uad00\ub828\ub41c \uc2e4\ud589 \uacc4\ud68d\uacfc \uad6c\ubb38\ubd84\uc11d \uc815\ubcf4\uac00 \ub4e4\uc5b4 \uc788\uace0, \ub2e4\uc218\uc758 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \uc758\ud574 \uc7ac\uc0ac\uc6a9\ub429\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">Result cache\ub294 SQL\uc758 query \uacb0\uacfc\ub098 PL\/SQL function\uc758 \uacb0\uacfc\ub97c caching\uc2dc\ud0ac \uc218 \uc788\ub294 \uc601\uc5ed\uc73c\ub85c, database buffer cache\uac00 \ubb3c\ub9ac\uc801\uc778 \ub370\uc774\ud130 \ube14\ub85d \uc790\uccb4\ub97c cache\uc2dc\ud0a4\ub294 \uac83\uacfc \ucc28\uc774\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc774\ub97c \ud65c\uc6a9\ud558\ub294 \uacbd\uc6b0, \uc6d4\ub4f1\ud55c SQL \uc131\ub2a5 \ud5a5\uc0c1\uc744 \uaf80\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">Large Pool <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">Larger pool\uc740 \uc120\ud0dd\uc801\uc778 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc73c\ub85c, shared server\ub098 XA interface\ub97c \uc704\ud55c \uc138\uc158 \uba54\ubaa8\ub9ac \uc601\uc5ed, I\/O \uc11c\ubc84 \ud504\ub85c\uc138\uc2a4, \ubc31\uc5c5\uc774\ub098 restore \uc624\ud37c\ub808\uc774\uc158\uc744 \uc704\ud574 \uc0ac\uc6a9\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">Java Pool <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">JVM \ub0b4\uc758 \uc790\ubc14 \ucf54\ub4dc\ub098 \ub370\uc774\ud130\ub97c \uc704\ud55c \uc11c\ubc84 \uba54\ubaa8\ub9ac\ub85c \uc0ac\uc6a9\ub420 \uc218 \uc788\ub294 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc785\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P>&nbsp; &nbsp;<\/P><br \/>\n<P><SPAN style=\"FONT-SIZE: 14pt; FONT-FAMILY: HY\ud5e4\ub4dc\ub77c\uc778M; COLOR: black\">Streams Pool <\/SPAN><\/P><\/LI><br \/>\n<LI><br \/>\n<DIV><SPAN style=\"COLOR: black\">Oracle Streams\uc5d0 \uc758\ud574\uc11c\ub9cc \uc0ac\uc6a9\ub418\ub294 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc73c\ub85c, buffered queue \uba54\uc2dc\uc9c0\ub97c \uc800\uc7a5\ud558\uba70, \uc774\ub294 Oracle Streams\uc758 \ucea1\uccd0 \ud504\ub85c\uc138\uc2a4\uc640 \uc801\uc6a9(apply) \ud504\ub85c\uc138\uc2a4\uc5d0 \uc758\ud574 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<SPAN style=\"FONT-SIZE: 10pt; FONT-FAMILY: \ub9d1\uc740 \uace0\ub515\"> <\/SPAN><\/SPAN><\/DIV><br \/>\n<P><SPAN style=\"COLOR: black\">&nbsp;<SPAN style=\"FONT-SIZE: 12pt; FONT-FAMILY: \uad74\ub9bc\"> <\/SPAN><\/SPAN>&nbsp;<\/P><\/LI><\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SGA SGA\ub294 \ud55c \uc624\ub77c\ud074\uc758 \uc778\uc2a4\ud134\uc2a4\uc5d0 \ub300\ud55c \ub370\uc774\ud130\uc640 \uc81c\uc5b4 \uc815\ubcf4\ub97c \uac00\uc9c0\ub294 \uacf5\uc720 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc785\ub2c8\ub2e4. SGA\uc640 \uc624\ub77c\ud074 \ubc31\uadf8\ub77c\uc6b4\ub4dc \ud504\ub85c\uc138\uc2a4\uac00 \uc624\ub77c\ud074 \uc778\uc2a4\ud134\uc2a4\ub97c \uad6c\ucd95\ud569\ub2c8\ub2e4. \uc624\ub77c\ud074 \uc778\uc2a4\ud134\uc2a4\uac00 \uc2dc\uc791\ub420 \ub54c SGA\ub97c \ud560\ub2f9\ud558\uace0 \uc778\uc2a4\ud134\uc2a4\uac00 \uc885\ub8cc\ud558\uba74 \ud560\ub2f9\uc744 \ud574\uc81c\ud569\ub2c8\ub2e4. \uac01 \uc778\uc2a4\ud134\uc2a4\ub294 \uace0\uc720 SGA\ub97c \uac00\uc9d1\ub2c8\ub2e4. \uc624\ub77c\ud074 \uc11c\ubc84\ub97c \ub3d9\uc2dc\uc5d0 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \uc0ac\uc6a9\uc790\ub294 SGA\uc758 \ub370\uc774\ud130\ub97c \uacf5\uc720\ud569\ub2c8\ub2e4. \uc804\uccb4 SGA\ub97c \uc2e4\uc81c \uba54\ubaa8\ub9ac \ud06c\uae30\uac00 \ud5c8\uc6a9\ud558\ub294 \ubc94\uc704\uc5d0\uc11c \uac00\uc7a5 \ud06c\uac8c \uc7a1\uc73c\uba74 \ub514\uc2a4\ud06c [&hellip;]<\/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":[300],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1154"}],"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=1154"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1154\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1154"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}