Values to cache

Specifies the maximum number of values of the sequence that the database manager preallocates and keeps in memory.

During a system failure, all cached sequence values that are yet to be assigned are lost, and thus, will never be used. Therefore, the value specified also represents the maximum number of values for the sequence that could be lost during a system failure.