Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_STREAMS_TP_COMPONENT_STAT

DBA_STREAMS_TP_COMPONENT_STAT displays temporary performance statistics and session statistics about each Oracle Streams component.

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

SUB_COMPONENT_TYPE VARCHAR2(27)   Type of the Streams subcomponent:
  • LOGMINER READER

  • LOGMINER PREPARER

  • LOGMINER BUILDER

  • CAPTURE SESSION

  • PROPAGATION SENDER+RECEIVER

  • APPLY READER

  • APPLY COORDINATOR

  • APPLY SERVER

SESSION_ID NUMBER   ID of the Streams session for the Streams component
SESSION_SERIAL# NUMBER   Serial number 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 NUMBER   Value of the statistic
STATISTIC_UNIT VARCHAR2(64)   Unit of the statistic
ADVISOR_RUN_ID NUMBER   Logical number (1-based) of the Advisor run
ADVISOR_RUN_TIME DATE   Time that the Advisor was run