{"id":387,"date":"2015-06-15T04:17:49","date_gmt":"2015-06-15T04:17:49","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=387"},"modified":"2015-06-15T04:17:49","modified_gmt":"2015-06-15T04:17:49","slug":"%ed%85%8c%ec%9d%b4%eb%b8%94%ec%8a%a4%ed%8e%98%ec%9d%b4%ec%8a%a4-%ec%83%9d%ec%84%b1-%ec%8b%9c-%eb%8b%a4%ec%a4%91-%eb%b8%94%eb%a1%9d%ec%82%ac%ec%9d%b4%ec%a6%88-%ec%84%a4%ec%a0%95","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=387","title":{"rendered":"\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 \uc2dc \ub2e4\uc911 \ube14\ub85d\uc0ac\uc774\uc988 \uc124\uc815"},"content":{"rendered":"

\uae30\ubcf8\uc801\uc73c\ub85c, <\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ube14\ub85d \uc0ac\uc774\uc988\ub294 DB <\/span>\uc0dd\uc131\uc2dc\uc5d0 \uc124\uc815\ud558\ub294 \ube14\ub85d \uc0ac\uc774\uc988\uc5d0 \uc601\ud5a5\uc774 \uc788\ub2e4.<\/span><\/span><\/p>\n


<\/span><\/span><\/p>\n

SQL> create
\ntablespace test_16k<\/span><\/p>\n

  2 
\ndatafile ‘\/app\/oracle\/oradata\/orcl\/test_16k.dbf’ size 50m<\/span><\/p>\n

  3 
\nblocksize 16k;<\/span><\/p>\n

create tablespace
\ntest_16k<\/span><\/p>\n

*<\/span><\/p>\n

ERROR at line 1:<\/span><\/p>\n

ORA-29339:
\ntablespace block size 16384 does not match configured block sizes<\/span><\/p>\n

 <\/span><\/p>\n

SQL> show
\nparameter _cache_size<\/span><\/p>\n

 <\/span><\/p>\n

NAME                                TYPE         
\nVALUE<\/span><\/p>\n

————————————
\n———– ——————————<\/span><\/p>\n

client_result_cache_size          
\nbig integer         0<\/span><\/p>\n

db_16k_cache_size               big integer         0<\/span><\/p>\n

db_2k_cache_size                big integer         0<\/span><\/p>\n

db_32k_cache_size               big integer         0<\/span><\/p>\n

db_4k_cache_size                big integer         0<\/span><\/p>\n

db_8k_cache_size                big integer         0<\/span><\/p>\n

db_cache_size                    big integer       128M<\/span><\/p>\n

db_flash_cache_size              big integer         0<\/span><\/p>\n

db_keep_cache_size                big integer         0<\/span><\/p>\n

db_recycle_cache_size            big integer         0<\/span><\/p>\n

 <\/span><\/p>\n

\ud604\uc7ac DB<\/span>\ub294 8kb<\/span>\uc774\ubbc0\ub85c \ube14\ub85d\uc0ac\uc774\uc988\uac00 16kb<\/span>\uc778 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc0dd\uc131\ud558\ub824\uace0 \ud560 \ub54c <\/span><\/p>\n

16kb\ub97c \ucc98\ub9ac\ud558\uae30 \uc704\ud55c \ubc84\ud37c\uce90\uc2dc\uc601\uc5ed\uc774 \uc5c6\uc5b4 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud558\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4<\/span>.<\/span><\/p>\n

\ub54c\ubb38\uc5d0 \ud574\ub2f9\uc601\uc5ed\uc744 <\/font>16k_cache_size \ud30c\ub77c\ubbf8\ud130\uac12\uc744 \ud1b5\ud574 \uc124\uc815\uc744 \ubcc0\uacbd\ud574\uc900\ub2e4.<\/span><\/font><\/p>\n

 <\/span><\/p>\n

SQL> alter
\nsystem set db_16k_cache_size=80m scope=both;<\/span><\/p>\n

 <\/span><\/p>\n

System altered.<\/span><\/p>\n

 <\/span><\/p>\n

16k cahce size<\/span>\ub85c \uba54\ubaa8\ub9ac\ub97c \ud560\ub2f9\ud55c\ub2e4.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

SQL> show
\nparameter _cache_size<\/span><\/p>\n

 <\/span><\/p>\n

NAME                                TYPE        VALUE<\/span><\/p>\n

————————————
\n———– ——————————<\/span><\/p>\n

client_result_cache_size          
\nbig integer         0<\/span><\/p>\n

db_16k_cache_size               big integer         80M<\/span><\/p>\n

db_2k_cache_size                big integer         0<\/span><\/p>\n

db_32k_cache_size               big integer         0<\/span><\/p>\n

db_4k_cache_size                big integer         0<\/span><\/p>\n

db_8k_cache_size                big integer         0<\/span><\/p>\n

db_cache_size                   big integer         128M<\/span><\/p>\n

db_flash_cache_size              big integer         0<\/span><\/p>\n

db_keep_cache_size                big integer         0<\/span><\/p>\n

db_recycle_cache_size            big integer         0<\/span><\/p>\n

 <\/span><\/p>\n

SQL> create
\ntablespace test_16k_lob<\/span><\/p>\n

  2 
\ndatafile ‘\/app\/oracle\/oradata\/orcl\/tab_16k_lob01.dbf’ size 100m <\/span><\/p>\n

  3 
\nblocksize 16k;<\/span><\/p>\n

 <\/span><\/p>\n

16kb <\/span>\ube14\ub85d \ud06c\uae30\ub97c \uac00\uc9c0\ub294 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c
\n\uc0dd\uc131\ud55c\ub2e4.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

SQL> select
\ntablespace_name, block_size, extent_management from dba_tablespaces;<\/span><\/p>\n

 <\/span><\/p>\n

TABLESPACE_NAME                                 BLOCK_SIZE         EXTENT_MAN<\/span><\/p>\n

——————————
\n              ———-           ———-<\/span><\/p>\n

SYSTEM                                             8192                 LOCAL<\/span><\/p>\n

SYSAUX                                             8192                 LOCAL<\/span><\/p>\n

UNDOTBS1                                          8192                  LOCAL<\/span><\/p>\n

TEMP                                                8192                 LOCAL<\/span><\/p>\n

USERS                                              8192
\n                LOCAL<\/span><\/p>\n

TEST_16K_LOB                                     16384
\n                LOCAL<\/span><\/p>\n

 <\/span><\/p>\n

<\/p>\n

<\/span><\/span><\/p>\n

16kb <\/span>\ube14\ub85d \ud06c\uae30\ub97c \uac00\uc9c4 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00
\n\uc0dd\uc131 \ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uae30\ubcf8\uc801\uc73c\ub85c, \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \ube14\ub85d \uc0ac\uc774\uc988\ub294 DB \uc0dd\uc131\uc2dc\uc5d0 \uc124\uc815\ud558\ub294 \ube14\ub85d \uc0ac\uc774\uc988\uc5d0 \uc601\ud5a5\uc774 \uc788\ub2e4. SQL> create tablespace test_16k   2  datafile ‘\/app\/oracle\/oradata\/orcl\/test_16k.dbf’ size 50m   3  blocksize 16k; create tablespace test_16k * ERROR at line 1: ORA-29339: tablespace block size 16384 does not match configured block sizes   SQL> show parameter _cache_size   NAME                                TYPE          VALUE ———————————— […]<\/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":[87,88,89],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/387"}],"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=387"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/387\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=387"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}