V$ASM_ATTRIBUTE

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)
CON_ID NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

For this view, the value is always 0.

Note: In an Oracle AI Database instance, this view returns 0 rows when queried from a PDB.

See Also: