Sequence cache sizes

Although the SQL:2003 standard does not allow you to specify a cache size, some applications encourage you to change the cache size for better performance. The cache size of a user sequence is derived based the following characteristics:

• The number of sequence values between the minvalue and the maxvalue
• The number of SPUs in the system