Forum Stats

  • 3,815,265 Users
  • 2,258,988 Discussions
  • 7,893,019 Comments

Discussions

Categories

Does CLASSIC EXTRACT support centisecs parameters?

fixxxer
fixxxer Member Posts: 1 Red Ribbon
in GoldenGate

Hi,


I wanted to check if CLASSIC EXTRACT supports centisecs parameters, such as:

FLUSHCSECS 

EOFDELAYCSECS

I have added these both to the EXTRACT param file, and run a trace, and can see it is not using them; it is still using the default 1 second (delay of 1 second between trace lines).

I upgraded the EXTRACT to INTEGRATED EXTRACT, added these 2 parameters to the param file, and I can see in the trace that it is using the centisecs value set.

Has anyone encountered this before?


Thanks, Brendan.

Tagged:
· Share on TwitterShare on Facebook

Answers

  • ORASCN
    ORASCN Member Posts: 1,868 Bronze Crown

    Hi Brendan,


    Classic Extract for Oracle Database is completely desupported by Oracle and we need to go for Integrated Extract. I haven't tried these parameters on Classic Extract, but it worked very well in Integrated Extract. We achieved sub second latency (end to end) by using these parameters in the Integrated Extract process (also tuned pump and replicat processes).

    You are right, as per the Oracle documentation it should work. But, if your test case proves, it didn't work, then, I would suggest to open an SR with Oracle and check with them.


    May I know what kind of trace you used to check it?


    Regards,

    Veera

    · Share on TwitterShare on Facebook