A few new dynamic performance views are associated with ASM instances. The contents of these views vary depending on whether they are displaying data for an ASM instance or a standard, non-ASM (RDBMS) instance. Table 9.2 contains the common ASM-related dynamic performance views.
NOTE
We'll provide further explanation for some of these views where appropriate later in this chapter.
View Name | Contents In ASM Instance | Contents In RDBMS Instance |
---|---|---|
V$ASM_DISK | One row for each disk discovered by an ASM instance, whether used by a disk group or not | One row for each disk in use by the instance |
V$ASM_DISKGROUP | One row for each disk group containing general characteristics of the disk group | One row for each disk group in use, whether mounted or not |
V$ASM_FILE | One row for each file in every mounted disk group | Not used |
V$ASM_OPERATION | One row for each executing, longrunning operation (ADD, DROP, RESIZE, or REBALANCE) in the ASM instance | Not used |
V$ASM_TEMPLATE | One row for each template in each mounted disk group in the ASM instance | One row for each template for each mounted disk group |
V$ASM_CLIENT | One row for each database using disk groups managed by the ASM instance | One row for the ASM instance if any ASM files are open |
V$ASM_ALIAS | One row for every alias in every mounted disk group | Not used |