BLOCK_SIZE column in the view v$ asm_diskgroup and the parameter db_block_size is same ? (Doc ID 1966567.1)

Last updated on DECEMBER 21, 2022

Applies to:

Goal

BLOCK_SIZE column in the view v$ asm_diskgroup is the size of  database parameter db_block_size ?

Example -

In specific enviornment the parameter db_block_size is 8192 ,

v$asm_diskgroup showes

select GROUP_NUMBER,NAME,SECTOR_SIZE,BLOCK_SIZE,ALLOCATION_UNIT_SIZE,STATE,TYPE,TOTAL_MB,FREE_MB
from v$asm_diskgroup;
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB
------------ ---------- ----------- ---------- -------------------- ----------- ------ ---------- ----------
  1 DGDATA 512 8192 1048576 CONNECTED EXTERN 1218560 452062

Is the 8192 value is the value of the parameter of the  BLOCK_SIZE column in the view v$ asm_diskgroup" is similar to db_block_size ?

 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.