Wednesday, June 8, 2011

ASM views on ASM Instance before database Installation.

As in my previous post ASM basic configuration I created an ASM instance, now I will execute some queries to get some more detail & get some experience on ASM instance. I have not created database yet, its simple ASM instance creation without having database instance, So queries result can be different from the one with ASM based filesystem. I will create ASM database in my next post.

A very good article has been given on ASM 10g at ORACLE-BASE website, and list of v$views has been given in this article, I will execute them at ASM instance one by one.

The ASM configuration can be viewed using the v$ASM_, which often contain different information depending on whether they are queried from the ASM instance, or a dependent database instance.
















V$ASM_ALIAS : Displays a row for each alias present in every disk group mounted by the ASM instance. Here the ASM_ALIAS will not return any rows, because we have not created any database that use this ASM as filesystem.







V$ASM_CLIENT: Displays a row for each database instance using a disk group managed by the ASM instance.
As we have not created any database yet, who can use this diskgroup (data) in ASM, so query will not result any rows at this time.









V$ASM_DISK : Displays a row for each disk discovered by the ASM instance, including disks which are not part of any disk group.
As, I have created two disks, then query should return two rows for each disk.





V$ASM_DISKGROUP : Displays a row for each disk group discovered by the ASM instance.
I have created only one diskgroup DATA, query should return one row only.







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: