VIEW: SYS.DBA_STREAMS_TP_COMPONENT_STAT

Source

View Text - Preformatted

SELECT C.COMPONENT_ID,
       nvl(C.COMPONENT_NAME, C.SPARE3) COMPONENT_NAME,
       C.COMPONENT_DB,
       decode(C.COMPONENT_TYPE,
              1, 'CAPTURE',
              2, 'PROPAGATION SENDER',
              3, 'PROPAGATION RECEIVER',
              4, 'APPLY',
              5, 'QUEUE',
              6, 'EXTRACT',
              7, 'REPLICAT',
              NULL),
       decode(S.SUB_COMPONENT_TYPE,
              -- Capture sub-components
              11, 'LOGMINER READER',
              12, 'LOGMINER PREPARER',
              13, 'LOGMINER BUILDER',
              14, 'CAPTURE SESSION',
              -- Apply sub-components
              41, 'PROPAGATION SENDER+RECEIVER',
              42, 'APPLY READER',
              43, 'APPLY COORDINATOR',
              44, 'APPLY SERVER',
              NULL),
       S.SESSION_ID,
       S.SESSION_SERIAL#,
       S.STATISTIC_TIME,
       S.STATISTIC_NAME,
       -- State is a varchar2 stored in spare3, everything else is a number
       decode(S.STATISTIC_NAME,
              'STATE', S.SPARE3,
              S.STATISTIC_VALUE),
       S.STATISTIC_UNIT,
       S.ADVISOR_RUN_ID,
       S.ADVISOR_RUN_TIME
FROM streams$_component C,
     streams$_component_stat_out S
WHERE C.COMPONENT_ID = S.COMPONENT_ID
  AND S.STATISTIC_NAME IS NOT NULL
  AND S.STATISTIC_NAME NOT IN (
       'SEND RATE TO APPLY',
       'BYTES SENT VIA SQL*NET TO DBLINK')

View Text - HTML Formatted

SELECT C.COMPONENT_ID
, NVL(C.COMPONENT_NAME
, C.SPARE3) COMPONENT_NAME
, C.COMPONENT_DB
, DECODE(C.COMPONENT_TYPE
, 1
, 'CAPTURE'
, 2
, 'PROPAGATION SENDER'
, 3
, 'PROPAGATION RECEIVER'
, 4
, 'APPLY'
, 5
, 'QUEUE'
, 6
, 'EXTRACT'
, 7
, 'REPLICAT'
, NULL)
, DECODE(S.SUB_COMPONENT_TYPE
, -- CAPTURE SUB-COMPONENTS 11
, 'LOGMINER READER'
, 12
, 'LOGMINER PREPARER'
, 13
, 'LOGMINER BUILDER'
, 14
, 'CAPTURE SESSION'
, -- APPLY SUB-COMPONENTS 41
, 'PROPAGATION SENDER+RECEIVER'
, 42
, 'APPLY READER'
, 43
, 'APPLY COORDINATOR'
, 44
, 'APPLY SERVER'
, NULL)
, S.SESSION_ID
, S.SESSION_SERIAL#
, S.STATISTIC_TIME
, S.STATISTIC_NAME
, -- STATE IS A VARCHAR2 STORED IN SPARE3
, EVERYTHING ELSE IS A NUMBER DECODE(S.STATISTIC_NAME
, 'STATE'
, S.SPARE3
, S.STATISTIC_VALUE)
, S.STATISTIC_UNIT
, S.ADVISOR_RUN_ID
, S.ADVISOR_RUN_TIME FROM STREAMS$_COMPONENT C
, STREAMS$_COMPONENT_STAT_OUT S WHERE C.COMPONENT_ID = S.COMPONENT_ID
AND S.STATISTIC_NAME IS NOT NULL
AND S.STATISTIC_NAME NOT IN ( 'SEND RATE TO APPLY'
, 'BYTES SENT VIA SQL*NET TO DBLINK')