Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

PowerExchange Express CDC for Oracle Configuration File

PowerExchange Express CDC for Oracle Configuration File

PowerExchange 10.4.1 introduces a new statement in the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
ASMSTAGING statement
New
. Enables PowerExchange Express CDC to use staging files in an ASM environment to hold chunks of redo log for CDC processing. You can optionally use staging files to improve CDC performance, increase data throughput, and reduce ASM CPU usage, without having to implement Oracle dual logging outside of ASM. When enabled, ASM generates one staging file for each active redo log thread.
Syntax:
ASMSTAGING STAGINGDIR="/
path
/
directory
" [LOCALDIR="/
localmountpoint
/
directory
"] [TARGETSIZE={
50
|
number
}] ;
Parameters descriptions:
STAGINGDIR
Required. The path to the directory that you created for staging files on the machine where the ASM instance to which PowerExchange connects resides. Enclose this value in double-quotation marks ("), for example:
"/oracle/staging"
To optimize ASM data throughput, ensure that the staging directory is on a fast storage device that is local to the ASM instance.
If PowerExchange Express CDC for Oracle is remotely accessing the staging directory, ensure the directory is in NFS storage or another type of shared storage.
LOCALDIR
Optional. The local NFS mount point for the staging directory. Specify this value only if it is different from the STAGINGDIR path. Enclose the value in double-quotation marks ("), for example:
"/localmountpoint/staging"
TARGETSIZE
Optional. The maximum size, in megabytes, of any chunk of redo log to be copied to the staging file. This value also determines the maximum file size.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
.

0 COMMENTS

We’d like to hear from you!