[Home] [Help] [Dependency Information]
Object Name: | V_$ASM_DISK_STAT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_NUMBER | NUMBER | |||
DISK_NUMBER | NUMBER | |||
COMPOUND_INDEX | NUMBER | |||
INCARNATION | NUMBER | |||
MOUNT_STATUS | VARCHAR2 | (7) | ||
HEADER_STATUS | VARCHAR2 | (12) | ||
MODE_STATUS | VARCHAR2 | (7) | ||
STATE | VARCHAR2 | (8) | ||
REDUNDANCY | VARCHAR2 | (7) | ||
LIBRARY | VARCHAR2 | (64) | ||
OS_MB | NUMBER | |||
TOTAL_MB | NUMBER | |||
FREE_MB | NUMBER | |||
HOT_USED_MB | NUMBER | |||
COLD_USED_MB | NUMBER | |||
NAME | VARCHAR2 | (30) | ||
FAILGROUP | VARCHAR2 | (30) | ||
LABEL | VARCHAR2 | (31) | ||
PATH | VARCHAR2 | (256) | ||
UDID | VARCHAR2 | (64) | ||
PRODUCT | VARCHAR2 | (32) | ||
CREATE_DATE | DATE | |||
MOUNT_DATE | DATE | |||
REPAIR_TIMER | NUMBER | |||
READS | NUMBER | |||
WRITES | NUMBER | |||
READ_ERRS | NUMBER | |||
WRITE_ERRS | NUMBER | |||
READ_TIMEOUT | NUMBER | |||
WRITE_TIMEOUT | NUMBER | |||
READ_TIME | NUMBER | |||
WRITE_TIME | NUMBER | |||
BYTES_READ | NUMBER | |||
BYTES_WRITTEN | NUMBER | |||
PREFERRED_READ | VARCHAR2 | (1) | ||
HASH_VALUE | NUMBER | |||
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 | |||
VOTING_FILE | VARCHAR2 | (1) | ||
SECTOR_SIZE | NUMBER | |||
FAILGROUP_TYPE | VARCHAR2 | (7) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_NUMBER
, DISK_NUMBER
, COMPOUND_INDEX
, INCARNATION
, MOUNT_STATUS
, HEADER_STATUS
, MODE_STATUS
, STATE
, REDUNDANCY
, LIBRARY
, OS_MB
, TOTAL_MB
, FREE_MB
, HOT_USED_MB
, COLD_USED_MB
, NAME
, FAILGROUP
, LABEL
, PATH
, UDID
, PRODUCT
, CREATE_DATE
, MOUNT_DATE
, REPAIR_TIMER
, READS
, WRITES
, READ_ERRS
, WRITE_ERRS
, READ_TIMEOUT
, WRITE_TIMEOUT
, READ_TIME
, WRITE_TIME
, BYTES_READ
, BYTES_WRITTEN
, PREFERRED_READ
, HASH_VALUE
, HOT_READS
, HOT_WRITES
, HOT_BYTES_READ
, HOT_BYTES_WRITTEN
, COLD_READS
, COLD_WRITES
, COLD_BYTES_READ
, COLD_BYTES_WRITTEN
, VOTING_FILE
, SECTOR_SIZE
, FAILGROUP_TYPE
, CON_ID
FROM SYS.V_$ASM_DISK_STAT;
|
|
|