V$ASM_DISK Contains one row for every disk discovered by the Oracle ASM instance, including disks that are not part of any disk group.This view performs disk discovery every time it is queried.
V$ASM_DISK_IOSTAT
Displays information about disk I/O statistics for each Oracle ASM client.In an Oracle Database instance, only the rows for that instance are shown.
V$ASM_DISK_STAT
Contains the same columns as V$ASM_DISK, but to reduce overhead,does not perform a discovery when it is queried. It only returns information about any disks that are part of mounted disk groups in the storage system. To see all disks, use V$ASM_DISK instead.
V$ASM_DISKGROUP
Describes a disk group (number, name, size related info, state, and redundancy type).This view performs disk discovery every time it is queried.
V$ASM_DISKGROUP_STAT
Contains the same columns as V$ASM_DISKGROUP, but to reduce overhead, this view does not perform a discovery when it is queried.To see more complete information on all disks, use V$ASM_DISKGROUP.
V$ASM_ESTIMATE
Displays an estimate of the work involved in execution plans for Oracle ASM disk group rebalance and resync operations.
V$ASM_FILE
Contains one row for every Oracle ASM file in every disk group mounted by the Oracle ASM instance.
V$ASM_OPERATION
In an Oracle ASM instance, contains one row for every active Oracle ASM long running operation executing in the Oracle ASM instance.In an Oracle Database instance, contains no rows.
V$ASM_TEMPLATE
Contains one row for every template present in every disk group mounted by the Oracle ASM instance.
V$ASM_USER
Contains the effective operating system user names of connected database instances and names of file owners.
V$ASM_USERGROUP
Contains the creator for each Oracle ASM File Access Control group.
V$ASM_USERGROUP_MEMBER
Contains the members for each Oracle ASM File Access Control group.
V$ASM_DISK_IOSTAT
Displays information about disk I/O statistics for each Oracle ASM client.In an Oracle Database instance, only the rows for that instance are shown.
V$ASM_DISK_STAT
Contains the same columns as V$ASM_DISK, but to reduce overhead,does not perform a discovery when it is queried. It only returns information about any disks that are part of mounted disk groups in the storage system. To see all disks, use V$ASM_DISK instead.
V$ASM_DISKGROUP
Describes a disk group (number, name, size related info, state, and redundancy type).This view performs disk discovery every time it is queried.
V$ASM_DISKGROUP_STAT
Contains the same columns as V$ASM_DISKGROUP, but to reduce overhead, this view does not perform a discovery when it is queried.To see more complete information on all disks, use V$ASM_DISKGROUP.
V$ASM_ESTIMATE
Displays an estimate of the work involved in execution plans for Oracle ASM disk group rebalance and resync operations.
V$ASM_FILE
Contains one row for every Oracle ASM file in every disk group mounted by the Oracle ASM instance.
V$ASM_OPERATION
In an Oracle ASM instance, contains one row for every active Oracle ASM long running operation executing in the Oracle ASM instance.In an Oracle Database instance, contains no rows.
V$ASM_TEMPLATE
Contains one row for every template present in every disk group mounted by the Oracle ASM instance.
V$ASM_USER
Contains the effective operating system user names of connected database instances and names of file owners.
V$ASM_USERGROUP
Contains the creator for each Oracle ASM File Access Control group.
V$ASM_USERGROUP_MEMBER
Contains the members for each Oracle ASM File Access Control group.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27799221/viewspace-2128721/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27799221/viewspace-2128721/