V$ASM_ATTRIBUTE displays one row for each attribute defined. In addition to attributes specified by CREATE DISKGROUP and ALTER DISKGROUP statements, the view may show other attributes that are created automatically. Note that attributes are only displayed for disk groups where COMPATIBLE.ASM is set to 11.1 or higher.
| Column | Datatype | Description |
|---|---|---|
NAME |
VARCHAR2(256) |
Full name of the attribute |
VALUE |
VARCHAR2(256) |
Value of the attribute |
GROUP_NUMBER |
NUMBER |
Number of the disk group in which this attribute exists (composite primary key) |
ATTRIBUTE_INDEX |
NUMBER |
Number of this attribute in the disk group (composite primary key) |
ATTRIBUTE_INCARNATION |
NUMBER |
Incarnation number for this attribute (composite primary key) |
READ_ONLY |
VARCHAR2(7) |
Indicates whether the attribute is read-only (Y) or not (N) |
SYSTEM_CREATED |
VARCHAR2(7) |
Indicates whether this is a system-created attribute (Y) or not (N) |
See Also:
Oracle Automatic Storage Management Administrator's Guide for more information about viewing ASM disk group attributes using this view