DBA Data[Home] [Help]

VIEW: SYS.V_$ASM_DISK_SPARSE

Source

View Text - Preformatted

SELECT "GROUP_NUMBER","DISK_NUMBER","COMPOUND_INDEX","INCARNATION","ALLOCATED_MAT_MB","TOTAL_MAT_MB","SPARSE_READS","SPARSE_READ_TIME","SPARSE_BYTES_READ","CON_ID" FROM v$asm_disk_sparse
View Text - HTML Formatted

SELECT "GROUP_NUMBER"
, "DISK_NUMBER"
, "COMPOUND_INDEX"
, "INCARNATION"
, "ALLOCATED_MAT_MB"
, "TOTAL_MAT_MB"
, "SPARSE_READS"
, "SPARSE_READ_TIME"
, "SPARSE_BYTES_READ"
, "CON_ID"
FROM V$ASM_DISK_SPARSE