DBA Data[Home] [Help]

VIEW: SYS.GV_$ASM_DISK_SPARSE

Source

View Text - Preformatted

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

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