[Home] [Help] [Dependency Information]
Object Name: | V_$ASM_DISK_IOSTAT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTNAME | VARCHAR2 | (64) | ||
DBNAME | VARCHAR2 | (8) | ||
CLUSTERNAME | VARCHAR2 | (31) | ||
GROUP_NUMBER | NUMBER | |||
DISK_NUMBER | NUMBER | |||
FAILGROUP | VARCHAR2 | (30) | ||
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 | |||
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 INSTNAME
, DBNAME
, CLUSTERNAME
, GROUP_NUMBER
, DISK_NUMBER
, FAILGROUP
, READS
, WRITES
, READ_ERRS
, WRITE_ERRS
, READ_TIMEOUT
, WRITE_TIMEOUT
, READ_TIME
, WRITE_TIME
, BYTES_READ
, BYTES_WRITTEN
, 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_DISK_IOSTAT;
|
|
|