Using V$ASM_DISK_SPARSE and V$ASM_DISKGROUP_SPARSE to Monitor Sparse Disks

Previous Next JavaScript must be enabled to correctly display this content

C.1.4 Using V$ASM_DISK_SPARSE and V$ASM_DISKGROUP_SPARSE to Monitor Sparse Disks

The V$ASM_DISK_SPARSE and V$ASM_DISKGROUP_SPARSE views contain information about sparse disks.

Table C-3 V$ASM_DISK_SPARSE Columns and Descriptions

Column	Description
GROUP_NUMBER	The number of the disk group containing the disk.
`DISK_NUMBER`	The number assigned to the disk within this disk group.
`INCARNATION`	The incarnation number for the disk.
`ALLOCATED_MAT_MB`	The total used physical and materialized capacity on the disk.
`TOTAL_MAT_MB`	The total physical capacity on the disk.
`SPARSE_READS`	The total number of I/O read requests on non-materialized regions of the disk.
`SPARSE_BYTES_READ`	The total number of bytes read from non-materialized regions of the disk.
`SPARSE_READ_TIME`	The time taken by sparse read I/O operations.

Table C-4 V$ASM_DISKGROUP_SPARSE Columns and Descriptions

Column	Description
`GROUP_NUMBER`	The cluster-wide number assigned to the disk group.
`ALLOCATED_MAT_MB`	The total used physical and materialized capacity of the disk group.
`TOTAL_MAT_MB`	The total physical capacity of the disk group.

Parent topic: Oracle Database Dictionary Views