{"id":435,"date":"2015-09-03T04:13:17","date_gmt":"2015-09-03T04:13:17","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=435"},"modified":"2015-09-03T04:13:17","modified_gmt":"2015-09-03T04:13:17","slug":"create-table-%ed%85%8c%ec%9d%b4%eb%b8%94-%ec%83%9d%ec%84%b1%eb%ac%b8%ec%9d%98-storage-option-%ec%84%a4%eb%aa%85","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=435","title":{"rendered":"Create Table \ud14c\uc774\ube14 \uc0dd\uc131\ubb38\uc758 Storage Option \uc124\uba85"},"content":{"rendered":"

Create Table \uc2dc Storage Option \uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/span><\/h1>\n

 \uc608\uc2dc)<\/span><\/p>\n

CREATE  TABLE 
\nTEST(<\/span><\/p>\n

        AA             VARCHAR2(3),<\/span><\/p>\n

        BB             NUMBER(5),<\/span><\/p>\n

        CC             VARCHAR2(10)
\n)<\/span><\/p>\n

TABLESPACE     PRODUCE<\/span><\/p>\n

INITRANS       1<\/span><\/p>\n

MAXTRANS       4<\/span><\/p>\n

STORAGE (      INITIAL        10M<\/span><\/p>\n

               NEXT           10M<\/span><\/p>\n

               MINEXTENTS     1<\/span><\/p>\n

               MAXEXTENTS     121<\/span><\/p>\n

               PCTINCREASE    0<\/span><\/p>\n

               FREELISTS      1<\/span><\/p>\n

               FREELIST GROUPS 2<\/span><\/p>\n

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

PCTFREE 10<\/span><\/p>\n

PCTUSED 40 <\/span><\/span><\/p>\n

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

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

l 
\n<\/span><\/span>INITRANS
\n(DEFAULT 1)<\/span><\/p>\n

–    <\/span><\/span>Block <\/span>\uacf5\uac04
\n\ud560\ub2f9\uc2dc\uc5d0 \ud55c BLOCK<\/span>\uc5d0 \uc9c0\uc815\ud55c \uac1c\uc218 \ub9cc\ud07c\uc758 Transaction
\nSlot(ITL)<\/span>\uc744 <\/span>\ud560\ub2f9\ud560
\n\uacf5\uac04\uc744 \uc608\uc57d\ud558\uac8c \ub41c\ub2e4<\/span>.<\/span><\/p>\n

–    <\/span><\/span>BLOCK HEADER<\/span>\uc5d0 \ub354 \uc774\uc0c1 TRANSACTION ID<\/span>\ub97c \uae30\ub85d\ud560 \uacf5\uac04\uc774 \uc5c6\uc744 \uacbd\uc6b0 BLOCK<\/span>\uc758 DATA <\/span>\uc601\uc5ed\uc5d0 \uc5ec\uc720\uacf5\uac04\uc5d0 \uae30\ub85d\ud55c\ub2e4.<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>MAXTRANS<\/span><\/p>\n

–    <\/span><\/span>\ud55c BLOCK<\/span>\uc5d0\uc11c \ub3d9\uc2dc\uc5d0 \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ucd5c\ub300 Transaction Slot(ITL)<\/span>\uc758 \uac1c\uc218<\/span><\/span><\/p>\n

–    <\/span><\/span>\ud574\ub2f9 BLOCK<\/span>\uc758
\nHEADER <\/span>\ubc0f DATA <\/span>\uc601\uc5ed\uc5d0 \ub354 \uc774\uc0c1 \uae30\ub85d\ud560 \uacf5\uac04\uc774 \uc5c6\uc744 \uacbd\uc6b0 TRANSACTION<\/span>\uc740 WATING <\/span>\uc0c1\ud0dc\ub85c \ub41c\ub2e4.<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>INITIAL<\/span><\/p>\n

–    <\/span><\/span>INITIAL EXTENT<\/span>\uc758 SIZE<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>NEXT<\/span><\/p>\n

–    <\/span><\/span>INCREMENTAL EXTENT<\/span>\uc758 SIZE<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>MINEXTENTS
\n(DEFAULT 1, Rollback Segment <\/span>\ub294 2)<\/span><\/span><\/p>\n

–    <\/span><\/span>\ucd5c\uc18c\ud55c \uac00\uc9c8 \uc218 \uc788\ub294 EXTENTS<\/span>\uc758 \uc218 (<\/span>\ucd5c\uc18c\uac12 1)<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>MAXEXTENTS<\/span><\/p>\n

–    <\/span><\/span>\ucd5c\ub300\ud55c \uac00\uc9c8 \uc218 \uc788\ub294 EXTENTS<\/span>\uc758 \uc218<\/span><\/span><\/p>\n

–    <\/span><\/span>MAXEXTENTS<\/span>\uae4c\uc9c0 \ubc1c\uc0dd\ud588\uc744\ub54c \uc751\uae09\uc870\uce58\ub97c \uc704\ud574\uc11c 100 <\/span>\uc774\uc0c1 \ub118\uc9c0 \uc54a\ub294 \uac8c \uc88b\ub2e4.<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>PCTINCREASE
\n(DEFAULT 50)<\/span><\/p>\n

–    <\/span><\/span>NEXT EXTENT <\/span>\ubc1c\uc0dd \uc2dc \uc99d\uac00 \ube44\uc728<\/span><\/span><\/p>\n

–    <\/span><\/span>\ub418\ub3c4\ub85d 0<\/span>\uc744 \uc900\ub2e4.<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>FREELISTS
\n(DEFAULT 1)<\/span><\/p>\n

–    <\/span><\/span>SEGMENT HEADER <\/span>\uc5d0 \ubcf4\uad00\/<\/span>\uad00\ub9ac\ub418\ub294 FREE
\nLIST<\/span>\uc758 \uac1c\uc218\ub97c \uc9c0\uc815.<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>FREELIST
\nGROUPS (DEFAULT 1)<\/span><\/p>\n

–    <\/span><\/span>FREELIST<\/span>\uc758 GROUP <\/span>\uc218.<\/span><\/span><\/p>\n

–    <\/span><\/span>\uc8fc\ub85c OPS(Oracle Parallel Server)<\/span>\uc5d0\uc11c INSTANCE<\/span>\uc758 \uc218 \ub9cc\ud07c \uc124\uc815\ud574 \uc900\ub2e4.<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>PCTFREE
\n(DEFAULT 10)<\/span><\/p>\n

–    <\/span><\/span>BLOCK<\/span>\uc5d0\uc11c Size <\/span>\uac00 \uc99d\uac00\ud558\ub294 UPDATE <\/span>\ub97c \uc704\ud574\uc11c \ub0a8\uaca8\ub458 \uacf5\uac04\uc758 \ud37c\uc13c\ud2b8<\/span><\/span><\/p>\n

–    <\/span><\/span>\ub0a8\uc740\uacf5\uac04\uc758 \ube44\uc728\uc774 \uc9c0\uc815\ud55c \uac12\ubcf4\ub2e4 \uc791\uc544\uc9c0\uba74 \ud574\ub2f9 \ube14\ub85d\uc740 FREELIST<\/span>\uc5d0\uc11c
\n\uc0ad\uc81c\ub428<\/span><\/span><\/p>\n

–    <\/span><\/span>Size <\/span>\uac00 \uc99d\uac00\ud558\ub294 UPDATE <\/span>\uac00 \ub9ce\uc774 \ubc1c\uc0dd\ud560 \uacbd\uc6b0 \ud06c\uac8c \uc900\ub2e4.<\/span><\/span><\/p>\n

–    <\/span><\/span>\uc791\uac8c \uc8fc\uba74 \uacf5\uac04\ud65c\uc6a9\ub3c4\uac00 \ub192\uc544\uc9d0<\/span><\/span><\/p>\n

l 
\n<\/span><\/span>PCTUSED<\/span><\/p>\n

–    <\/span><\/span>Insert <\/span>\ubd88\uac00\ub2a5 BLOCK <\/span>\uc774 DELETE <\/span>\uc791\uc5c5\uc73c\ub85c \uc778\ud574 \uc0ac\uc6a9\uacf5\uac04\uc758 \ube44\uc728\uc774 \uc9c0\uc815\ud55c
\n\uac83\ubcf4\ub2e4 \uc791\uc544\uc9c0\uac8c \ub418\uba74 FREELIST<\/span>\uc5d0 \ub2e4\uc2dc \ub4f1\ub85d\ub418\uc5b4 Insert <\/span>\uac00\ub2a5\ud55c Block <\/span>\uc73c\ub85c \ub41c\ub2e4<\/span><\/span><\/p>\n

–    <\/span><\/span>INSERT\/DELETE <\/span>\uac00 \ubc18\ubcf5\uc801\uc73c\ub85c \ubc1c\uc0dd\ud560 \uacbd\uc6b0\ub294 \uc791\uac8c \uc900\ub2e4.<\/span><\/span><\/p>\n

–    <\/span><\/span>\ud06c\uac8c \uc8fc\uba74 \uacf5\uac04\ud65c\uc6a9\ub3c4\uac00 \ub192\uc544\uc9d0<\/span><\/span><\/p>\n

(<\/span>\uc608)<\/span><\/span><\/p>\n

PCTFREE = 10 ,
\nPCTUSED = 40 <\/span>\uc77c \uacbd\uc6b0 \uc0ac\uc6a9\ud558\ub294
\nBLOCK<\/span>\uc758 \uacf5\uac04\uc774 10%<\/span>\uc774\ud558\ub85c \ub0a8\uc73c\uba74 \uadf8 BLOCK<\/span>\uc740 FREELISTS<\/span>\uc5d0\uc11c \uc9c0\uc6cc\uc9c0\uace0 \ub354 \uc774\uc0c1 INSERT<\/span>\ub97c \ud560 \uc218 \uc5c6\uac8c
\n\ub41c\ub2e4.  <\/span>\uadf8 \ud6c4 \uadf8 BLOCK<\/span>\uc5d0 DATA<\/span>\uac00 \ub9ce\uc774
\nDELETE<\/span>\ub418\uc5b4\uc11c 40% <\/span>\ubbf8\ub9cc\uc73c\ub85c \uc0ac\uc6a9\ud558\uace0 \uc788\uc73c\uba74 \uadf8
\nBLOCK<\/span>\uc740 \ub2e4\uc2dc FREELISTS<\/span>\uc5d0 \ub4f1\ub85d\uc774 \ub418\uc5b4
\nINSERT<\/span>\ub97c \ud560 \uc218 \uc788\ub294 BLOCK<\/span>\uc774 \ub41c\ub2e4.<\/span><\/span><\/p>\n<\/p>\n

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

Create Table \uc2dc Storage Option \uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.  \uc608\uc2dc) CREATE  TABLE  TEST(         AA             VARCHAR2(3),         BB             NUMBER(5),         CC             VARCHAR2(10) ) TABLESPACE     PRODUCE INITRANS       1 MAXTRANS       4 STORAGE (      INITIAL        10M                NEXT           10M                MINEXTENTS     1                MAXEXTENTS     121                PCTINCREASE    0                FREELISTS      1                FREELIST GROUPS 2         ) PCTFREE 10 […]<\/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":[201,202,203],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/435"}],"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=435"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/435\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=435"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}