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

VIEW: SYS._DBA_STREAMS_COMPONENT_EVENT

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

DBA Streams Component Event

[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
SUB_COMPONENT_TYPE NUMBER

STAT_TIME DATE

Time that statistics were taken
SESSION_ID NUMBER

Session ID of the component
SESSION_SERIAL# NUMBER

Session serial number of the component
EVENT VARCHAR2 (64)
Description of the event of the component
EVENT_COUNT NUMBER

The number of times that this event has appeared so far
TOTAL_COUNT NUMBER

The total number of events
MODULE_NAME VARCHAR2 (64)
Name of the module where the event occurs
ACTION_NAME VARCHAR2 (64)
Name of the action where the event occurs
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 VARCHAR2 (589)
SPARE4 DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COMPONENT_NAME
,      COMPONENT_DB
,      COMPONENT_TYPE
,      SUB_COMPONENT_TYPE
,      STAT_TIME
,      SESSION_ID
,      SESSION_SERIAL#
,      EVENT
,      EVENT_COUNT
,      TOTAL_COUNT
,      MODULE_NAME
,      ACTION_NAME
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
FROM SYS._DBA_STREAMS_COMPONENT_EVENT;

Dependencies

[top of page]

SYS._DBA_STREAMS_COMPONENT_EVENT references the following:

SchemaSYS
ViewDBA_APPLY
TableDUAL
ViewGLOBAL_NAME
PL/SQL PackageUTL_RAW - show dependent code
TableXSTREAM$_SERVER
View_GV$SXGG_APPLY_COORDINATOR
View_GV$SXGG_APPLY_READER
View_GV$SXGG_APPLY_SERVER
View_GV$SXGG_CAPTURE
SYS._DBA_STREAMS_COMPONENT_EVENT is referenced by following:

SchemaPUBLIC
Synonym_DBA_STREAMS_COMPONENT_EVENT
SchemaSYS
Package BodyDBMS_STREAMS_ADV_ADM_UTL - show dependent code
Package BodyDBMS_STREAMS_ADV_ADM_UTL_INVOK - show dependent code