Commit frequency when using Oracle Load/Append

[chulett]

For newcomers: to Suppress "Commit point reached" log add SILENT=FEEDBACK option

like this:

APT_ORACLE_LOAD_OPTIONS = OPTIONS(DIRECT=FALSE,PARALLEL=TRUE,SILENT=FEEDBACK)

Not that that helps the commit frequency but may save a few seconds.

FEEDBACK=SILENT makes more sense though, did you mis-type or they really configured it that way?

No, it really goes that bass-ackwards looking way.

Code: Select all

SILENT = [HEADER | FEEDBACK | ERROR | DISCARDS | ALL]