What is ddl9icache
The ddl9icache is a cache file used by Capture process. It stores DDL redo log records for DDL > 1 block, for large body ddls that are broken into pieces. It also stores information related to sequence replication. It is cleaned up after the ddls are sent to the target.