{"id":354,"date":"2015-04-06T10:25:37","date_gmt":"2015-04-06T10:25:37","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=354"},"modified":"2015-04-06T10:25:37","modified_gmt":"2015-04-06T10:25:37","slug":"asmm-amm-%eb%a9%94%eb%aa%a8%eb%a6%ac-%ea%b4%80%eb%a6%ac%ea%b8%b0%eb%b2%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=354","title":{"rendered":"ASMM, AMM \uba54\ubaa8\ub9ac \uad00\ub9ac\uae30\ubc95"},"content":{"rendered":"

ASMM, AMM \uba54\ubaa8\ub9ac \uad00\ub9ac\uae30\ubc95
\n<\/span><\/p>\n

\u00a0
\n\u00a0<\/p>\n

    \n
  1. ASMM(Automatic Shared Memory Management)
    \n<\/span><\/li>\n<\/ol>\n
      \n
    • \n
      9i \uae4c\uc9c0\ub294 SGA \uad6c\uc131\uc694\uc18c\uc778 shared_pool, large pool, DB Buffer Cache \ub4f1\uc5d0 \ub300\ud574\uc11c DBA\uac00 \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud558\ub2e4\uac00 \uc218\ub3d9\uc73c\ub85c \ud06c\uae30\ub97c \ub298\ub824\uc8fc\uace4 \ud558\uc600\uc2b5\ub2c8\ub2e4. (\uc608 : alter system set shared_pool_size=40M scope spfile; )
      \n<\/span><\/div>\n

      \u00a0
      \n\u00a0<\/p>\n<\/li>\n

    • \n
      10g\uc5d0\uc11c \ub4f1\uc7a5\ud55c ASMM\uc740 \uc774\ub7ec\ud55c \uc0ac\ud56d\uc744 \ud574\uc18c\uc2dc\ud0a4\uae30 \uc704\ud574 \ub4f1\uc7a5\ud558\uc600\uace0 SGA\uad6c\uc131 \uc694\uc18c \uc911 Shared pool, DB buffer cache, Large pool, Java pool, Streams Pool \uc8fc\uc694\uad6c\uc131\uc694\uc18c\uc5d0 \uad00\ud558\uc5ec Oracle\uc774 \uc2a4\uc2a4\ub85c \ud604\uc7ac \ubd80\ud558\uc0c1\ud669\uc744 \ud310\ub2e8\ud558\uc5ec \uba54\ubaa8\ub9ac\ub97c \uad00\ub9ac\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc744 \ub0b4\ub193\uc558\uc2b5\ub2c8\ub2e4.
      \n<\/span><\/div>\n

      \u00a0
      \n\u00a0<\/p>\n<\/li>\n

    • \uc5ec\uae30\uc5d0\uc11c Oracle \uc2a4\uc2a4\ub85c \ubd80\ud558\uc0c1\ud669\uc744 \uccb4\ud06c\ud558\uae30 \uc704\ud574 \ub098\uc628\uac83\uc774 MMAN \ud504\ub85c\uc138\uc2a4 \uc785\ub2c8\ub2e4. MMAN \ud504\ub85c\uc138\uc2a4\ub294 5\ubd84 \ub9c8\ub2e4 \uc8fc\uae30\uc801\uc73c\ub85c \uc218\uc9d1\ud55c \uc791\uc5c5\ubd80\ud558(Workload) \uc815\ubcf4\ub97c \ubc14\ud0d5\uc73c\ub85c \ub3d9\uc801\uc73c\ub85c \uad6c\uc131 \ub418\uba70, \uba54\ubaa8\ub9ac\ub294 \ud544\uc694\ud55c \uacf3\uc73c\ub85c \ub3d9\uc801\uc73c\ub85c \ud560\ub2f9\uc774 \ub418\uac8c \ub429\ub2c8\ub2e4.
      \n<\/span><\/li>\n<\/ul>\n

      \u00a0
      \n\u00a0<\/p>\n

        \n
      • \n
        ASMM\uc744 \uc0ac\uc6a9\ud558\uae30 \uc704\ud55c \uc870\uac74\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.
        \n<\/span><\/div>\n
          \n
        • STATISTICS_LEVEL Parameter \uac12\uc774 typical \ub610\ub294 ALL \ub85c \uc124\uc815
          \n<\/span><\/li>\n
        • SGA_TARGET Parameter \uac12\uc744 0 \ubcf4\ub2e4 \ud070 \uac12\uc73c\ub85c \uc124\uc815(0\uc740 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc74c\uc744 \uc758\ubbf8)
          \n<\/span><\/li>\n
        • SGA_MAX_SIZE : ASMM\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ucd5c\ub300\uac12\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4. SGA_TARGET : \uc774 \uac12\uc5d0\uc11c ASMM\uc774 \uc774\ub8e8\uc5b4\uc9c0\uac8c \ub429\ub2c8\ub2e4. SGA_MAX_SIZE\uc640 SGA_TARGET\uc740 \ub3d9\uc77c\ud55c \uac12\uc73c\ub85c \uc124\uc815\ud558\uae38 \uad8c\uc7a5\ud569\ub2c8\ub2e4.
          \n<\/span><\/li>\n
        • \uc704\uc5d0\uc11c \uc124\uba85\ud55c SGA \uad6c\uc131\uc694\uc18c\ub4e4\uc758 \uac12\uc740 0\uc73c\ub85c \uc124\uc815(0 \uc774\uc0c1\uc758 \uac12\uc774 \uc124\uc815\ub418\uc5b4 \uc788\ub2e4\uba74 \uadf8 \uac12\uc744 \ucd5c\uc18c\uac12\uc73c\ub85c \uc778\uc2dd\ud558\uae30 \ub54c\ubb38\uc5d0 0\uc73c\ub85c \uc124\uc815\ud558\uae30\ub97c \uad8c\uc7a5)
          \n<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

          \u00a0
          \n\u00a0<\/p>\n

            \n
          • \n
            ASMM \uc124\uc815\ud558\uae30(DB shutdown\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.)
            \n<\/span><\/div>\n
              \n
            • \n
              alter system set sga_max_size=10240m scope=spfile;
              \n<\/span><\/div>\n

              alter system set sga_target=10240m scope=spfile;
              \n<\/span><\/p>\n

              \u00a0
              \n\u00a0<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                \n
              1. \n
                alter system checkpoint; 3\ud68c \uc2e4\uc2dc
                \n<\/span><\/div>\n

                shutdown immediate;
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n<\/li>\n

              2. \n
                startup;
                \n<\/span><\/div>\n

                \u00a0
                \n\u00a0<\/p>\n<\/li>\n

              3. \n
                \uc544\ub798 \ud574\ub2f9 \ubcc0\uacbd\ub41c \ub0b4\uc6a9\uc744 \uc870\ud68c \ud569\ub2c8\ub2e4.
                \n<\/span><\/div>\n

                show parameter sga_max_size
                \n<\/span><\/p>\n

                show parameter sga_target
                \n<\/span><\/p>\n

                \u00a0
                \n\u00a0<\/p>\n<\/li>\n<\/ol>\n

                  \n
                • \n
                  ASMM\uc73c\ub85c \uad00\ub9ac\ub418\ub294 SGA \uad6c\uc131\uc694\uc18c\uc5d0 \ub300\ud558\uc5ec \uc544\ub798 \ucffc\ub9ac\ub97c \uc774\uc6a9\ud558\uc5ec \uad00\ucc30\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                  \n<\/span><\/div>\n

                  select component, current_size\/1024\/1024 curr_MB, min_size\/1024\/1024 min_MB,
                  \n<\/span><\/p>\n

                  user_specified_size\/1024\/1024 user_MB
                  \n<\/span><\/p>\n

                  from v$sga_dynamic_components;
                  \n<\/span><\/p>\n

                  \u00a0
                  \n\u00a0<\/p>\n

                  \u00a0
                  \n\u00a0<\/p>\n<\/li>\n<\/ul>\n

                    \n
                  1. AMM(Auto Memory Management)
                    \n<\/span><\/li>\n<\/ol>\n
                      \n
                    • Oracle\uc740 9i\ubd80\ud130\ub294 PGA\ub97c WORKAREA_SIZE_POLICY, PGA_AGGREGATE_TARGET \ub4f1\uc758 Parameter\ub97c \uc774\uc6a9\ud558\uc5ec \uc790\ub3d9\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \ubc29\uc2dd\uc744 \uc368 \uc654\uc2b5\ub2c8\ub2e4.
                      \n<\/span><\/li>\n<\/ul>\n

                      \u00a0
                      \n\u00a0<\/p>\n

                        \n
                      • 10g\uc5d0\uc11c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\ub85c SGA\ub294 ASMM\ubc29\uc2dd + PGA\ub294 WORKAREA_SIZE_POLICY, PGA_AGGREGATE_TARGET \uc744 \uc774\uc6a9\ud558\uc5ec \uad00\ub9ac\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.
                        \n<\/span><\/li>\n<\/ul>\n

                        \u00a0
                        \n\u00a0<\/p>\n

                          \n
                        • 11g\uc5d0\uc11c \ub4f1\uc7a5\ud55c AMM \uad00\ub9ac \uae30\ubc95\uc740 SGA+PGA\ub97c \uc790\ub3d9\uc73c\ub85c \uad00\ub9ac\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ubc1c\uc804\ud558\uac8c \ub429\ub2c8\ub2e4.
                          \n<\/span><\/li>\n<\/ul>\n

                          \u00a0
                          \n\u00a0<\/p>\n

                            \n
                          • \n
                            AMM \uad00\ub9ac \uae30\ubc95\uc774 \ub4f1\uc7a5\ud558\uba74\uc11c \uc544\ub798 2\uac00\uc9c0 Parameter\uac00 \uc0dd\uacbc\uc2b5\ub2c8\ub2e4.
                            \n<\/span><\/div>\n
                              \n
                            • \n
                              MEMORY_TARGET : AMM \uae30\ub2a5 \uc0ac\uc6a9\uc2dc \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 Memory\uc758 \ucd1d \ub7c9\uc744 \uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                              \n<\/span><\/div>\n

                              \uc774 Parameter\uac00 0\uc774\uba74 AMM\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4\ub294 \ub73b\uc774\uba70, \ucd5c\ub300 \uc124\uc815 \uac12\uc740 MEMORY_MAX_TARGET\uc758 \uac12 \uae4c\uc9c0 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                              \n<\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                \n
                              1. MEMORY_MAX_TARGET : MEMORY_TARGET \uac12\uc774 \ucd5c\ub300\ub85c \uc99d\uac00\ub420 \uac12\uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4.
                                \n<\/span><\/li>\n<\/ol>\n

                                \u00a0
                                \n\u00a0<\/p>\n

                                  \n
                                • \n
                                  AMM \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uac8c \ub41c\ub2e4\uba74 SGA_TARGET, PGA_AGGREGATE_TARGET\uc758 \uac12\uc744 0\uc73c\ub85c \uc9c0\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.
                                  \n<\/span><\/div>\n

                                  ASMM\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c 0\uc774 \uc544\ub2cc \uacbd\uc6b0 \uadf8 \uac12\uc744 \ucd5c\uc18c\uac12\uc73c\ub85c \uc778\uc2dd\ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.
                                  \n<\/span><\/p>\n

                                  \u00a0
                                  \n\u00a0<\/p>\n<\/li>\n

                                • \n
                                  AMM \ubc29\uc2dd \uc124\uc815\ud558\uae30(DB shutdown\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.)
                                  \n<\/span><\/div>\n
                                    \n
                                  • \n
                                    alter system set memory_max_target=3G scope=spfile ;
                                    \n<\/span><\/div>\n

                                    alter system set memory_target=3G scope=spfile ;
                                    \n<\/span><\/p>\n

                                    \u00a0
                                    \n\u00a0<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                                      \n
                                    1. \n
                                      alter system checkpoint; 3\ud68c \uc2e4\uc2dc
                                      \n<\/span><\/div>\n

                                      shutdown immediate;
                                      \n<\/span><\/p>\n

                                      \u00a0
                                      \n\u00a0<\/p>\n<\/li>\n

                                    2. \n
                                      startup;
                                      \n<\/span><\/div>\n

                                      \u00a0
                                      \n\u00a0<\/p>\n<\/li>\n

                                    3. \n
                                      \uc544\ub798 \ud574\ub2f9 \ubcc0\uacbd\ub41c \ub0b4\uc6a9\uc744 \uc870\ud68c \ud569\ub2c8\ub2e4.
                                      \n<\/span><\/div>\n

                                      show parameter memory_max_target
                                      \n<\/span><\/p>\n

                                      show parameter memory_target
                                      \n<\/span><\/p>\n

                                      \u00a0<\/span>\u00a0<\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

                                      ASMM, AMM \uba54\ubaa8\ub9ac \uad00\ub9ac\uae30\ubc95 \u00a0 \u00a0 ASMM(Automatic Shared Memory Management) 9i \uae4c\uc9c0\ub294 SGA \uad6c\uc131\uc694\uc18c\uc778 shared_pool, large pool, DB Buffer Cache \ub4f1\uc5d0 \ub300\ud574\uc11c DBA\uac00 \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud558\ub2e4\uac00 \uc218\ub3d9\uc73c\ub85c \ud06c\uae30\ub97c \ub298\ub824\uc8fc\uace4 \ud558\uc600\uc2b5\ub2c8\ub2e4. (\uc608 : alter system set shared_pool_size=40M scope spfile; ) \u00a0 \u00a0 10g\uc5d0\uc11c \ub4f1\uc7a5\ud55c ASMM\uc740 \uc774\ub7ec\ud55c \uc0ac\ud56d\uc744 \ud574\uc18c\uc2dc\ud0a4\uae30 \uc704\ud574 \ub4f1\uc7a5\ud558\uc600\uace0 SGA\uad6c\uc131 \uc694\uc18c \uc911 Shared pool, DB buffer […]<\/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":[21],"tags":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/354"}],"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=354"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/354\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=354"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}