1. Database Reference
  2. Dynamic Performance Views
  3. Dynamic Performance (V$) Views: V$ACCESS to V$HVMASTER_INFO
  4. V$ASM_VOLUME

7.71 V$ASM_VOLUME

In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_VOLUME displays information about each Oracle ADVM volume.

Column Datatype Description

GROUP_NUMBER

NUMBER

Cluster-wide number assigned to the disk group (composite primary key)

VOLUME_NAME

VARCHAR2(30)

Name of the volume

COMPOUND_INDEX

NUMBER

A 32-bit number consisting of a disk group number in the high-order 8 bits and a volume number in the low-order 24 bits (for efficient access to the view)

SIZE_MB

NUMBER

Size of the volume (in megabytes)

VOLUME_NUMBER

NUMBER

Number of the Volume within the disk group (composite primary key)

REDUNDANCY

VARCHAR2(6)

Redundancy type for the volume:

  • UNPROT

  • HIGH

  • MIRROR

STRIPE_COLUMNS

NUMBER

Number of columns in a stripe set

STRIPE_WIDTH_K

NUMBER

Stripe width of the volume (in kilobytes)

STATE

VARCHAR2(8)

Indicates whether the volume is enabled (ENABLED), disabled (DISABLED), or remote (REMOTE)

FILE_NUMBER

NUMBER

Volume file number

INCARNATION

NUMBER

Volume file incarnation number

DRL_FILE_NUMBER

NUMBER

Volume Dirty Region Logging (DRL) file used for mirrored volumes

RESIZE_UNIT_MB

NUMBER

Volume allocation unit (in megabytes) that a volume can be created

USAGE

VARCHAR2(30)

Optional usage string for the volume

VOLUME_DEVICE

VARCHAR2(256)

OSD path for the volume device

MOUNTPATH

VARCHAR2(1024)

Optional mount path string for the volume

PRIMARY_REGION

VARCHAR2(4)

Region used for allocating primary extents:

  • HOT

  • COLD

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

MIRROR_REGION

VARCHAR2(4)

Region used for allocating mirrored extents:

  • HOT

  • COLD

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).

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.

See Also:

Oracle Automatic Storage Management Administrator's Guide for additional information about using views to display Oracle ASM information