ASM Dynamic Performance Views

We are going to have look at the ASM Dynamic Performance Views.  In the database, we have learned about views. Here we are going to focus on ASM Dynamic Performance Views. As we know An ASM instance does not have a data dictionary. The information relating to its configuration and operation is available by querying a set of dynamic performance views.

ASM dynamic performance view use prefix  V$ASM .  we can query using SQL in the same manner as any database dynamic performance views. In the clustered environment we use $GASM views. It provides a consolidated view of information across all the current running clustered ASM instances.

List of ASM Dynamic Performance Views are mention below:-

V$ASM_ALIAS:-  V$ASM_ALIAS displays one row for every alias present in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_ALIAS displays no rows.

V$ASM_DISK:-It displays one row for every disk discovered by the Automatic Storage Management instance, including disks which are not part of any disk group. In a database instance, V$ASM_DISK only displays rows of disks in disk groups in use by the database instance.

V$ASM_DIASKGROUP:-V$ASM_DISKGROUP displays one row for every ASM disk group discovered by the ASM instance on the node.

V$ASM_OPERATION:- One row for every active Automatic Storage Management long running operation executing in the Automatic Storage Management instance. In a database instance, V$ASM_OPERATION displays no rows.

V$ASM_FILESYSTEM:-V$ASM_FILESYSTEM displays information for every mounted Oracle ACFS.

V$ASM_ATTRIBUTE:- V$ASM_ATTRIBUTE displays one row for each attribute defined. In addition to attributes specified by CREATE DISKGROUP and ALTER DISKGROUP statements, the view may show other attributes that are created automatically.

V$ASM_DISK_IOSTAT:-This provides information about disk I/O statistics for each ASM client. If this view is queried from the database instance, only the rows for that instance are shown.

V$ASM_DISKGROUP_STAT:- V$ASM_DISKGROUP_STAT provides a way to query performance statistics in the same way that V$ASM_DISKGROUP does, but without performing discovery of new disk groups. This results in a less expensive operation. However, since discovery is not performed, the output of this view does not include any data about disk groups that are new to the system.

V$ASM_TEMPLATE:- V$ASM_TEMPLATE displays one row for every template present in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_TEMPLATE displays one row for every template present in every disk group mounted by the Automatic Storage Management instance with which the database instance communicates.
V$ASM_USERGROUP:- V$ASM_USERGROUP displays the creator for each ASM File Access Control group.

V$ASM_CLIENT:-  V$ASM_CLIENT displays one row for every database instance using a disk group managed by the Automatic Storage Management instance. In a database instance, V$ASM_CLIENT displays one row for the Automatic Storage Management instance if the database has open Automatic Storage Management files.

V$ASM_DSIK_STAT:- V$ASM_DISK_STAT provides a way to query performance statistics in the same way that V$ASM_DISK does, but without performing discovery of new disks. This results in a less expensive operation. However, since discovery is not performed, the output of this view does not include any data about disks that are new to the system.

V$ASM_FILE:- In an Automatic Storage Management instance, V$ASM_FILE displays one row for every Automatic Storage Management file in every disk group mounted by the Automatic Storage Management instance. In a database instance, V$ASM_FILE displays no rows.

V$ASM_USER:-V$ASM_USER displays the effective operating system user names of connected database instances and of file owners.

V$ASM_USERGROUP_MEMBER:-V$ASM_USERGROUP_MEMBER displays the members for each ASM File Access Control group.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp