Sunday, June 19, 2011

ASM views on ASM instance after database Installation

I have created new database with ASM based filesystem, I will execute some queries to check the result. The result will be different from my last post ASM views before database installation.

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: