ASM Views

posted Sep 13, 2010, 7:33 AM by Sachchida Ojha
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
Comments