Virtual Attribute AU_SIZE is not flagged correctly in fixed table x$kfenv when non default size is specified (Doc ID 2090972.1)

Last updated on DECEMBER 25, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Virtual attribute au_size is not flagged correctly in fixed table x$kfenv,
even though the attribute was specified in the command create diskgroup as attribute 'au_size'='4M'.
The attribute is being flagged as DEFAULT (KFE_DEFAULT) in x$kfenv instead of NON DEFAULT.

>>Create diskgroup dg01
normal redundancy
failgroup FG1 disk
' asm_space/file1DG1FG1' name DISK1DG1FG1,
' asm_space/file2DG1FG1' name DISK2DG1FG1
failgroup FG2 disk
' asm_space/file1DG1FG2' name DISK1DG1FG2,
' asm_space/file2DG1FG2' name DISK2DG1FG2
attribute 'compatible.asm'='12.1', 'compatible.rdbms'='12.1',
'au_size'='4M';

>> Query x$kfenv to verify if attribute flagged as DEFAULT OR  NON DEFAULT.

   but  au_size still shows  "DEFAULT"

(THE CORRECT FLAG VALUE SHOULD BE "NON DEFAULT" BECAUSE au_size WAS SPECIFIED IN THE COMMAND CREATE DISKGROUP).

select substr(NAME_KFENV,1,10) ATTRIBUTE,substr(VALUE_KFENV,1,20) VALUE,
FLAGS_KFENV, decode(bitand(flags_kfenv, 2),2,'DEFAULT','NON DEFAULT') as
"default" from x$kfenv
where NAME_KFENV in ('au_size','compatible.asm','compatible.rdbms');

ATTRIBUTE VALUE FLAGS_KFENV default
---------- -------------------- ----------- -----------
au_size 4194304 147 DEFAULT
compatible 12.1.0.0.0 176 NON DEFAULT
compatible 12.1.0.0.0 48 NON DEFAULT

 

Cause

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