{"id":687,"date":"2015-11-23T02:15:34","date_gmt":"2015-11-23T02:15:34","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=687"},"modified":"2015-11-23T02:15:34","modified_gmt":"2015-11-23T02:15:34","slug":"oracle-%ea%b6%8c%ec%9e%a5-%ed%8c%8c%eb%9d%bc%eb%af%b8%ed%84%b011204","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=687","title":{"rendered":"Oracle \uad8c\uc7a5 \ud30c\ub77c\ubbf8\ud130(11.2.0.4)"},"content":{"rendered":"<p>DB Parameter\uc758 \uc124\uc815\uc5d0 \ub300\ud55c Best Practices\ub294 \uc624\ub77c\ud074\uc5d0\uc11c \uac00\uc774\ub4dc\ub97c \ubc14\ud0d5\uc73c\ub85c \ud558\uc5ec \uace0\uac1d\uc0ac\uc758 DBMS \uc6b4\uc601 \uacbd\ud5d8\uacfc \uace0\uac1d\uc0ac\uc758 \ud45c\uc900 \ud30c\ub77c\ubbf8\ud130\ub97c \ubc18\uc601\ud558\uc5ec \uace0\uac1d\uc0ac \uace0\uc720\uc758 DB Parameter\ub97c \ub9cc\ub4e4\uc5b4 \uac00\ub294 \uac83\uc774 \uac83\uc785\ub2c8\ub2e4.&nbsp;<\/p>\n<p><\/p>\n<p><b><span style=\"color: rgb(255, 0, 0);\">\uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc740 \uad8c\uace0 DB Parameter \uac12\uc774 \uc544\ub2cc \uac12\uc73c\ub85c \uc124\uc815\uc744 \ubcc0\uacbd\uc744 \ud560 \uacbd\uc6b0\ub294 \uba74\ubc00\ud55c \ud14c\uc2a4\ud2b8\uc640 \uc131\ub2a5 \uac80\uc99d \uc774 \uc120\ud589 \ub418\uc5b4\uc57c \ud55c\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.&nbsp;<\/span><\/b><\/p>\n<p><\/p>\n<p>\uae30\uc874 \ub2e4\ub978 \ud658\uacbd\uc5d0\uc11c \uad00\ub9ac\ud574\uc628 \uace0\uac1d\uc0ac\uc758 \ud45c\uc900 DB Parameter\ub97c&nbsp;\uadf8\ub300\ub85c \uc801\uc6a9\ud588\ub2e4\uac00 \uc608\uc0c1\uce58 \ubabb\ud55c Side Effec(\uc608: \uc131\ub2a5 \uc800\ud558, \uae30\ub2a5 Disable \ub4f1)\uac00 \ubc1c\uc0dd\ub41c \uc0ac\ub840\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><\/p>\n<p>DB \ud30c\ub77c\ubbf8\ud130\ub294 Configuration Management\uc758 \uc77c\ud658\uc73c\ub85c \ud30c\ub77c\ubbf8\ud130\uc758 \ubcc0\uacbd \uc774\ub825 Tracking\uacfc \uc0c1\ud638 \ube44\uad50\uac00 \uac00\ub2a5\ud574\uc57c \ud569\ub2c8\ub2e4.&nbsp;<\/p>\n<p>\uc989, \ubb38\uc81c\uac00 \ubc1c\uc0dd\ud588\uc744 \ub54c, \ubb38\uc81c \ubc1c\uc0dd\uc774\uc804\uc758 Configuration\uacfc \ubb38\uc81c \uc774\ud6c4\uc758 Configuration\uc5d0 \ub300\ud55c \ubcc0\uacbd \uc720\ubb34\uc640 \ube44\uad50 \ubd84\uc11d\uc774 \uc190\uc27d\uac8c \uac00\ub2a5\ud574\uc57c \ud569\ub2c8\ub2e4.&nbsp;<\/p>\n<p>\uadf8\ub9ac\uace0 Configuration\uc5d0 \uc758\ud55c \uc2dc\ud589\ucc29\uc624\ub97c \ucd5c\uc18c\ud654 \ud558\uae30 \uc704\ud574 \ud45c\uc900 \ud30c\ub77c\ubbf8\ud130\ub97c \uad00\ub9ac\ud574 \uc654\ub4ef\uc774 \ud45c\uc900 \ud30c\ub77c\ubbf8\ud130\ub97c \uad00\ub9ac\ud574\uc57c \ud569\ub2c8\ub2e4.&nbsp;<\/p>\n<p>\ub3d9\uc77c\ud55c \ud658\uacbd \uc774\ub354\ub77c\ub3c4 Application(\ub610\ub294 Workload) \uc131\uaca9\uacfc DB \ubc84\uc804\uc5d0 \ub530\ub77c \uc77c\ubd80 DB Parameter\ub4e4\uc740 \ub2e4\ub974\uac8c \uc124\uc815\ub429\ub2c8\ub2e4.<\/p>\n<p><\/p>\n<p>\uc544\ub798\uc758 \ud45c\ub4e4\uc740 \uc624\ub77c\ud074\uc5d0\uc11c \uad8c\uace0\ud558\ub294 ASM \uacfc DBMS \uae30\ubcf8 Parameter\uc785\ub2c8\ub2e4.<\/p>\n<p><b>[ ASM Parameters for 11.2.0.4 ]<\/b><\/p>\n<p style=\"text-align: left; clear: none; float: none;\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile8.uf.24783E3356527509395E8F.jpg?resize=640%2C486\" class=\"aligncenter\" width=\"640\" height=\"486\" filename=\"oracle_asm_reco_param.jpg\" filemime=\"image\/jpeg\" style=\"\"\"\" data-recalc-dims=\"1\" \/><\/p>\n<p><\/p>\n<p><b>[ DBMS Common Parameters for 11.2.0.x ]<\/b><\/p>\n<p style=\"line-height: 0.5;\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile26.uf.26708F37565275AF12A5B2.jpg?resize=640%2C899\" class=\"aligncenter\" width=\"640\" height=\"899\" filename=\"oracle_db_reco_param_1.jpg\" filemime=\"image\/jpeg\" data-recalc-dims=\"1\" \/><\/p>\n<p style=\"line-height: 0.5;\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile6.uf.2565A537565275B01CEDD6.jpg?resize=640%2C647\" class=\"aligncenter\" width=\"640\" height=\"647\" filename=\"oracle_db_reco_param_2.jpg\" filemime=\"image\/jpeg\" data-recalc-dims=\"1\" \/><\/p>\n<p><\/p>\n<p><b>[ OLTP DBMS Parameters for 11.2.0.x ]<\/b><\/p>\n<p style=\"text-align: left; clear: none; float: none;\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile10.uf.222FE94B5652764F21BFF8.jpg?resize=640%2C257\" class=\"aligncenter\" width=\"640\" height=\"257\" filename=\"oracle_db_reco_param_oltp.jpg\" filemime=\"image\/jpeg\" style=\"\"\"\" data-recalc-dims=\"1\" \/><\/p>\n<p><b>\u203b OLTP\ud658\uacbd\uc5d0\uc11c\ub294 \ub9ce\uc740 Query\ub4e4\uc774 Index\ub97c \ud1b5\ud55c \uc791\uc740 I\/O\ub97c \ud558\uae30 \ub54c\ubb38\uc5d0 SGA\ub97c \uc801\uc808\ud788 \ud06c\uac8c \uc124\uc815 \ud569\ub2c8\ub2e4. \ud2b9\ud788 Schema Consolidation\ud658\uacbd\uc774\ub77c\uba74 \ubaa8\ub4e0 \uc5c5\ubb34\uac00 \ud558\ub098\uc758 SGA\uc5d0\uc11c \uc218\ud589\ub418\ubbc0\ub85c \uadf8\uc5d0 \ub530\ub978 \uc801\uc808\ud55c \ud06c\uae30\uc758 SGA\ub97c \uc124\uc815\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/b><\/p>\n<p><\/p>\n<p><b>[ DW\/BI DBMS Parameters for 11.2.0.x ]<\/b><\/p>\n<p style=\"text-align: left; clear: none; float: none;\"><img loading=\"lazy\" src=\"https:\/\/i0.wp.com\/oracledba.zapto.org\/wordpress\/wp-content\/uploads\/1\/cfile24.uf.257A1649565276823211BE.jpg?resize=640%2C339\" class=\"aligncenter\" width=\"640\" height=\"339\" filename=\"oracle_db_reco_param_dw.jpg\" filemime=\"image\/jpeg\" style=\"\"\"\" data-recalc-dims=\"1\" \/><\/p>\n<p><b><br \/><\/b><\/p>\n<p><b>\u203b DW\ud658\uacbd\uc5d0\uc11c\ub294 \ub9ce\uc740 Query\ub4e4\uc774 Smart Scan\uc744 \ud558\uae30 \uc704\ud574 Direct I\/O\ub85c \uc218\ud589\ub418\ub3c4\ub85d \ud29c\ub2dd\ud569\ub2c8\ub2e4. \ub530\ub77c\uc11c SGA\ub97c \ud06c\uac8c \uc124\uc815\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4<\/b><\/p>\n<p><\/p>\n<p><\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB Parameter\uc758 \uc124\uc815\uc5d0 \ub300\ud55c Best Practices\ub294 \uc624\ub77c\ud074\uc5d0\uc11c \uac00\uc774\ub4dc\ub97c \ubc14\ud0d5\uc73c\ub85c \ud558\uc5ec \uace0\uac1d\uc0ac\uc758 DBMS \uc6b4\uc601 \uacbd\ud5d8\uacfc \uace0\uac1d\uc0ac\uc758 \ud45c\uc900 \ud30c\ub77c\ubbf8\ud130\ub97c \ubc18\uc601\ud558\uc5ec \uace0\uac1d\uc0ac \uace0\uc720\uc758 DB Parameter\ub97c \ub9cc\ub4e4\uc5b4 \uac00\ub294 \uac83\uc774 \uac83\uc785\ub2c8\ub2e4.&nbsp; \uc5ec\uae30\uc11c \uc8fc\uc758\ud560 \uc810\uc740 \uad8c\uace0 DB Parameter \uac12\uc774 \uc544\ub2cc \uac12\uc73c\ub85c \uc124\uc815\uc744 \ubcc0\uacbd\uc744 \ud560 \uacbd\uc6b0\ub294 \uba74\ubc00\ud55c \ud14c\uc2a4\ud2b8\uc640 \uc131\ub2a5 \uac80\uc99d \uc774 \uc120\ud589 \ub418\uc5b4\uc57c \ud55c\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4.&nbsp; \uae30\uc874 \ub2e4\ub978 \ud658\uacbd\uc5d0\uc11c \uad00\ub9ac\ud574\uc628 \uace0\uac1d\uc0ac\uc758 \ud45c\uc900 DB [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":688,"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":[372,373,374,375,376],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile6.uf.2565A537565275B01CEDD6.jpg?fit=655%2C662","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/687"}],"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=687"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/687\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/688"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=687"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}