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

Last updated on MARCH 05, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms