December 2002
Intermediate to advanced
928 pages
85h 29m
English
SEQUENCE_CACHE_HASH_BUCKET
Value: 10-SEQUENCE_CACHE_ENTRIES
Default: 7
Specifies the number of buckets used to speed lookup for newly requested sequences in the cache, which is arranged as a hash table. You should specify a prime number as the value for this parameter; if it is not prime, Oracle will raise the value to the next prime number. Obsolete with Oracle8i.