{"id":3583,"date":"2018-02-05T20:19:49","date_gmt":"2018-02-05T11:19:49","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3583"},"modified":"2018-02-05T20:20:51","modified_gmt":"2018-02-05T11:20:51","slug":"bigfile-tablespace","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3583","title":{"rendered":"Bigfile Tablespace"},"content":{"rendered":"

<\/h3>\n

Bigfile tablespace(BFT<\/strong>)\ub294 \uc544\uc8fc \ud070 \ud06c\uae30\uc758 datafile\uc744 \uac00\uc9c8 \uc218 \uc788\ub294 tablespace\uc774\ub2e4.
\n<\/span><\/p>\n

Oracle Database 10g\uc758 \uc0c8\ub85c\uc6b4 addressing \uae30\ubc95<\/strong>\uc5d0 \uc758\ud574, \ud558\ub098\uc758 datafile\uc774 40\uc5b5\uac1c\uc758 block\uc744 \uac00\uc9c8 \uc218 \uc788\uac8c \ub418\uc5c8\ub2e4. <\/span><\/p>\n

\uadf8\ub798\uc11c, \ucd5c\ub300 datafile \ud06c\uae30\ub294 block\uc758 \ud06c\uae30\uc5d0 \ub530\ub77c 8TB ~ 128TB\uae4c\uc9c0 \uc774\ub904\uc9c8 \uc218 \uc788\ub2e4. <\/span><\/p>\n

\uc774\uc640 \uad6c\ubd84\ud558\uae30 \uc704\ud558\uc5ec \uc0c1\ub300\uc801\uc73c\ub85c \uc791\uc740 \uc5ec\ub7ec \uac1c\uc758 datafile\uc744 \uac16\uace0 \uc788\ub294 \uae30\uc874\uc758 tablespace\ub294 Smallfile tablespace\ub77c\uace0 \ud55c\ub2e4. <\/span><\/p>\n

Oracle Database 10g\ub294 \uc774 \ub450 \uc885\ub958\uc758 tablespace\ub97c \ubaa8\ub450 \uac00\uc9c8 \uc218 \uc788\ub2e4. BFT\ub294 \uc624\uc9c1 Locally-managed tablespace\ub97c \uc9c0\uc6d0\ud55c\ub2e4.
\n<\/span><\/p>\n

\uc774\ub97c \uc0ac\uc6a9\ud558\uba74, Disk \uacf5\uac04\uad00\ub9ac\uac00 \uc26c\uc6cc\uc9c0\uace0, \ub354 \uc774\uc0c1 tablespace\uc5d0 datafile\uc744 \ucd94\uac00\ud558\ub294 \uc791\uc5c5\uc744 \uc218\ud589\ud560 \ud544\uc694\uac00 \uc5c6\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

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

\uc704 \uadf8\ub9bc\uc5d0\uc11c \ubcfc \uc218 \uc788\ub294 \ubc14\uc640 \uac19\uc774, tablespace\uc640 datafile\uc758 \uad00\uacc4\uac00 1:M\uc778 \uacbd\uc6b0\ub294 \uad00\ub9ac \ubcf5\uc7a1\uc131\uc774 \uc99d\uac00\ub41c\ub2e4. <\/span><\/p>\n

BFT\ub294 \ub17c\ub9ac\uc801\uc73c\ub85c Tablespace\uc640 datafile\uac00 \ub3d9\uc77c\ud558\uac8c \ub2e4\ub904\uc9c8 \uc218 \uc788\ub294 \uac1c\uc5f0\uc131\uc744 \uc81c\uacf5\ud558\ub294 \uac83\uc774\ub2e4. <\/span><\/p>\n

\uc608\uc804 \ubc84\uc804\uc5d0\uc11c, datafile\uc5d0 \ub300\ud574 \uc801\uc6a9\ud558\uc600\ub358 operation\ub4e4\uc774 \uc9c0\uae08\uc740 tablespace\uc5d0 \ub300\ud574\uc11c \uc801\uc6a9 \uac00\ub2a5\ud558\ub2e4.
\n<\/span><\/p>\n

BFT\uc640 OMF(Oracle Managed File)\uac00 \ud568\uaed8 \uc0ac\uc6a9\ub41c\ub2e4\uba74, datafile\uc740 \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc644\ubcbd\ud788 \ud22c\uba85\ud55c \uc874\uc7ac\uac00 \ub41c\ub2e4. <\/span><\/p>\n

\uc65c\ub0d0\ud558\uba74, \ud574\ub2f9 datafile\uc740 \uc0ac\uc6a9\uc790\uc5d0 \uc758\ud574 \uc804\ud600 \ucc38\uc870\ub420 \uc77c\uc774 \uc5c6\uae30 \ub54c\ubb38\uc774\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

\uc7a5\uc810<\/h4>\n

\u25a0 \uc800\uc7a5\uacf5\uac04 \uadf9\ub300\ud654
\n<\/span><\/p>\n

\ud558\ub098\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uac00\uc9c8 \uc218 \uc788\ub294 \ub370\uc774\ud130\uc758 \ud06c\uae30\ub294 8EB<\/strong><\/span>\uc774\ub2e4.
\n<\/span><\/p>\n

\ucd5c\ub300 \ub370\uc774\ud130 \ud06c\uae30\ub294 \uc0b0\ucd9c\ud558\ub294 \uacf5\uc2dd\uc740
\n<\/span><\/p>\n

    \n
  • \n
    M = D(\ucd5c\ub300 \ud30c\uc77c \uc218) * F(\ud30c\uc77c \ub2f9 \ucd5c\ub300 block \uc218) * B(\ucd5c\ub300 block \ud06c\uae30)
    \n<\/span><\/div>\n<\/li>\n
  • \n
    \uc608\uc804 \ubc84\uc804 : (D = 64K, F = 4M and B = 32K) => 8PB<\/strong><\/span>
    \n<\/span><\/div>\n<\/li>\n
  • \n
    \ud604\uc7ac \ubc84\uc804 : (D = 64K, F = 4G and B = 32K) => 8EB<\/strong><\/span>
    \n<\/span><\/div>\n<\/li>\n<\/ul>\n

    \u261e 1PB (petabyte) = 1024TB (terabyte); 1EB (exabyte) = 1024PB = 1,048,576TB = 2**60 bytes! \u261c
    \n<\/span><\/p>\n

     <\/p>\n

    \u25a0 \uad00\ub9ac \uc6a9\uc774\uc131 \uc81c\uacf5
    \n<\/span><\/p>\n

    Tablespace \uc790\uccb4\ub97c Disk \uacf5\uac04\uad00\ub9ac\uc758 \ub2e8\uc704\ub85c \uac04\uc8fc\ub418\uae30 \ub54c\ubb38\uc5d0 Database \uad00\ub9ac\uac00 \uac04\uc18c\ud574 \uc9c4\ub2e4. <\/span><\/p>\n

    DBA\uac00 \uad00\ub9ac\ud574\uc57c \ub420 datafile \uc218\ub3c4 \ud601\uc2e0\uc801\uc73c\ub85c \uc904\uc5b4\ub4e4 \uc218 \uc788\ub2e4.
    \n<\/span><\/p>\n

    \ud604\uc7ac, \ub354\uc6b1 \ub354 \ub9ce\uc740 \ud30c\uc77c\uc744 \uac00\uc9c8 \uc218 \uc788\ub294 64bit OS\uac00 \uc77c\ubc18\ud654 \ub418\uace0 \uc788\uace0, 500GB \uc774\uc0c1\uc744 \uc218\uc6a9\ud560 \uc218 \uc788\ub294 Disk drive\uac00 \ucd9c\uc2dc\ub418\uace0 \uc788\ub294 \uc0c1\ud669\uc5d0\uc11c BFT\uc758 \ub9e4\ub825\uc740 \ub354\uc6b1 \ub354 \uc99d\uac00\ud560 \uac83\uc73c\ub85c \ud310\ub2e8\ub41c\ub2e4.<\/p>\n

     <\/p>\n

    \uc720\uc758 \uc0ac\ud56d<\/h4>\n

    \ub3d9\uc801\uc73c\ub85c Logical volume\uc744 \ud655\uc7a5\ud560 \uc218 \uc788\uace0 striping\/RAID\ub97c \uc9c0\uc6d0\ud558\ub294 ASM(Automatic Storage Management) \ub610\ub294 LVM(Logical Volume Manager)\uacfc \ud568\uaed8 BFT\ub97c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4.<\/p>\n

    \ud2b9\ud788, Striping\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 Filesystem\uc5d0 BFT\ub97c \uc0dd\uc131\ud574\uc11c\ub294 \uc548\ub41c\ub2e4.<\/p>\n

    \uc65c\ub0d0\ud558\uba74, \uc774\ub7ec\ud55c \ud658\uacbd\uc5d0\uc11c Parallel Query\uc758 \uc131\ub2a5\uc740 \ub9e4\uc6b0 \ub5a8\uc5b4\uc9c8 \uac83\uc73c\ub85c \ud310\ub2e8\ub418\uba70, RMAN \ubc31\uc5c5 \uc2dc \uc0ac\uc6a9\ub418\ub294 \ubcd1\ub82c\ucc98\ub9ac \uc18d\ub3c4 \ub610\ud55c \ub9c8\ucc2c\uac00\uc9c0\uc758 \uacb0\uacfc\ub97c \uac00\uc838\uc62c \uc218 \uc788\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n

    \uadf8\ub9ac\uace0, Disk \uac00\uc6a9 \uacf5\uac04\uc774 \uc81c\ud55c\ub41c \uacbd\uc6b0\ub098 \uacf5\uac04\uc744 \ub298\uc774\ub294 \ubc29\ubc95\uc774 \ub610 \ub2e4\ub978 Disk\uc5d0 \uc0c8\ub85c\uc6b4 datafile\uc744 \ucd94\uac00\ud558\ub294 \ubc29\ubc95\ubc16\uc5d0 \uc5c6\ub294 \uacbd\uc6b0\ub294 BFT \uc0ac\uc6a9\uc774 \ube44 \ud6a8\uc728\uc801\uc774\ub2e4.<\/p>\n

    \uadf8\ub7ec\ub098, \uc5b8\uae09\ub41c \ub450 \uac00\uc9c0\uc758 \uc0c1\ud669\uc774, \ub300\uc6a9\ub7c9 database\uc5d0\uc11c\ub294 \uc27d\uac8c \ucc3e\uc544 \ubcfc \uc218 \uc5c6\ub294 \uac83\uc774 \ud604\uc2e4\uc774\ub2e4.<\/p>\n

    ‘Large File’ option\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\ub294 platform\uc5d0\uc11c BFT\ub97c \uc0ac\uc6a9\ud558\uba74 Tablespace \uac00\uc6a9\uacf5\uac04\uc758 \uc81c\uc57d\uc0ac\ud56d\uc774 \uae09\uc99d\ud55c\ub2e4.
    \n<\/strong><\/span><\/p>\n

     <\/p>\n

    Extended ROWID Format and BFT<\/h4>\n

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

    BFT\ub97c \ud45c\ud604\ud558\ub294 ROWID\ub294 \uc0c1\ub300\ud30c\uc77c number\ub97c \ud3ec\ud568\ud558\uace0 \uc788\uc9c0 \uc54a\ub2e4. \ub300\uc2e0 \uadf8 \uc790\ub9ac\uc5d0 \uae30\uc874\uc758 Rowid \ubcf4\ub2e4 \ub354\uc6b1 \ud070 block number\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \uccb4\uacc4\ub97c \uc801\uc6a9\ud558\uace0 \uc788\ub2e4.
    \n<\/span><\/p>\n

    \uc608\uc804 \ubc84\uc804\uc758 ROWID \ud615\uc2dd : OOOOOOFFFBBBBBBRRR<\/h5>\n
      \n
    • \n
      OOOOOO : database segment\ub97c \uc9c0\uc815\ud558\ub294 data object number
      \n<\/span><\/div>\n<\/li>\n
    • \n
      FFF : \uc0c1\ub300\ud30c\uc77c number
      \n<\/span><\/div>\n<\/li>\n
    • \n
      BBBBB : \uc2e4\uc81c Row\ub97c \ud3ec\ud568\ud558\uace0 \uc788\ub294 data block number
      \n<\/span><\/div>\n<\/li>\n
    • \n
      RRR : \ud2b9\uc815 block \ub0b4\uc758 Row\ub97c \uc9c0\uc815\ud558\ub294 slot number
      \n<\/span><\/div>\n<\/li>\n<\/ul>\n

      Bigfile tablespace\uc5d0\ub294 \uc0c1\ub300\ud30c\uc77c number\uac00 1024\uc778 \ud30c\uc77c \ud558\ub098\ub9cc\uc774 \uc874\uc7ac\ud55c\ub2e4. <\/span><\/p>\n

      \uadf8\ub7ec\ubbc0\ub85c \ud30c\uc77c number\ub97c ROWID\uc5d0\uc11c \ud45c\ud604\ud560 \ud544\uc694\uac00 \uc5c6\uace0, FFF \uc640 BBBBBB \ubc94\uc704\ub294 block number\ub97c \ub098\ud0c0\ub0b4\ub294\ub370 \uc4f0\uc778\ub2e4. <\/span><\/p>\n

      BFT\uc758 ROWID \uc815\ubcf4\ub97c \uc5bb\uc5b4\ub0b4\uae30 \uc704\ud574\uc11c\ub294 DBMS_ROWID package\ub97c \uc0ac\uc6a9\ud574\uc57c\ub9cc \ud55c\ub2e4.
      \n<\/span><\/p>\n

       <\/p>\n

      \n\n\n<\/colgroup>\n\n\n
      SQL> SELECT DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID,’BIGFILE<\/strong><\/span>‘) from sales
      \n<\/span>where rownum < 2
      \n<\/span><\/p>\n

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

      DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID,’BIGFILE’)
      \n<\/span><\/p>\n

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

      1024
      \n<\/strong><\/span><\/p>\n

      SQL> SELECT DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID,’SMALLFILE<\/strong><\/span>‘) from sales
      \n<\/span><\/p>\n

      where rownum < 2
      \n<\/span><\/p>\n

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

      DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID,’SMALLFILE’)
      \n<\/span><\/p>\n

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


      \n5<\/strong><\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

      Bigfile tablespace(BFT)\ub294 \uc544\uc8fc \ud070 \ud06c\uae30\uc758 datafile\uc744 \uac00\uc9c8 \uc218 \uc788\ub294 tablespace\uc774\ub2e4. Oracle Database 10g\uc758 \uc0c8\ub85c\uc6b4 addressing \uae30\ubc95\uc5d0 \uc758\ud574, \ud558\ub098\uc758 datafile\uc774 40\uc5b5\uac1c\uc758 block\uc744 \uac00\uc9c8 \uc218 \uc788\uac8c \ub418\uc5c8\ub2e4. \uadf8\ub798\uc11c, \ucd5c\ub300 datafile \ud06c\uae30\ub294 block\uc758 \ud06c\uae30\uc5d0 \ub530\ub77c 8TB ~ 128TB\uae4c\uc9c0 \uc774\ub904\uc9c8 \uc218 \uc788\ub2e4. \uc774\uc640 \uad6c\ubd84\ud558\uae30 \uc704\ud558\uc5ec \uc0c1\ub300\uc801\uc73c\ub85c \uc791\uc740 \uc5ec\ub7ec \uac1c\uc758 datafile\uc744 \uac16\uace0 \uc788\ub294 \uae30\uc874\uc758 tablespace\ub294 Smallfile tablespace\ub77c\uace0 \ud55c\ub2e4. Oracle Database […]<\/p>\n","protected":false},"author":1,"featured_media":2331,"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":[11],"tags":[1021,1018,1016,1020,1017,1019],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/custom-Custom_Size___Cloud-Marketplace_457-x-457-e1493910495972.jpg?fit=457%2C457","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3583"}],"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=3583"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3583\/revisions"}],"predecessor-version":[{"id":3586,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3583\/revisions\/3586"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2331"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3583"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}