../E40402-16.epub /> ../E40402-16.mobi />

DBA_STREAMS_TP_COMPONENT

DBA_STREAMS_TP_COMPONENT displays information about each Oracle Streams component at each database.

Column Datatype NULL Description
COMPONENT_ID NUMBER NOT NULL 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:
  • CAPTURE

  • PROPAGATION SENDER

  • PROPAGATION RECEIVER

  • APPLY

  • QUEUE

COMPONENT_CHANGED_TIME DATE   Time that the Streams component was last changed