ASM data extent VS tablespace extent
来源:互联网 发布:怎样做淘宝淘宝课程 编辑:程序博客网 时间:2024/05/20 06:08
Please don't mix oracle extent with the data extents concepts being used here, see http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/ostmg_gloss.htm#BABFCABI
I presume that you know about the concepts of tablespace extents (YOu can have uniform size of auto or also different size). These are intra-tablespace space management. For data extents described here, you can compare it with OS block in normal file system and each allocation using of ASM consists of one or more data extents (not tablespace extents).
I presume that you know about the concepts of tablespace extents (YOu can have uniform size of auto or also different size). These are intra-tablespace space management. For data extents described here, you can compare it with OS block in normal file system and each allocation using of ASM consists of one or more data extents (not tablespace extents).
So my question is that how can i have tablespaces with uniform extent size of say 100M on ASM? If so, will ASM further breakdown the extent sizes to its default AU size?Just ike as you can use same tablespace extents size of 100 MB on a regular file system of OS block of 512 byte or 2k, or 4k (or whatever). In this case your database will want to write to allocate an extent of 100MB and then ASM will take over the responsibility that how it will physically store this 100MB extent on disk group by allocating Allocation unit. If on that disk group, your this 100MB extent is required to be allocated on an extent set(set of data extents) number 20001, and your allocation unit size for ASM is 1 MB, it will allocate 8*1 size ASM file extent and total around 13 extents (13*8 = 104 MB) so that your 100MB tablespace extent could be stored.
0 0
- ASM data extent VS tablespace extent
- block,extent,segment,tablespace
- Extent
- extent
- Oracle Block Extent Segment Tablespace
- 【tablespace】一图搞懂extent,segment,block
- Temporary Tablespace AND the Sort Extent Pool
- 如何评估temporary tablespace的extent size??
- 如何调整temporary tablespace的extent size
- 表空间(tableSpace) 段(segment) 盘区(extent) 块(block) 关系
- 表空间(tableSpace) 段(segment) 盘区(extent) 块(block) 关系
- 表空间(tableSpace) 段(segment) 盘区(extent) 块(block) 关系
- 表空间(tableSpace) 段(segment) 盘区(extent) 块(block) 关系
- 表空间(tableSpace) 段(segment) 盘区(extent) 块(block) 关系
- 表空间(tableSpace) 段(segment) 盘区(extent) 块(block) 关系
- extent C
- extent说明
- Oracle extent
- easyui切换主题
- ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using passwor
- Dictionary的初始化
- 第8周项目1-1实现复数类中的运算符重载
- 阿里云服务器nginx多tomcat跳转配置
- ASM data extent VS tablespace extent
- 第四章 基于对象的编程风格(如何实现一个class)
- OpenGL--模板测试
- oracle转mysql
- PHP编码规范
- CentOS配置YUM源(163、搜狐)
- 快速建立个性化网站【凡科建站】
- Golang channels tutorial
- 习惯养成是长期留存用户的关键