GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Need help to know how to improve performance while using flat file in OGG

User is using below flat file extract and writing in .dsv file.Now he want to improve the performance as user experiencing lag on pump process while  writes in file.

Below are the details of pump process :

--

-- PUMP - Netezza - Load via NZLOAD utility

--

EXTRACT com3ext

NODYNAMICRESOLUTION

SOURCEDEFS ./dirdef/nzcom.def

CUSEREXIT ./flatfilewriter.so CUSEREXIT PASSTHRU INCLUDEUPDATEBEFORES &

PARAMS "./dirprm/com3_ffwriter.properties"

TABLE RDS_BCOM.SYSDBA.CM_SELLER_PROMO_CLAIMS;

Kindly let me know what are the things need to checked from performance point of view and please suggest how to improve the performance.

Thanks in Advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center