Oracle Version: 11.2.0.4.0
Goldengate version: 12.1.0.1.0 for 11G database
OS: SunOS 5.10
Parameter file
EXTRACT ex_ab1
USERIDALIAS chpprdggadmin
EXTTRAIL /clu04/gg_home/ogg12/dirdat/c1
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 128)
TABLE <TABLE_NAME>;
Hello Guys, I am implementing Goldengate in my production environment and am using integrated capture for my primary extract process. When I try to Register my primary extract with the database it is taking way too long for it to get registered.
When I Implemented the integrated capture, the register of the primary extract to the databases in my lower environments took no more than 3 to 4 mins.
By any chance does the primary extract registering in integrated capture have anything to do with the size of the database?
when I looked at the session browser the current statement for the extract register was "ALTER DATABASE ADD SUPPLEMENTAL LOG DATA". after half an hour of waiting i killed the session.
can any one advice on why the registering of the primary extract to the database took so long? or should I just wait for however long the registering might take.
Thank You