Forum Stats

  • 3,837,439 Users
  • 2,262,258 Discussions
  • 7,900,283 Comments

Discussions

Does CLASSIC EXTRACT support centisecs parameters?

fixxxer
fixxxer Member Posts: 1 Red Ribbon

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:

Answers

  • ORASCN
    ORASCN Member Posts: 1,874 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