eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.V_$ASM_DISK

Object Details

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

[View Source]

Columns

Name	Datatype	Length
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

Query Text

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;

Dependencies

[top of page]

SYS.V_$ASM_DISK references the following:

SYS.V_$ASM_DISK is referenced by following:

PUBLIC: V$ASM_DISK