Database Administrator's Guide

DYNAMIC_DUMP_SYNC_INTERVAL

To reduce the amount of cache the file system devotes to the dynamic dump file, a server configuration keyword allows specifying a periodic file sync operation on the backup generated by dynamic dump approximately every <size> bytes written.

DYNAMIC_DUMP_SYNC_INTERVAL <size> [<scale>]

• <size> must be less than 4GB. Default size is 0, which results in no explicit sync calls on the backup file. The minimum <size> is 1 MB. Non-zero values less than 1MB are increased to 1MB.

This value can be changed at runtime using menu option 10 in the ctadmn command-line utility.