【Oracle ASM】Variable Extent Size 原理

Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large databases, and improve performance for file create and open operations. The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The initial extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at predefined thresholds. This feature is automatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11 or higher. For information about compatibility attributes, see “Disk Group Compatibility”.

For 11.1 shows the ASM file extent relationship with allocation units. Extent size is always equal to AU for the first 20000 extent sets (0 – 19999). Figure 1-4 shows the first eight extents (0 to 7) distributed on four ASM disks. After the first 20000 extent sets, the extent size becomes 8*AU for next 20000 extent sets (20000 – 39999). This is shown as bold rectangles labeled with the extent set numbers 20000 to 20007, and so on. The next increment for an ASM extent is 64*AU (not shown in the figure).

The ASM coarse striping is always equal to the disk group AU size, but fine striping size always remains 128KB in any configuration (not shown in the figure). The AU size is determined at creation time with the allocation unit size (AU_SIZE) disk group attribute. The values can be 1, 2, 4, 8, 16, 32, and 64 MB.

 

 

FOR 11.2:

The extent size of a file varies as follows:

  • Extent size always equals the disk group AU size for the first 20000 extent sets (0 – 19999).
  • Extent size equals 4*AU size for the next 20000 extent sets (20000 – 39999).
  • Extent size equals 16*AU size for the next 20000 and higher extent sets (40000+)

 

 

 

ostmg004

 

如绿字所标记 Variable Extent Size要求DATABASE_COMPATIBILITY 》=11.1,否则不管你构建多大的数据文件 最后其Extent Size总是等于1个AU的。

 

SQL> select * from x$kffxp where size_kffxp!=1 and rownum<3;

ADDR                   INDX    INST_ID GROUP_KFFXP NUMBER_KFFXP COMPOUND_KFFXP INCARN_KFFXP  PXN_KFFXP XNUM_KFFXP  LXN_KFFXP DISK_KFFXP   AU_KFFXP FLAGS_KFFXP  CHK_KFFXP SIZE_KFFXP
---------------- ---------- ---------- ----------- ------------ -------------- ------------ ---------- ---------- ---------- ---------- ---------- ----------- ---------- ----------
00007F6FCB2557F0      54983          1           1         6345       16783561    838455287      40000      20000          0          4      17036           0        224          4
00007F6FCB2557F0      54984          1           1         6345       16783561    838455287      40001      20000          1          0       3888           0         21          4

 

如上述查询 size_kffxp 为Extent的大小(几个AU)。 这些EXTENT对应于FILE NUMBER 6345:

 

 

[oracle@mlab2 ~]$ kfed read /dev/asm-disk9 aun=22 blkn=201|less
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            4 ; 0x002: KFBTYP_FILEDIR
kfbh.datfmt:                          1 ; 0x003: 0x01
kfbh.block.blk:                    6345 ; 0x004: blk=6345
kfbh.block.obj:                       1 ; 0x008: file=1
kfbh.check:                  2648198861 ; 0x00c: 0x9dd84ecd
kfbh.fcn.base:                  1506490 ; 0x010: 0x0016fcba
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
kfffdb.node.incarn:           838455287 ; 0x000: A=1 NUMM=0x18fce7fb
kfffdb.node.frlist.number:   4294967295 ; 0x004: 0xffffffff
kfffdb.node.frlist.incarn:            0 ; 0x008: A=0 NUMM=0x0
kfffdb.hibytes:                       5 ; 0x00c: 0x00000005
kfffdb.lobytes:              1073750016 ; 0x010: 0x40002000
kfffdb.xtntcnt:                   40768 ; 0x014: 0x00009f40
kfffdb.xtnteof:                   40768 ; 0x018: 0x00009f40
kfffdb.blkSize:                    8192 ; 0x01c: 0x00002000
kfffdb.flags:                        17 ; 0x020: O=1 S=0 S=0 D=0 C=1 I=0 R=0 A=0
kfffdb.fileType:                      2 ; 0x021: 0x02
kfffdb.dXrs:                         18 ; 0x022: SCHE=0x1 NUMB=0x2
kfffdb.iXrs:                         19 ; 0x023: SCHE=0x1 NUMB=0x3
kfffdb.dXsiz[0]:                  20000 ; 0x024: 0x00004e20
kfffdb.dXsiz[1]:                  20000 ; 0x028: 0x00004e20
kfffdb.dXsiz[2]:             4294967288 ; 0x02c: 0xfffffff8
kfffdb.iXsiz[0]:             4294967295 ; 0x030: 0xffffffff
kfffdb.iXsiz[1]:                      0 ; 0x034: 0x00000000
kfffdb.iXsiz[2]:                      0 ; 0x038: 0x00000000
kfffdb.xtntblk:                      63 ; 0x03c: 0x003f
kfffdb.break:                        60 ; 0x03e: 0x003c
kfffdb.priZn:                         0 ; 0x040: KFDZN_COLD
kfffdb.secZn:                         0 ; 0x041: KFDZN_COLD
kfffdb.ub2spare:                      0 ; 0x042: 0x0000
kfffdb.alias[0]:                   6998 ; 0x044: 0x00001b56
kfffdb.alias[1]:             4294967295 ; 0x048: 0xffffffff
kfffdb.strpwdth:                      8 ; 0x04c: 0x08
kfffdb.strpsz:                       20 ; 0x04d: 0x14
kfffdb.usmsz:                         0 ; 0x04e: 0x0000
kfffdb.crets.hi:               32999496 ; 0x050: HOUR=0x8 DAYS=0x2 MNTH=0x2 YEAR=0x7de
kfffdb.crets.lo:              988212224 ; 0x054: USEC=0x0 MSEC=0x1bb SECS=0x2e MINS=0xe
kfffdb.modts.hi:               32999500 ; 0x058: HOUR=0xc DAYS=0x2 MNTH=0x2 YEAR=0x7de
kfffdb.modts.lo:                      0 ; 0x05c: USEC=0x0 MSEC=0x0 SECS=0x0 MINS=0x0
kfffdb.dasz[0]:                       0 ; 0x060: 0x00
kfffdb.dasz[1]:                       2 ; 0x061: 0x02
kfffdb.dasz[2]:                       4 ; 0x062: 0x04
kfffdb.dasz[3]:                       0 ; 0x063: 0x00
kfffdb.permissn:                      0 ; 0x064: 0x00
kfffdb.ub1spar1:                      0 ; 0x065: 0x00
kfffdb.ub2spar2:                      0 ; 0x066: 0x0000
kfffdb.user.entnum:                   0 ; 0x068: 0x0000
kfffdb.user.entinc:                   0 ; 0x06a: 0x0000
kfffdb.group.entnum:                  0 ; 0x06c: 0x0000
kfffdb.group.entinc:                  0 ; 0x06e: 0x0000

/* -------------------------------- kfdasz --------------------------------- */
/*
  NAME
    kfdasz - Kernel Files Disk Au SiZe.

  DESCRIPTION
    Enumerates the possible AU size multiples which may be used for
    Multi-AU "buddied" extents.

  NOTES
    The AU size multiple value may be determined by using the
    KFDASZ_VALUE macro.
*/
#ifndef KFDASZ_1X
/* 10g had space for four sizes, but only 1x was used. The remaining sizes
 * are new in 11, but 10g never references them, so it is safe to change the
 * values
 */
#define KFDASZ_1X      ((kfdasz)0)      /*    1x AU size                     */
#define KFDASZ_2X      ((kfdasz)1)      /*    2x AU size                     */
#define KFDASZ_4X      ((kfdasz)2)      /*    4x AU size                     */
#define KFDASZ_8X      ((kfdasz)3)      /*    8x AU size                     */
#define KFDASZ_16X     ((kfdasz)4)      /*   16x AU size                     */
#define KFDASZ_32X     ((kfdasz)5)      /*   32x AU size                     */
#define KFDASZ_64X     ((kfdasz)6)      /*   64x AU size                     */
#define KFDASZ_LAST    ((kfdasz)7)      /*   First unused value 11g          */
#define KFDASZ_LAST_10 ((kfdasz)4)      /*   First unused value 10g          */
#define KFDASZ_VALUE(x) ((ub1)(1 << (x)))
#endif /* KFDASZ_1X */

 

An extent is composed of one or more allocation units (AUs). An extent can be 1 AU, 4 AUs, 16 AUs, or 64 AUs. The extent size is encoded in two bits of the flags field as a kfdasz enumeration.

 

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Trackbacks

  1. […] 数据盘区Data Extents 是裸的存储,用以存放文件内容。每一个Data Extent在 11g之前对应某一个ASM disk上的一个Allocation Unit , 在11g之后 一个Extent可以对应多个AU,具体见《【Oracle ASM】Variable Extent Size 原理》。 […]

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569