VIEW: SYS._DBA_SXGG_SPLIT_MERGE

Source

View Text - Preformatted

select s.original_capture_name,   s.cloned_capture_name,
       decode(s.original_capture_name, NULL, NULL,
                                       NVL(c1.status, 'DROPPED')),
       decode(s.cloned_capture_name, NULL, NULL,
                                       NVL(c2.status, 'DROPPED')),
       s.original_streams_name,   s.cloned_streams_name,
       decode(s.streams_type, 2, 'PROPAGATION',
                              3, 'APPLY'),
       s.recoverable_script_id,   NVL(decode(r.status, 1, 'GENERATING',
                                                       2, 'NOT EXECUTED',
                                                       3, 'EXECUTING',
                                                       4, 'EXECUTED',
                                                       5, 'ERROR'),
                                      decode(s.recoverable_script_id,
                                                       NULL, NULL,
                                                       'DROPPED')),
       decode(s.action_type, 1, 'SPLIT',
                             2, 'MERGE',
                             3, 'MONITOR'),
       decode(s.action_threshold, 2147483647, 'INFINITE',
                                  s.action_threshold),
       decode(s.status, 1, 'NOTHING TO SPLIT',
                        2, 'ABOUT TO SPLIT',
                        3, 'SPLITTING',
                        4, 'SPLIT DONE',
                        5, 'NOTHING TO MERGE',
                        6, 'ABOUT TO MERGE',
                        7, 'MERGING',
                        8, 'MERGE DONE',
                        9, 'ERROR',
                       10, 'NONSPLITTABLE'),
       s.status_update_time,
       s.creation_time,
       s.lag,
       s.job_owner,               s.job_name,
       decode(s.job_name, NULL, NULL,
                          NVL(j.state, 'DROPPED')),
       decode(s.job_name, NULL, NULL,
                          j.next_run_date),
       s.error_number,            s.error_message,
       c1.purpose
  from sys.streams$_split_merge s, dba_capture c1, dba_capture c2,
       dba_scheduler_jobs j, sys.reco_script$ r
 where s.original_capture_name = c1.capture_name (+)
   and s.cloned_capture_name   = c2.capture_name (+)
   and s.job_name              =  j.job_name     (+)
   and s.job_owner             =  j.owner        (+)
   and s.recoverable_script_id =  r.oid          (+)
   and s.active               != 1

View Text - HTML Formatted

SELECT S.ORIGINAL_CAPTURE_NAME
, S.CLONED_CAPTURE_NAME
, DECODE(S.ORIGINAL_CAPTURE_NAME
, NULL
, NULL
, NVL(C1.STATUS
, 'DROPPED'))
, DECODE(S.CLONED_CAPTURE_NAME
, NULL
, NULL
, NVL(C2.STATUS
, 'DROPPED'))
, S.ORIGINAL_STREAMS_NAME
, S.CLONED_STREAMS_NAME
, DECODE(S.STREAMS_TYPE
, 2
, 'PROPAGATION'
, 3
, 'APPLY')
, S.RECOVERABLE_SCRIPT_ID
, NVL(DECODE(R.STATUS
, 1
, 'GENERATING'
, 2
, 'NOT EXECUTED'
, 3
, 'EXECUTING'
, 4
, 'EXECUTED'
, 5
, 'ERROR')
, DECODE(S.RECOVERABLE_SCRIPT_ID
, NULL
, NULL
, 'DROPPED'))
, DECODE(S.ACTION_TYPE
, 1
, 'SPLIT'
, 2
, 'MERGE'
, 3
, 'MONITOR')
, DECODE(S.ACTION_THRESHOLD
, 2147483647
, 'INFINITE'
, S.ACTION_THRESHOLD)
, DECODE(S.STATUS
, 1
, 'NOTHING TO SPLIT'
, 2
, 'ABOUT TO SPLIT'
, 3
, 'SPLITTING'
, 4
, 'SPLIT DONE'
, 5
, 'NOTHING TO MERGE'
, 6
, 'ABOUT TO MERGE'
, 7
, 'MERGING'
, 8
, 'MERGE DONE'
, 9
, 'ERROR'
, 10
, 'NONSPLITTABLE')
, S.STATUS_UPDATE_TIME
, S.CREATION_TIME
, S.LAG
, S.JOB_OWNER
, S.JOB_NAME
, DECODE(S.JOB_NAME
, NULL
, NULL
, NVL(J.STATE
, 'DROPPED'))
, DECODE(S.JOB_NAME
, NULL
, NULL
, J.NEXT_RUN_DATE)
, S.ERROR_NUMBER
, S.ERROR_MESSAGE
, C1.PURPOSE
FROM SYS.STREAMS$_SPLIT_MERGE S
, DBA_CAPTURE C1
, DBA_CAPTURE C2
, DBA_SCHEDULER_JOBS J
, SYS.RECO_SCRIPT$ R
WHERE S.ORIGINAL_CAPTURE_NAME = C1.CAPTURE_NAME (+)
AND S.CLONED_CAPTURE_NAME = C2.CAPTURE_NAME (+)
AND S.JOB_NAME = J.JOB_NAME (+)
AND S.JOB_OWNER = J.OWNER (+)
AND S.RECOVERABLE_SCRIPT_ID = R.OID (+)
AND S.ACTIVE != 1