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
CREATE DISKGROUP and ALTER DISKGROUP statements, 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 as
V$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.
|