[Home] [Help] [Dependency Information]
Object Name: | V_$ASM_FILE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
Cut, paste (and edit) the following text to query this object:
SELECT 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.V_$ASM_FILE;
|
|
|