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