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


TABLE: SYS.WRH$_IC_DEVICE_STATS

Object Details
Object Name: WRH$_IC_DEVICE_STATS
Object Type: TABLE
Owner: SYS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceSYSAUX
PCT Free: 10
PCT Used:
Primary Key: WRH$_IC_DEVICE_STATS_PK
  1. ColumnDBID
  2. ColumnSNAP_ID
  3. ColumnINSTANCE_NUMBER
  4. ColumnIF_NAME
  5. ColumnIP_ADDR
  6. ColumnCON_DBID
Indexes
Index Type Uniqueness Tablespace Column
WRH$_IC_DEVICE_STATS_PK NORMAL UNIQUE TablespaceSYSAUX ColumnDBID
ColumnSNAP_ID
ColumnINSTANCE_NUMBER
ColumnIF_NAME
ColumnIP_ADDR
ColumnCON_DBID
Columns
Name Datatype Length Mandatory Comments
SNAP_ID NUMBER
Yes
DBID NUMBER
Yes
INSTANCE_NUMBER NUMBER
Yes
IF_NAME VARCHAR2 (256) Yes
IP_ADDR VARCHAR2 (64) Yes
NET_MASK VARCHAR2 (16)
FLAGS VARCHAR2 (32)
MTU NUMBER

BYTES_RECEIVED NUMBER

PACKETS_RECEIVED NUMBER

RECEIVE_ERRORS NUMBER

RECEIVE_DROPPED NUMBER

RECEIVE_BUF_OR NUMBER

RECEIVE_FRAME_ERR NUMBER

BYTES_SENT NUMBER

PACKETS_SENT NUMBER

SEND_ERRORS NUMBER

SENDS_DROPPED NUMBER

SEND_BUF_OR NUMBER

SEND_CARRIER_LOST NUMBER

CON_DBID NUMBER
Yes
Query Text

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


SELECT SNAP_ID
,      DBID
,      INSTANCE_NUMBER
,      IF_NAME
,      IP_ADDR
,      NET_MASK
,      FLAGS
,      MTU
,      BYTES_RECEIVED
,      PACKETS_RECEIVED
,      RECEIVE_ERRORS
,      RECEIVE_DROPPED
,      RECEIVE_BUF_OR
,      RECEIVE_FRAME_ERR
,      BYTES_SENT
,      PACKETS_SENT
,      SEND_ERRORS
,      SENDS_DROPPED
,      SEND_BUF_OR
,      SEND_CARRIER_LOST
,      CON_DBID
FROM SYS.WRH$_IC_DEVICE_STATS;

Dependencies

[top of page]

SYS.WRH$_IC_DEVICE_STATS does not reference any database object

SYS.WRH$_IC_DEVICE_STATS is referenced by following:

SchemaSYS
ViewINT$DBA_HIST_IC_DEVICE_STATS