New

. After an Oracle online redo log starts being overwritten, the number of seconds that PowerExchange Express CDC waits for the copy of the log to become available as a new archived redo log for change data capture processing. In an Oracle Data Guard environment, if Express CDC captures change data from a physical standby database, this parameter specifies the number of seconds that Express CDC waits for the next archived redo log to be transported from the primary database to the standby database.

New

. Controls whether PowerExchange Express CDC for Oracle ends with an error or continues processing when the log reader encounters an ALTER TABLE DROP PARTITION operation for a registered Oracle source table.

Y
. Express CDC processing ends with error message PWX-36332, which reports the log position of the DROP PARTITION operation that caused the failure.
N
. Express CDC ignores the DROP PARTITION operation and continues change capture processing. Message PWX-36390 reports that Express CDC encountered a DROP PARTITION operation for a source table.

New

. Controls whether PowerExchange Express CDC can detect when an Oracle KILL SESSION event occurs for a specific PowerExchange connection to an Oracle source instance and then retry the connection so that the Express CDC log reader and PowerExchange Logger for Linux, UNIX, and Windows process do not end abnormally. A KILL SESSION event occurs when a user issues the following SQL statement:

ALTER SYSTEM KILL SESSION ‘
sid,
serial_number’ [IMMEDIATE]

In this statement, the variable

sid

is the session ID and the variable

serial_number

is the session serial number, as shown in the V$SESSION view.

N
. PowerExchange does not try to re-establish killed sessions for Express CDC processes. If a KILL SESSION event occurs, the PowerExchange Express CDC log reader and PowerExchange Logger end abnormally.
Y
. PowerExchange tries to re-establish killed sessions for Express CDC processes. Also set the CONNRETRYMAX parameter to a value greater than 0 to indicate the maximum number of times that PowerExchange retries the connection to the source instance.
The RETRYONKILLSESSION, CONNRETRYMAX, and CONNRETRYWAIT parameters help improve connection resiliency.

New

. Controls whether Express CDC captures or ignores Oracle direct-path operations, such as direct-path INSERT operations, on registered source tables.

N
. Disables the capture of direct-path operations. If the log reader encounters a redo log record for a direct-path operation, Express CDC ignores the direct-path operation with an informational message and continues.
Y.
Enables the capture of direct-path operations.
Express CDC does not capture direct-path operations for tables that use Oracle Exadata Columnar Compression (EHCC).

New

. Allows the PowerExchange Express CDC log reader to read archived redo logs that have been copied to an alternate file system. Use this option in the following situations:

You do not have the authority to access the Oracle archived redo logs directly.
The archived redo logs are written to ASM, but you do not have access to ASM.
An aggressive archived log retention policy is in effect on the database server, which might cause the archived logs to not be retained long enough.

New

. When MODE parameter is set to ARCHIVECOPY, this parameter is required. It specifies the name of the base directory that PowerExchange Express CDC log reader scans for the copies of the archived redo logs to read. To filter the copies of the logs that reside under this base directory, you can also specify the FILE parameter.

New

. Optional. When the MODE parameter is set to ARCHIVECOPY, you can use this parameter to specify a mask for filtering the copies of the archived redo logs that the PowerExchange Express CDC log reader reads. PowerExchange matches the mask against the subdirectories and files under the base directory that is specified in the DIR parameter. Enter a mask for the subdirectory name, log file names, or both.