[Home] [Help] [Dependency Information]
Object Name: | CDB_STREAMS_TP_COMPONENT_STAT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
DBA Streams Component Statistics in all containers
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 | ||
CON_ID | NUMBER | container id |
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
, CON_ID
FROM SYS.CDB_STREAMS_TP_COMPONENT_STAT;
SYS.CDB_STREAMS_TP_COMPONENT_STAT does not reference any database object
SYS.CDB_STREAMS_TP_COMPONENT_STAT is referenced by following:
|
|
|