ASM view

• V$ASM_ALIAS: In the ASM instance, this view lists all aliases in all currently mounted disk
groups. It is not used in the database instance.
• V$ASM_CLIENT: In the ASM instance, V$ASM_CLIENT lists all client databases currently accessing
disk groups. In the database instance, it contains one row for the ASM instance, if the data-
base has any currently open ASM files.
• V$ASM_DISK: In the ASM instance, V$ASM_DISK lists all disks discovered by the ASM instance. In
the database instance, it contains one row for each disk in disk groups currently in use by the
database instance.
• V$ASM_DISKGROUP: In the ASM instance, this view lists all disk groups discovered by the instance.
In the database instance, it lists all disk groups currently in use by the instance.
• V$ASM_FILE: In the ASM instance, all ASM files belonging to disk groups mounted by the ASM
instance are listed by this view. It is not used in the database instance.
• V$ASM_OPERATION: In the ASM instance, this view shows information about any long-running
operations, such as rebalancing, and it is not used in the database instance.
• V$ASM_TEMPLATE: In the ASM instance, V$AM_TEMPLATE shows all templates for all disk groups
currently mounted by the instance. In the database instance, it lists all templates for disk
groups currently in use by the instance.
Oracle 10.2 or above also includes the two following additional dynamic performance views:
• V$ASM_DISKGROUP_STAT: In the ASM instance, this view provides the same information as
V$ASM_DISKGROUP, but it does not discover new disk groups.
• V$ASM_DISK_STAT: This view provides the same information as V$ASM_DISK in the ASM
instance, but it does not discover new disks.