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

VIEW: SYS._DBA_STREAMS_COMPONENT_STAT

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

DBA Streams Component Statistics

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

SYS._DBA_STREAMS_COMPONENT_STAT references the following:

SchemaSYS
TableAQ$_SCHEDULES
ViewDBA_SCHEDULER_JOBS
PL/SQL PackageDBMS_SCHEDULER - show dependent code
ViewGLOBAL_NAME
TableOBJ$
TableSTREAMS$_APPLY_PROCESS
TableSTREAMS$_CAPTURE_PROCESS
TableUSER$
PL/SQL PackageUTL_RAW - show dependent code
View_GV$SXGG_APPLY_COORDINATOR
View_GV$SXGG_APPLY_READER
View_GV$SXGG_APPLY_SERVER
View_GV$SXGG_CAPTURE
SchemaSYSTEM
TableAQ$_QUEUES
SYS._DBA_STREAMS_COMPONENT_STAT is referenced by following:

SchemaPUBLIC
Synonym_DBA_STREAMS_COMPONENT_STAT
SchemaSYS
Package BodyDBMS_STREAMS_ADV_ADM_UTL_INVOK - show dependent code