Extract @RANGE stream mainly writting to 1 local trail. (Doc ID 2044785.1)

Last updated on AUGUST 17, 2015

Applies to:

Oracle GoldenGate - Version 11.2.1.0.5 and later
Information in this document applies to any platform.

Goal

Despite creating 10 separate streams using the @RANGE function, we are seeing that almost all data is being written to mainly 1 local trail:

GGSCI > INFO EXTBIP11 DETAIL

EXTRACT EXTBIP11 Last Started 2015-08-06 16:13 Status RUNNING
Checkpoint Lag 02:02:15 (updated 00:00:07 ago)
Log Read Checkpoint Oracle Redo Logs
  2015-08-06 14:12:41 Seqno 8887, RBA 1041694840
  SCN 1067.1431496791 (4584161601623)

 Target Extract Trails:

 Remote Trail Name         Seqno    RBA       Max MB

 ./dirdat/aa                          5      1075        100
 ./dirdat/bb                          4      1075        500
 ./dirdat/cc                           4      1075        500
 ./dirdat/dd                       977     1075         500 <---------------------------------
 ./dirdat/ee                          4      1075         500
 ./dirdat/ff                           4      1075         500
 ./dirdat/gg                          4      1075         500
 ./dirdat/hh                          4      1075         500
 ./dirdat/ii                            4       1075        500
 ./dirdat/jj                            4      1075         500
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms