Tuesday, November 25, 2014

ASM views

View
Description
V$ASM_ALIAS
In an ASM instance, contains one row for every alias present in every disk group mounted by the ASM instance.
In a DB instance, contains no rows.
V$ASM_ATTRIBUTE
Displays one row for each attribute defined. In addition to attributes specified by CREATEDISKGROUP and ALTERDISKGROUPstatements, 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.
V$ASM_CLIENT
In an ASM instance, identifies databases using disk groups managed by the ASM instance.
In a DB instance, contains information about the ASM instance if the database has any open ASM files.
V$ASM_DISK
In an ASM instance, contains one row for every disk discovered by the ASM instance, including disks that are not part of any disk group.
In a DB instance, contains rows only for disks in the disk groups in use by that DB instance.
This view performs disk discovery every time it is queried.
V$ASM_DISK_IOSTAT
Displays information about disk I/O statistics for each ASM client.
In a DB instance, only the rows for that instance are shown.
V$ASM_DISK_STAT
In an ASM instance, contains the same columns as V$ASM_DISK, but to reduce overhead, does not perform a discovery when it is queried. It does not return information about any disks that are new to the storage system. For the most accurate data, useV$ASM_DISK instead.
V$ASM_DISKGROUP
In an ASM instance, describes a disk group (number, name, size related info, state, and redundancy type).
In a DB instance, contains one row for every ASM disk group mounted by the local ASM instance.
This view performs disk discovery every time it is queried.
V$ASM_DISKGROUP_STAT
In an ASM instance, contains the same columns asV$ASM_DISKGROUP, but to reduce overhead, does not perform a discovery when it is queried. It does not return information about any disks that are new to the storage system. For the most accurate data, use V$ASM_DISKGROUP instead.
V$ASM_FILE
In an ASM instance, contains one row for every ASM file in every disk group mounted by the ASM instance.
In a DB instance, contains no rows.
V$ASM_OPERATION
In an ASM instance, contains one row for every active ASM long running operation executing in the ASM instance.
In a DB instance, contains no rows.
V$ASM_TEMPLATE
In an ASM or DB instance, contains one row for every template present in every disk group mounted by the ASM instance.