View/Description V$ASM_DISKGROUP Describes a disk group (number, name, size related info, state, and redundancy type) V$ASM_DISK Contains one row for every disk discovered by the ASM instance, including disks that are not part of any disk group. V$ASM_DISKGROUP_STAT Has the same columns as V$ASM_DISKGROUP, but to reduce overhead, does not perform a discovery when it is queried. V$ASM_DISK_STAT Has the same columns as V$ASM_DISK, but to reduce overhead, does not perform a discovery when it is queried. V$ASM_FILE Contains one row for every ASM file in every disk group mounted by the ASM instance. V$ASM_TEMPLATE Contains one row for every template present in every disk group mounted by the ASM V$ASM_ALIAS Contains one row for every alias present in every disk group mounted by the ASM V$ASM_OPERATION Contains one row for every active ASM long running operation executing in the ASM V$ASM_CLIENT identifies databases using disk groups managed by the ASM instance |