File Types Supported by ASM

Now that the basics have been reviewed, the next topics to explore are the v$ and dba_hist views that help monitor ASM.

Dynamic Performance Views on ASM

The following views are useful to get more information on Automatic Storage Management. These views are available in the ASM instance as well as database instances. The views in ASM instances will be introduced and compared with database instances. 

v$asm_diskgroup – has information about disk groups in an ASM instance. In a database instance, it has one row for every mounted ASM disk group.

Column	Description
GROUP_NUMBER	Cluster-wide number for the disk group
NAME	disk group's name
SECTOR_SIZE	Physical block size in bytes
BLOCK_SIZE	ASM metadata block size in bytes
ALLOCATION_UNIT_SIZE	Allocation unit size in bytes
STATE	State of the disk group relative to the database instance - CONNECTED, BROKEN, UNKNOWN, MOUNTED, DISMOUNTED
TYPE	Redundancy type - NORMAL, HIGH, EXTERN
TOTAL_MB	Total disk group capacity in megabytes
FREE_MB	Unused capacity in megabytes