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

VIEW: SYS.GV_$ASM_FILE

Object Details
Object Name: GV_$ASM_FILE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INST_ID NUMBER

GROUP_NUMBER NUMBER

FILE_NUMBER NUMBER

COMPOUND_INDEX NUMBER

INCARNATION NUMBER

BLOCK_SIZE NUMBER

BLOCKS NUMBER

BYTES NUMBER

SPACE NUMBER

TYPE VARCHAR2 (64)
REDUNDANCY VARCHAR2 (6)
STRIPED VARCHAR2 (6)
CREATION_DATE DATE

MODIFICATION_DATE DATE

REDUNDANCY_LOWERED VARCHAR2 (1)
PERMISSIONS VARCHAR2 (16)
USER_NUMBER NUMBER

USER_INCARNATION NUMBER

USERGROUP_NUMBER NUMBER

USERGROUP_INCARNATION NUMBER

PRIMARY_REGION VARCHAR2 (4)
MIRROR_REGION VARCHAR2 (4)
HOT_READS NUMBER

HOT_WRITES NUMBER

HOT_BYTES_READ NUMBER

HOT_BYTES_WRITTEN NUMBER

COLD_READS NUMBER

COLD_WRITES NUMBER

COLD_BYTES_READ NUMBER

COLD_BYTES_WRITTEN NUMBER

CON_ID NUMBER

Query Text

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


SELECT INST_ID
,      GROUP_NUMBER
,      FILE_NUMBER
,      COMPOUND_INDEX
,      INCARNATION
,      BLOCK_SIZE
,      BLOCKS
,      BYTES
,      SPACE
,      TYPE
,      REDUNDANCY
,      STRIPED
,      CREATION_DATE
,      MODIFICATION_DATE
,      REDUNDANCY_LOWERED
,      PERMISSIONS
,      USER_NUMBER
,      USER_INCARNATION
,      USERGROUP_NUMBER
,      USERGROUP_INCARNATION
,      PRIMARY_REGION
,      MIRROR_REGION
,      HOT_READS
,      HOT_WRITES
,      HOT_BYTES_READ
,      HOT_BYTES_WRITTEN
,      COLD_READS
,      COLD_WRITES
,      COLD_BYTES_READ
,      COLD_BYTES_WRITTEN
,      CON_ID
FROM SYS.GV_$ASM_FILE;

Dependencies

[top of page]

SYS.GV_$ASM_FILE references the following:

SYS.GV_$ASM_FILE is referenced by following:

SchemaPUBLIC
SynonymGV$ASM_FILE