The default size of the block of sequences held in the cache is 20. Does any anyone know if this is 20 *bytes*?
Or 20 *integers*? (Or is it the same thing?
One of the reasons sequence numbers are efficient is that the numbers are cached in ORACLE shared memory area: the SGA. By default, 20 sequence numbers are cached. Once the 20 numbers are allocated, ORACLE must fetch a further 20 from the database. If sequence numbers are being allocated at a very high rate, you can improve the performance by increasing the cache size when you create the sequence:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.