V$ASM_ALIAS: Displays a row for each alias present in every disk group mounted by the ASM instance.SQL> select * from v$ASM_ALIAS;
V$ASM_CLIENT: Displays a row for each database instance using a disk group managed by the ASM instance.
V$ASM_DISK: Displays a row for each disk discovered by the ASM instance, including disks which are not part of any disk group.
V$ASM_DISKGROUP: Displays a row for each disk group discovered by the ASM instance.V$ASM_FILE: Displays a row for each file for each disk group mounted by the ASM instance.V$ASM_OPERATION: Displays a row for each file for each long running operation executing in the ASM instance.V$ASM_TEMPLATE: Displays a row for each template present in each disk group mounted by the ASM instance.

No comments:
Post a Comment