[Home] [Help] [Dependency Information]
Object Name: | _DBA_STREAMS_COMPONENT_EVENT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
DBA Streams Component Event
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 |
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;
|
|
|