My Oracle Support Banner

Demoted IO Caused On AIX And JFS2 By Goldengate Process While Writing Data To The Trail Files (Doc ID 2329405.1)

Last updated on JANUARY 13, 2022

Applies to:

Oracle GoldenGate - Version and later
IBM AIX on POWER Systems (64-bit)


Questions below specifically are for AIX and JFS2. If Oracle has any recommendations, please share them.

1. Why is Goldengate causing demoted IO while writing data to the trail files?
2. How to avoid demoted IO by the goldengate process? What are the oracle recommendations to avoid this issue?
3. What is the the block size goldengate uses when it is writing data to the trail files? and is there any parameter with which we can limit the block size for Goldengate process?(For Eg. the DB_BLOCK_SIZE parameter at database level can be used to change the db block to match with OS block size.)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.