{"id":4674,"date":"2021-11-04T16:20:41","date_gmt":"2021-11-04T07:20:41","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=4674"},"modified":"2021-11-04T16:21:14","modified_gmt":"2021-11-04T07:21:14","slug":"asm-disk-%ec%97%90%ec%84%9c-au-size-%ec%99%80-data-file-%ec%9d%98-%ec%b5%9c%eb%8c%80-%ed%81%ac%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=4674","title":{"rendered":"ASM DISK \uc5d0\uc11c AU size \uc640 DATA FILE \uc758 \ucd5c\ub300 \ud06c\uae30"},"content":{"rendered":"
\n
ASM Disk\ub97c \uc0ac\uc6a9 \ud560\ub54c \uc544\ub798 \ub450 \uac00\uc9c0\ub97c \uc120\ud0dd\uc744 \ud574\uc57c \ud569\ub2c8\ub2e4.<\/div>\n
<\/div>\n<\/div>\n
\n
1. allocation unit (AU) size \ucd08\uae30 \uc124\uc815<\/strong><\/span><\/div>\n
<\/div>\n<\/div>\n
\n
2. TABLESPACE \uc758 \ub370\uc774\ud0c0\ud30c\uc77c \uc744 bigfile \ub85c \uc0ac\uc6a9 \uc5ec\ubd80<\/strong><\/span><\/div>\n
<\/div>\n<\/div>\n
\n
\ub450 \uac00\uc9c0\ub97c \uc120\ud0dd\uc744 \ud558\uae30 \uc704\ud55c \uac00\uc774\ub4dc \ubb38\uc11c\uc785\ub2c8\ub2e4.<\/div>\n<\/div>\n
\n
19c\uac00 \ub418\uc5c8\ub2e4\uace0 \ud574\uc11c \ubcc0\uacbd \ubd80\ubd84\uc740 \uc5c6\ub294 \uc0c1\ud0dc \uc774\uace0 \ubcc0\uacbd\uc774 \ub418\uc5c8\ub358 \ubc84\uc804\ubd80\ud130 \ucc38\uace0 \ub9c1\ud06c\ub97c \ub123\uc5c8\uc2b5\ub2c8\ub2e4.<\/div>\n
<\/div>\n<\/div>\n
\n
12cR1<\/div>\n<\/div>\n
\n
https:\/\/docs.oracle.com\/…\/GUID-BC6544D7-6D59-42B3-AE1F…<\/a><\/div>\n<\/div>\n
\n
<\/div>\n
Oracle ASM Storage Limits<\/div>\n<\/div>\n
\n
\u2022 511 disk groups in a storage system for Oracle Database 12c Release 1 or later<\/div>\n<\/div>\n
\n
\u2022 10,000 Oracle ASM disks in a storage system<\/div>\n<\/div>\n
\n
\u2022 1 million files for each disk group<\/div>\n<\/div>\n
\n
<\/div>\n
Without any Oracle Exadata Storage, Oracle ASM has the following storage limits if the COMPATIBLE.ASM or COMPATIBLE.RDBMS disk group attribute is set to less than 12.1:<\/div>\n<\/div>\n
\n
\u2022 2 terabytes (TB) maximum storage for each Oracle ASM disk<\/div>\n<\/div>\n
\n
\u2022 20 petabytes (PB) maximum for the storage system<\/div>\n<\/div>\n
\n
<\/div>\n
Without any Oracle Exadata Storage, Oracle ASM has the following storage limits if the COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes are set to 12.1 or greater:<\/div>\n<\/div>\n
\n
\u2022 4 PB maximum storage for each Oracle ASM disk with the allocation unit (AU) size equal to 1 MB<\/div>\n<\/div>\n
\n
\u2022 8 PB maximum storage for each Oracle ASM disk with the AU size equal to 2 MB<\/div>\n<\/div>\n
\n
\u2022 16 PB maximum storage for each Oracle ASM disk with the AU size equal to 4 MB<\/strong> –> \uac00\uc7a5 \ubcf4\ud3b8\uc801\uc73c\ub85c \uc0ac\uc6a9 \uc911 ( \ub370\uc774\ud0c0 \ud30c\uc77c)<\/div>\n<\/div>\n
\n
\u2022 32 PB maximum storage for each Oracle ASM disk with the AU size equal to 8 MB<\/div>\n<\/div>\n
\n
\u2022 320 exabytes (EB) maximum for the storage system<\/div>\n<\/div>\n
\n
<\/div>\n
With all Oracle Exadata Storage, Oracle ASM has the following storage limits:<\/div>\n<\/div>\n
\n
\u2022 4 PB maximum storage for each Oracle ASM disk with the AU size equal to 1 MB<\/div>\n<\/div>\n
\n
\u2022 8 PB maximum storage for each Oracle ASM disk with the AU size equal to 2 MB<\/div>\n<\/div>\n
\n
\u2022 16 PB maximum storage for each Oracle ASM disk with the AU size equal to 4 MB<\/strong> –> \uac00\uc7a5 \ubcf4\ud3b8\uc801\uc73c\ub85c \uc0ac\uc6a9 \uc911 ( \ub370\uc774\ud0c0 \ud30c\uc77c)<\/div>\n<\/div>\n
\n
\u2022 32 PB maximum storage for each Oracle ASM disk with the AU size equal to 8 MB<\/div>\n<\/div>\n
\n
\u2022 320 EB maximum for the storage system<\/div>\n<\/div>\n
\n
<\/div>\n
RAC \ud658\uacbd\uc5d0\uc11c OCR, VOTE Disk \uc0ac\uc6a9\uc2dc AU \uc0ac\uc774\uc988 \uc815\uc758\ud560\ub54c 4MB\ub85c \uc0ac\uc6a9\uc744 \ud560 \ud544\uc694\ub294 \uc5c6\uc744\uac83 \uac19\uc2b5\ub2c8\ub2e4.<\/div>\n
<\/div>\n
\ub530\ub85c DISK GROUP\ub97c \uc815\uc758 \ud558\uc2e0 \ud6c4 \uc124\uc815\uc744 \ud558\uc2dc\ub294\uac83\ub3c4 \uace0\ub824 \ud574 \ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/div>\n
<\/div>\n<\/div>\n
\n
Bigfile Tablespaces \uad00\ub828 \ub0b4\uc6a9.. 10gR2 \uc815\uc758\ub418\uc5c8\ub358 \ub0b4\uc6a9\uc740 \ubcc0\ud568\uc5c6\uc5c8\uc2b5\ub2c8\ub2e4.<\/div>\n
<\/div>\n<\/div>\n
\n
10gR2<\/div>\n<\/div>\n
\n
https:\/\/docs.oracle.com\/…\/server.102\/b14237\/limits.htm…<\/a><\/div>\n<\/div>\n
\n
<\/div>\n
12cR2<\/div>\n<\/div>\n
\n
https:\/\/docs.oracle.com\/…\/refrn\/database-limits.html…<\/a><\/div>\n<\/div>\n
<\/div>\n
<\/div>\n
\n
Datatype Limits<\/strong><\/span><\/div>\n<\/div>\n
\n
Physical Database Limits –> ***** Bigfile Tablespaces<\/div>\n<\/div>\n
\n
Logical Database Limits<\/div>\n<\/div>\n
\n
Process and Runtime Limits<\/div>\n<\/div>\n
\n
A bigfile tablespace contains only one datafile or tempfile,<\/div>\n<\/div>\n
\n
which can contain up to approximately 4 billion ( 232 ) blocks.<\/div>\n<\/div>\n
\n
The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32K blocks and 32TB for a tablespace with 8K blocks.<\/strong><\/div>\n<\/div>\n
\n
<\/div>\n
Maximum datafile size for a SmallFile Tablespace based on 10gR2 documentation would be:<\/div>\n
<\/div>\n<\/div>\n
\n
Block Size Maximum Datafile File Size<\/div>\n<\/div>\n
\n
———– —————————<\/div>\n<\/div>\n
\n
2k 4194303 * 2k = 8 GB<\/div>\n<\/div>\n
\n
4k 4194303 * 4k = 16 GB<\/div>\n<\/div>\n
\n
8k 4194303 * 8k = 32 GB<\/strong> –> \ud55c \uac1c\uc758 \ub370\uc774\ud0c0 \ud30c\uc77c\uc740 \ucd5c\ub300 \ud06c\uae30\ub294 32GB \uc785\ub2c8\ub2e4.<\/strong> ( \uae30\ubcf8\uc801\uc73c\ub85c \uc0ac\uc6a9 )<\/div>\n<\/div>\n
\n
16k 4194303 * 16k = 64 GB<\/div>\n<\/div>\n
\n
32k 4194303 * 32k = 128 GB<\/div>\n<\/div>\n
\n
<\/div>\n
<\/div>\n
Maximum datafile size for a BigFile Tablespace based on 10gR2 documentation would be:<\/div>\n
<\/div>\n<\/div>\n
\n
Block Size Maximum Datafile File Size<\/div>\n<\/div>\n
\n
———– —————————<\/div>\n<\/div>\n
\n
2k 4294967295 * 2k = 8 TB<\/div>\n<\/div>\n
\n
4k 4294967295 * 4k = 16 TB<\/div>\n<\/div>\n
\n
8k 4294967295 * 8k = 32 TB<\/strong> –> \ud55c \uac1c\uc758 \ub370\uc774\ud0c0\ud30c\uc77c \uc740 32TB \uc785\ub2c8\ub2e4.<\/strong> ( \uae30\ubcf8\uc801\uc73c\ub85c \uc0ac\uc6a9 )<\/div>\n<\/div>\n
\n
16k 4294967295 * 16k = 64 TB<\/div>\n<\/div>\n
\n
32k 4294967295 * 32k = 128 TB<\/div>\n<\/div>\n
\n
\uc21c\uc218 \uacc4\uc0b0\uc2dd \uc785\ub2c8\ub2e4.<\/div>\n<\/div>\n
\n
<\/div>\n
\uc2e4\uc9c8\uc801\uc73c\ub85c OS \ub9c8\ub2e4 \ub2e4\uc18c \ucc28\uc774\uac00 \uc788\uc5b4\uc11c \uacc4\uc0b0\uc2dd\ucc98\ub7fc \ub098\uc624\uc9c0 \uc54a\uc744 \uac83 \uc774\uace0 SmallFile \ucd5c\ub300 \ud06c\uae30\ub294 31GB \uc815\ub3c4 \ub098\uc624\uc9c0 \uc54a\uc744\uae4c \uc2f6\uc2b5\ub2c8\ub2e4.\u00a0 ( \ud30c\uc77c\uc2dc\uc2a4\ud15c\ub3c4 \ub3d9\uc77c \ud560 \ub4ef \ud569\ub2c8\ub2e4. )<\/div>\n
<\/div>\n<\/div>\n
\n
BigFile \ucd5c\ub300 \ud06c\uae30\ub3c4 32TB \ub3c4 \uacc4\uc0b0\uc2dd \uc785\ub2c8\ub2e4<\/div>\n
<\/div>\n<\/div>\n
\n
BigFile \uc0ac\uc6a9\ud558\ub294 \uacf3\uc774 \uc810\uc810 \ub9ce\uc544\uc9c8 \uac83 \uc785\ub2c8\ub2e4.<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

ASM Disk\ub97c \uc0ac\uc6a9 \ud560\ub54c \uc544\ub798 \ub450 \uac00\uc9c0\ub97c \uc120\ud0dd\uc744 \ud574\uc57c \ud569\ub2c8\ub2e4. 1. allocation unit (AU) size \ucd08\uae30 \uc124\uc815 2. TABLESPACE \uc758 \ub370\uc774\ud0c0\ud30c\uc77c \uc744 bigfile \ub85c \uc0ac\uc6a9 \uc5ec\ubd80 \ub450 \uac00\uc9c0\ub97c \uc120\ud0dd\uc744 \ud558\uae30 \uc704\ud55c \uac00\uc774\ub4dc \ubb38\uc11c\uc785\ub2c8\ub2e4. 19c\uac00 \ub418\uc5c8\ub2e4\uace0 \ud574\uc11c \ubcc0\uacbd \ubd80\ubd84\uc740 \uc5c6\ub294 \uc0c1\ud0dc \uc774\uace0 \ubcc0\uacbd\uc774 \ub418\uc5c8\ub358 \ubc84\uc804\ubd80\ud130 \ucc38\uace0 \ub9c1\ud06c\ub97c \ub123\uc5c8\uc2b5\ub2c8\ub2e4. 12cR1 https:\/\/docs.oracle.com\/…\/GUID-BC6544D7-6D59-42B3-AE1F… Oracle ASM Storage Limits \u2022 511 […]<\/p>\n","protected":false},"author":1,"featured_media":2857,"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":[1255,1256,1254,1252,1253],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/oracle-business-intelligence.jpg?fit=973%2C615","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4674"}],"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=4674"}],"version-history":[{"count":2,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4674\/revisions"}],"predecessor-version":[{"id":4676,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4674\/revisions\/4676"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2857"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4674"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}