DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.V_$ASM_DISK_SPARSE_STAT

Object Details
Object Name: V_$ASM_DISK_SPARSE_STAT
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_NUMBER NUMBER

DISK_NUMBER NUMBER

COMPOUND_INDEX NUMBER

INCARNATION NUMBER

ALLOCATED_MAT_MB NUMBER

TOTAL_MAT_MB NUMBER

SPARSE_READS NUMBER

SPARSE_READ_TIME NUMBER

SPARSE_BYTES_READ NUMBER

CON_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


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 SYS.V_$ASM_DISK_SPARSE_STAT;

Dependencies

[top of page]

SYS.V_$ASM_DISK_SPARSE_STAT references the following:

SYS.V_$ASM_DISK_SPARSE_STAT is referenced by following:

SchemaPUBLIC
SynonymV$ASM_DISK_SPARSE_STAT