Several data dictionary views exist to help manage ASM. These data dictionary views are available both when connected to the ASM instance as well as any Oracle 10g database. Each view is slightly different in its presentation depending on whether the instance you are looking at is an ASM instance or a database instance (and some views are only used in the ASM instance). The table below shows these views.

View Name Description
V$ASM_DISKGROUP

In an ASM Instance: This view will describe a given disk group.

In a Database: This view contains a single row for each ASM disk group that is mounted by the local ASM instance.

Note that discovery will occur each time query this view. This can have performance impacts.

V$ASM_DISK

In an ASM Instance: This view describes each disk that was discovered by the ASM instance. All disks are reported, even those not assigned to disk groups.

In a Database: This view describes each disk that is assigned to that database.

Note that discovery will occur each time query this view. This can have performance impacts.

V$ASM_DISKGROUP_STAT

This view is equivalent to the V$ASM_DISKGROUPSview. However, this view will not cause discovery to occur. This can help with performance, but the data in the view may not be accurate.

V$ASM_FILE

In an ASM Instance: Displays each ASM file contained in the ASM instance.

In a Database: Not used in a database instance.

V$ASM_DISK_STAT This view is equivalent to the V$ASM_DISK view. However, this view will not cause discovery to occur. This can help with performance, but the data in the view may not be accurate.
V$ASM_TEMPLATE

In an ASM Instance: Displays each ASM template contained in the ASM instance by disk group.

In a Database: Not used in a database instance.

V$ASM_ALIAS

In an ASM Instance: Displays each alias contained in the ASM instance by disk group.

In a Database: Not used in a database instance.

V$ASM_OPERATION

In an ASM Instance: Displays each long running operation occurring on the ASM instance.

In a Database: Not used in a database instance

V$ASM_CLIENT

In an ASM Instance: Displays each database that is using at least one disk group managed by the ASM instance.

In a Database: Not used in a database instance.