{"id":4550,"date":"2021-11-03T22:44:10","date_gmt":"2021-11-03T13:44:10","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4550"},"modified":"2021-11-03T22:44:10","modified_gmt":"2021-11-03T13:44:10","slug":"%ec%98%a4%eb%9d%bc%ed%81%b4-12c-%ea%b6%8c%ec%9e%a5-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4550","title":{"rendered":"\uc624\ub77c\ud074 12C \uad8c\uc7a5 \ud30c\ub77c\ubbf8\ud130"},"content":{"rendered":"
\uc624\ub77c\ud074 12C \ud30c\ub77c\ubbf8\ud130(\uad8c\uace0)<\/span><\/div>\n
———————————————-<\/span><\/div>\n
<\/div>\n
[ Oracle Database Enterprise Edition 12c \uae30\uc900 ]<\/span><\/div>\n
<\/div>\n
– \ud30c\ub77c\uba54\ud0c0\uc5d0 (\uad04\ud638) \uc548\uc758 \uac12\uc740 \uc6d0\ub798 \uc548\uac74\ub4dc\ub9ac\uba74 Default\ub85c \uac00\uc9c0\uace0 \uc788\ub294 \uac12\uc785\ub2c8\ub2e4.<\/span><\/div>\n
<\/div>\n
_add_col_optim_enabled (true) => false<\/span><\/div>\n
- column add \uc2dc dictionary\ub9cc update \ud558\uace0 \uc774\ud6c4 insert\uc2dc \ud574\ub2f9 \uceec\ub7fc\uc774 \uc0dd\uc131\ub418\uac8c \ud558\ub294 \uae30\ub2a5<\/code><\/span><\/div>\n
– Wrong result \ubc84\uadf8\ub85c \uc778\ud574 false \uad8c\uace0 (MOS \ubb38\uc11c #1492674.1, #19183343.\"\ud83d\ude0e\"<\/span>\u00a0<\/span><\/div>\n
<\/div>\n
<\/div>\n
_<\/span>gc_policy_time (10) => 0 _gc_undo_affinity (true) => false<\/span><\/div>\n
- RAC DRM Remastering \uae30\ub2a5\uc744 \ub044\ub294\uac8c \uc88b\uc74c. Remastering \uc5d0 \ub530\ub978 \uc624\ubc84\ud5e4\ub4dc\uac00 \ub108\ubb34 \ud06c\ub2e4\uace0 \uc54c\ub824\uc838 \uc788\uc74c.<\/code><\/span><\/div>\n
– 1000\ubc88\uc774\uc0c1 \ub2e4\ub978\ucabd \ub178\ub4dc\uc5d0\uc11c Writing\uc774 \ubc1c\uc0dd\ud558\uba74 Mastering \uc815\ubcf4\ub97c \uc62e\uae30\ub294 Remastering\uc774 \ubc1c\uc0dd\ud558\ub294\ub370 \uc774\ub54c \ubaa8\ub4e0 gc request \uac00 \uc911\ub2e8\ub418\uae30 \ub54c\ubb38\uc5d0 \ub290\ub824\uc9c0\ub294 \ud604\uc0c1\uc774 \ubc1c\uc0dd\ub428. <\/span><\/div>\n
<\/div>\n
<\/div>\n
_<\/span>optimizer_use_feedback (true) => false<\/span><\/div>\n
- 11gR2 NF \ud30c\ub77c\uba54\ud0c0<\/code><\/span><\/div>\n
– Optimizer\uac00 \uc815\ud655\ud55c cardinality\ub97c \uacc4\uc0b0\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0 \uc0c8\ub85c\uc6b4 \uc2e4\ud589\uacc4\ud68d\uc744 \uc218\ub9bd\ud558\ub294 \uae30\ub2a5 – \uac11\uc791\uc2a4\ub7f0 plan \ubcc0\uacbd \ubc0f \uc798\ubabb\ub41c \uc2e4\ud589\uacc4\ud68d\uc218\ub9bd\uc73c\ub85c \uc778\ud574 false \uad8c\uace0 <\/span><\/div>\n
\u00a0 \u00a0(MOS \ubb38\uc11c \ucc38\uc870 #8521689.8, #13648166.8, #13454409.\"\ud83d\ude0e\"<\/span>\u00a0<\/span><\/div>\n
<\/div>\n
<\/div>\n
deferred_segment_creation (true) => false<\/span><\/div>\n
- Create table \uc218\ud589\uc2dc \uc989\uc2dc\ub85c table\uc744 \uc0dd\uc131\ud560 \uc9c0\ub97c \uacb0\uc815<\/code><\/span><\/div>\n
– true(default)\ub85c \uc124\uc815\uc2dc library cache: mutex X, exp\/imp\uc5d0 \ud3ec\ud568\ub418\uc9c0 \uc54a\ub294 \ubb38\uc81c, ora-600\uc73c\ub85c \uc778\ud574 false \uad8c\uace0 (#1352678.1 , #1590806.1, #1352678.1) <\/span><\/div>\n
– \uc8fc\uc758 : false \uc124\uc815 \uc774\uc804\uc5d0 \ub9cc\ub4e0 table\uc740 parameter\ubcc0\uacbd\uc5d0\ub3c4 \uc601\ud5a5\uc744 \ubc1b\uc9c0 \uc54a\uc73c\ubbc0\ub85c <\/span><\/div>\n
SQL> alter table “\ud14c\uc774\ube14” move <\/span><\/div>\n
\ub610\ub294 <\/span><\/div>\n
SQL> alter table “\ud14c\uc774\ube14” allocate extent; \ub97c \uc218\ud589\ud574\uc57c \ud568. (#1178343.1) <\/span><\/div>\n
<\/div>\n
<\/div>\n
optimizer_adaptive_features (true) => false (12cR1 only)<\/span><\/div>\n
- 12cR1 NF \ud30c\ub77c\uba54\ud0c0<\/code><\/span><\/div>\n
– 12cR2 \uc758 \uacbd\uc6b0, optimizer_adaptive_plans \ud30c\ub77c\uba54\ud0c0\ub85c \uc81c\uc5b4\ud574\uc57c \ud568. (12cR2\uc5d0\uc11c optimizer_adaptive_features \ub294 \uc5c6\uc5b4\uc84c\uc74c) <\/span><\/div>\n
– Plan \uc774 \ub9e4\ubc88 \ubc14\ub014 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 false \ub85c \uad8c\uace0.. \ud558\uc9c0\ub9cc, \uc774 \uae30\ub2a5\uc774 \uc6d0\ub798 \ub9e4\uc6b0 \uad1c\ucc2e\uc740 \uae30\ub2a5\uc774\ub77c.. \uc774 \uc88b\uc740 New Feature\ub97c \uaebc\ubc84\ub9ac\ub294\uac8c \ub9de\uc744\uc9c0\ub294 \uc880 \ub17c\ub780\uc758 \uc5ec\uc9c0\uac00 \uc788\uc74c. <\/span><\/div>\n
<\/div>\n
<\/div>\n
optimizer_adaptive_plans (true) => false (12cR2 ~)<\/span><\/div>\n
- 12cR2 NF \ud30c\ub77c\uba54\ud0c0<\/code><\/span><\/div>\n
– 12cR1 \uc758 \uacbd\uc6b0, optimizer_adaptive_features \ud30c\ub77c\uba54\ud0c0\ub97c \uc0ac\uc6a9\ud568.<\/span><\/div>\n
( optimizer_adaptive_features = optimizer_adaptive_plans + optimizer_adaptive_statistics )<\/code><\/span><\/div>\n
– Plan \uc774 \ub9e4\ubc88 \ubc14\ub014 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 false \ub85c \uad8c\uace0.. \ud558\uc9c0\ub9cc, \uc774 \uae30\ub2a5\uc774 \uc6d0\ub798 \ub9e4\uc6b0 \uad1c\ucc2e\uc740 \uae30\ub2a5\uc774\ub77c.. \uc774 \uc88b\uc740 New Feature\ub97c \uaebc\ubc84\ub9ac\ub294\uac8c \ub9de\uc744\uc9c0\ub294 \uc880 \ub17c\ub780\uc758 \uc5ec\uc9c0\uac00 \uc788\uc74c. <\/span><\/div>\n
<\/div>\n
<\/div>\n
parallel_adaptive_multi_user (true) => false<\/span><\/div>\n
- \uc694\uccad\ub41c parallel degree \uc5d0 \ub300\ud574\uc11c query startup time \uc2dc\uc758 system load \uc5d0 \uadfc\uac70\ud574\uc11c degree \ub97c \ucd95\uc18c\ud558\ub294 \uae30\ub2a5.<\/code><\/span><\/div>\n
– \ubb38\uc81c\ub294 \uc774 \ud30c\ub77c\uba54\ud0c0\ub85c \uc778\ud574 parallel \ud504\ub85c\uc138\uc2a4\uac00 \uc758\ub3c4\ud55c\ub300\ub85c \ucda9\ubd84\ud788 \uc548\ub728\uae30 \ub54c\ubb38\uc5d0 false \ub85c \uad8c\uace0. <\/span><\/div>\n
– DOP \ub97c \uc758\ub3c4\ud55c\ub300\ub85c \uc720\uc9c0\ud558\uba74\uc11c \uc218\ud589\ub418\uc5b4\uc57c \ud560 Batch Job \ub4f1\uc744 \uc6b4\uc601\ud558\ub294 \uc2dc\uc2a4\ud15c\uc758 \uacbd\uc6b0 System Resource\uac00 \uc5ec\uc720\uac00 \uc788\ub2e4\uba74 False\ub85c \uc6b4\uc601\ud560 \uac83\uc744 \uad8c\uc7a5\ud568.<\/span><\/div>\n
<\/div>\n
<\/div>\n
parallel_force_local (false) => true<\/span><\/div>\n
- RAC\uc5d0\uc11c \uc778\uc2a4\ud134\uc2a4\uac04\uc5d0 parallel \ucc98\ub9ac\ub97c \ud5c8\uc6a9\ud560\uc9c0 \uc5ec\ubd80. \uacfc\ub3c4\ud55c \uce90\uc2dc\ud4e8\uc804\uc5d0 \uc758\ud55c \uc131\ub2a5\uc800\ud558 \ubc29\uc9c0.<\/code><\/span><\/div>\n
– \ub610\ud55c, \ubbf8\ud574\uacb0\ub41c \ubc84\uadf8 (#1914119.1)\ub85c \uc778\ud574 false \uad8c\uace0. <\/span><\/div>\n
<\/div>\n
<\/div>\n
shared_pool_size => <\uc801\uc808\ud55c \uac12><\/span><\/div>\n
- sga_target, memory_target \ub4f1\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc790\ub3d9\uc73c\ub85c Oracle Memory(SGA)\ub97c \uc870\uc815\ud558\uae30 \ub54c\ubb38\uc5d0 \uc774 \ud30c\ub77c\uba54\ud0c0\ub97c \uc138\ud305\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\uac00 \uc788\ub294\ub370, \uadf8\ub798\ub3c4 \uc138\ud305\ud558\ub294\uac8c \uc88b\uc2b5\ub2c8\ub2e4.<\/code><\/span><\/div>\n
– \ucd08\uae30 shared pool \uc758 \ud06c\uae30\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. (\ub514\ud3f4\ud2b8\ub294 0) <\/span><\/div>\n
– memory_target \uc774\ub098 sga_target \uc744 \uc9c0\uc815\ud588\ub354\ub77c\ub3c4 \uc774 \ud30c\ub77c\uba54\ud0c0\ub97c \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \ucd5c\uc18c shared pool\uc744 \ud655\ubcf4\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub354 \uc548\uc815\uc801\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc90d\ub2c8\ub2e4. <\/span><\/div>\n
– \uc774 \ud30c\ub77c\uba54\ud0c0\ub97c \uc138\ud305\ud588\ub2e4\uace0 \ud574\uc11c sga_target \uc744 \uc5c6\uc560\ubc84\ub9b4 \ud544\uc694\ub294 \uc5c6\uc74c. \ud568\uaed8 \uc9c0\uc815. <\/span><\/div>\n
<\/div>\n
<\/div>\n
large_pool_size => <\uc801\uc808\ud55c \uac12><\/span><\/div>\n
- \uc704 shared_pool_size \uc640 \ub9c8\ucc2c\uac00\uc9c0 \uacbd\uc6b0\uc785\ub2c8\ub2e4.<\/code><\/span><\/div>\n
– \ucd08\uae30 large pool \uc758 \ud06c\uae30\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. <\/span><\/div>\n
– memory_target \uc774\ub098 sga_target \uc744 \uc9c0\uc815\ud588\ub354\ub77c\ub3c4 \uc774 \ud30c\ub77c\uba54\ud0c0\ub97c \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \ucd5c\uc18c large pool\uc744 \ud655\ubcf4\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub354 \uc548\uc815\uc801\uc73c\ub85c \ub9cc\ub4e4\uc5b4\uc90d\ub2c8\ub2e4. <\/span><\/div>\n
– large pool\uc740 MTS \ub610\ub294 \ubcd1\ub82c\ucc98\ub9ac\uc2dc\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. (\ubcd1\ub82c\ucc98\ub9ac\uac00 \ub9ce\uc740 \uacbd\uc6b0 2GB \uc815\ub3c4\ub85c \uc124\uc815) <\/span><\/div>\n
<\/div>\n
<\/div>\n
streams_pool_size => 200M \uc774\uc0c1<\/span><\/div>\n
- Streams \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub354\ub77c\ub3c4 Datapump \uc0ac\uc6a9\uc2dc error \ubc0f \uc131\ub2a5\uc800\ud558\uc5d0 \ub300\ube44\ud574 200M\uc774\uc0c1 \uc124\uc815\uc744 \uad8c\uace0\ud558\uace0 \uc788\uc74c. (MOS \ubb38\uc11c \ucc38\uc870 #1596645.1)<\/code><\/span><\/div>\n
<\/div>\n
<\/div>\n
sga_target, memory_target<\/span><\/div>\n
- sga_target \uc740 shared_pool_size, large_pool_size, db_cache_size \ub4f1\uc744 \uc790\ub3d9\uc73c\ub85c \uc870\uc808\ud574\uc8fc\ub294 10g \uc2e0\uae30\ub2a5\uc785\ub2c8\ub2e4.<\/code><\/span><\/div>\n
– memory_target \uc740 sga_target \uc758 \uae30\ub2a5 + pga_aggregate_target \uac12\uae4c\uc9c0 \uc790\ub3d9\uc73c\ub85c \uc870\uc808\ud574\uc8fc\ub294 11g \uc2e0\uae30\ub2a5\uc785\ub2c8\ub2e4. <\/span><\/div>\n
– \ud558\uc9c0\ub9cc, \uc774\ub4e4 \ud30c\ub77c\uba54\ud0c0\uac00 \uba54\ubaa8\ub9ac\uac12\ub4e4\uc744 \uc790\ub3d9\uc73c\ub85c \uc870\uc808\ud558\ub294(resize) \uc21c\uac04\uc5d0 \uc131\ub2a5\uc800\ud558\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub2e4\uace0 \ud558\uc5ec \uc0ac\uc6a9\ud558\uc9c0 \ub9d0\ub77c\ub294 \uc598\uae30\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/div>\n
– \ub610, \uc5b4\ub5a4 \uae00\uc744 \ubcf4\uba74 memory_target \ub9cc \uc124\uc815\ud558\uc9c0 \ub9d0\uace0, sga_target \uc740 \uadf8\ub0e5 \uc0ac\uc6a9\ud558\ub294 \uac83\uc744 \uad8c\uc7a5\ud558\uae30\ub3c4 \ud558\uace0 \ud574\uc11c \ub17c\ub780\uc758 \uc5ec\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/div>\n
– ASM\uc758 \uacbd\uc6b0, 24G for 2 socket servers (ASM\uc758 \uacbd\uc6b0 \uc18c\ucf13\uc5d0 \ub530\ub77c \uad8c\uace0\ud558\ub294 \uba54\ubaa8\ub9ac \uc0ac\uc774\uc988\uac00 \uc788\uc74c. \uc544\ub9c8 \ub514\ud3f4\ud2b8\uac00 \uc774\uac78\ub85c \ub418\uc5b4 \uc788\uc744\ub4ef…) <\/span><\/div>\n
– DB\uc758 \uacbd\uc6b0\ub294 \ubcf4\ud1b5 sga_target \uc744 \uc801\ub2f9\ud788 \uc7a1\ub294\ub370, \uc804\uccb4 physical memory\uc758 50%\uac00 \uc548\ub118\ub3c4\ub85d \uc138\ud305.<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

\uc624\ub77c\ud074 12C \ud30c\ub77c\ubbf8\ud130(\uad8c\uace0) ———————————————- [ Oracle Database Enterprise Edition 12c \uae30\uc900 ] – \ud30c\ub77c\uba54\ud0c0\uc5d0 (\uad04\ud638) \uc548\uc758 \uac12\uc740 \uc6d0\ub798 \uc548\uac74\ub4dc\ub9ac\uba74 Default\ub85c \uac00\uc9c0\uace0 \uc788\ub294 \uac12\uc785\ub2c8\ub2e4. _add_col_optim_enabled (true) => false – column add \uc2dc dictionary\ub9cc update \ud558\uace0 \uc774\ud6c4 insert\uc2dc \ud574\ub2f9 \uceec\ub7fc\uc774 \uc0dd\uc131\ub418\uac8c \ud558\ub294 \uae30\ub2a5 – Wrong result \ubc84\uadf8\ub85c \uc778\ud574 false \uad8c\uace0 (MOS \ubb38\uc11c #1492674.1, #19183343.\u00a0 _gc_policy_time (10) => […]<\/p>\n","protected":false},"author":1,"featured_media":3408,"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":[20],"tags":[74,1180,1181,969],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/know-howreportajefinal.jpg?fit=471%2C172","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4550"}],"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=4550"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4550\/revisions"}],"predecessor-version":[{"id":4551,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4550\/revisions\/4551"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/3408"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4550"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}