[Home] [Help] [Dependency Information]
Object Name: | DBA_STREAMS_TP_COMPONENT_STAT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
DBA Streams Component Statistics
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPONENT_ID | NUMBER | Yes | ID of the Streams Component | |
COMPONENT_NAME | VARCHAR2 | (4000) | Name of the Streams Component | |
COMPONENT_DB | VARCHAR2 | (128) | Database Where the Streams Component Resides | |
COMPONENT_TYPE | VARCHAR2 | (20) | Type of the Streams Component | |
SUB_COMPONENT_TYPE | VARCHAR2 | (27) | Type of the Streams Sub-component | |
SESSION_ID | NUMBER | ID of the Streams Session for the Streams Component | ||
SESSION_SERIAL# | NUMBER | Serial# of the Streams Session for the Streams Component | ||
STATISTIC_TIME | DATE | Time That the Statistic Was Taken | ||
STATISTIC_NAME | VARCHAR2 | (64) | Name of the Statistic | |
STATISTIC_VALUE | VARCHAR2 | (4000) | Value of the Statistic | |
STATISTIC_UNIT | VARCHAR2 | (64) | Unit of the Statistic | |
ADVISOR_RUN_ID | NUMBER | 1-based Logical Number of Advisor Run | ||
ADVISOR_RUN_TIME | DATE | Time That the Advisor Was Run |
Cut, paste (and edit) the following text to query this object:
SELECT COMPONENT_ID
, COMPONENT_NAME
, COMPONENT_DB
, COMPONENT_TYPE
, SUB_COMPONENT_TYPE
, SESSION_ID
, SESSION_SERIAL#
, STATISTIC_TIME
, STATISTIC_NAME
, STATISTIC_VALUE
, STATISTIC_UNIT
, ADVISOR_RUN_ID
, ADVISOR_RUN_TIME
FROM SYS.DBA_STREAMS_TP_COMPONENT_STAT;
|
|
|