[Home] [Help] [Dependency Information]
Object Name: | _DBA_STREAMS_COMPONENT_STAT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
DBA Streams Component Statistics
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPONENT_NAME | VARCHAR2 | (261) | Name of the streams component | |
COMPONENT_DB | VARCHAR2 | (4000) | Database on which the streams component resides | |
COMPONENT_TYPE | NUMBER | Type of the streams component | ||
STAT_TIME | DATE | Time that statistics were taken | ||
COUNT1 | NUMBER | First count, dependent on the type of the component | ||
COUNT2 | NUMBER | Second count, dependent on the type of the component | ||
COUNT3 | NUMBER | Third count, dependent on the type of the component | ||
COUNT4 | NUMBER | Fourth count, dependent on the type of the component (Spare Column) | ||
LATENCY | NUMBER | Latency of the component | ||
STATUS | NUMBER | Status of the component | ||
SPARE1 | NUMBER | |||
SPARE2 | NUMBER | |||
SPARE3 | VARCHAR2 | (0) | ||
SPARE4 | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT COMPONENT_NAME
, COMPONENT_DB
, COMPONENT_TYPE
, STAT_TIME
, COUNT1
, COUNT2
, COUNT3
, COUNT4
, LATENCY
, STATUS
, SPARE1
, SPARE2
, SPARE3
, SPARE4
FROM SYS._DBA_STREAMS_COMPONENT_STAT;
|
|
|