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

VIEW: SYS.CDB_STREAMS_TP_COMPONENT_STAT

Object Details
Object Name: CDB_STREAMS_TP_COMPONENT_STAT
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

DBA Streams Component Statistics in all containers

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

SYS.CDB_STREAMS_TP_COMPONENT_STAT does not reference any database object

SYS.CDB_STREAMS_TP_COMPONENT_STAT is referenced by following:

SchemaPUBLIC
SynonymCDB_STREAMS_TP_COMPONENT_STAT